» rac的dp备份时候报错RMAN-20242 OracleBlog.cn -天堂向左 DBA向右

rac的dp备份时候报错RMAN-20242

· 作者小荷||【转载时请务必以超链接形式标明文章原始出处和作者信息】
· 永久链接: http://www.oracleblog.cn/working-case/rman-20242-on-rac/

今天收到一个rac省的dp报错记录：

[Normal] From: BSM@fj-bak01 "" Time: 2009-3-9 9:10:11
   The session "2009/03/09-1" will be restarted.

[Normal] From: BSM@fj-bak01 "" Time: 2009-3-9 9:10:11
   Restart backup specification found: "Oracle8 fjmisc2_arch".

[Normal] From: BSM@fj-bak01 "fjmisc2_arch" Time: 2009-3-9 9:10:13
   OB2BAR application on "fj_db02" successfully started.

ob2rman.exe started with arguments:
   -backup -full

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: FJMISC (DBID=169290886)

RMAN>
connected to recovery catalog database

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch,OB2BARHOSTNAME=fj_db02)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch,OB2BARHOSTNAME=fj_db02)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch,OB2BARHOSTNAME=fj_db02)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch,OB2BARHOSTNAME=fj_db02)';
10> crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
11> backup
12> format 'fjmisc2_arch<fjmisc2_%s:%t:%p>.dbf'
13> archivelog like '/archlog2/fjmisc2%'
14> delete input;
15> }
allocated channel: dev_0
channel dev_0: sid=251 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330

allocated channel: dev_1
channel dev_1: sid=276 devtype=SBT_TAPE
channel dev_1: Data Protector A.05.50/330

allocated channel: dev_2
channel dev_2: sid=204 devtype=SBT_TAPE
channel dev_2: Data Protector A.05.50/330

allocated channel: dev_3
channel dev_3: sid=301 devtype=SBT_TAPE
channel dev_3: Data Protector A.05.50/330

validation succeeded for archived log
archive log filename=/archlog1/fjmisc1_1_21584.arc recid=38312 stamp=681012033
validation succeeded for archived log
archive log filename=/archlog1/fjmisc1_1_21585.arc recid=38315 stamp=681032056
Crosschecked 2 objects

Starting backup at 03/09/2009 [09:16:19]
released channel: dev_0
released channel: dev_1
released channel: dev_2
released channel: dev_3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/09/2009 09:16:19
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN> **end-of-file**

RMAN>

Recovery Manager complete.
[Major] From: ob2rman.exe@FJ_DB02 "fjmisc2" Time: 03/09/09 09:16:19

看到这个log，一开始的感觉是手工删除arch过了，上数据库主机做了crosscheck，发现在db01上关于db02的arch都是expired的状态。通过bdf检查发现在db01上，只能看到archlog1的目录，而在db02上，能看到archlog1和archlog2。感觉是共享的文件系统出了问题，把主机工程师叫上来一看，nfs早就不用了，哦，那为何之前的备份都没问题，只是昨天的备份报错了？

检查了备份的脚本，发现是针对2个主机备份的，确实没用nfs，针对db01的备份脚本为：

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch)';
crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
backup
format 'fjmisc1_arch<fjmisc1_%s:%t:%p>.dbf'
archivelog like '/archlog1/fjmisc1%'
delete input;
}

针对db02的备份脚本为：

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch)';
allocate channel 'dev_2' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch)';
allocate channel 'dev_3' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc2,OB2BARLIST=fjmisc2_arch)';
crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
backup
format 'fjmisc2_arch<fjmisc2_%s:%t:%p>.dbf'
archivelog like '/archlog2/fjmisc2%'
delete input;
}

在这里，通过检查发现这样一个用法：

archivelog like '/archlog2/fjmisc2%'

这个like，其实是有缺陷的：

当我们如果存在like的归档日志，那么备份是没有问题的；但是如果不存在归档日志，那么rman备份的时候就会报错20242了，我们看下面的这个小实验：

$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 9 11:03:20 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/product/9.2.0.4/dbs/arch
Oldest online log sequence 30
Next log sequence to archive 33
Current log sequence 33
-- 检查归档情况，发现当前没有一个归档日志在归档路径：
SQL> !ll /oracle/product/9.2.0.4/dbs/arch
total 0

SQL>
-- 切出几个归档日志：
SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.
--检查是否已经存在归档日志了
SQL> !ll /oracle/product/9.2.0.4/dbs/arch
total 2440
-rw-rw---- 1 oracle dba 1225728 Mar 9 11:03 ora9i_1_33.arc
-rw-rw---- 1 oracle dba 2048 Mar 9 11:03 ora9i_1_34.arc
-rw-rw---- 1 oracle dba 4096 Mar 9 11:03 ora9i_1_35.arc

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
$
$
$
$
--开始做rman的备份，注意我们用到了like这个关键字：
$ rman target / nocatalog

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: ORA9I (DBID=2432039804)
using target database controlfile instead of recovery catalog

RMAN> run {
2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> allocate channel t3 type disk;
5> allocate channel t4 type disk;
6> crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
7> backup
8> format 'arch_%u%p%s.rmn'
9> archivelog like '/oracle/product/9.2.0.4/dbs/arch/ora9i_1%'
10> delete input;
11> }

allocated channel: t1
channel t1: sid=16 devtype=DISK

allocated channel: t2
channel t2: sid=17 devtype=DISK

allocated channel: t3
channel t3: sid=18 devtype=DISK

allocated channel: t4
channel t4: sid=19 devtype=DISK

validation succeeded for archived log
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_33.arc recid=4 stamp=681044622
validation succeeded for archived log
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_34.arc recid=5 stamp=681044622
validation succeeded for archived log
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_35.arc recid=6 stamp=681044623
Crosschecked 3 objects

Starting backup at 09-MAR-09
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=33 recid=4 stamp=681044622
channel t1: starting piece 1 at 09-MAR-09
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=1 sequence=34 recid=5 stamp=681044622
channel t2: starting piece 1 at 09-MAR-09
channel t3: starting archive log backupset
channel t3: specifying archive log(s) in backup set
input archive log thread=1 sequence=35 recid=6 stamp=681044623
channel t3: starting piece 1 at 09-MAR-09
channel t1: finished piece 1 at 09-MAR-09
piece handle=/oracle/product/9.2.0.4/dbs/arch_02k9fqlf12.rmn comment=NONE
channel t1: backup set complete, elapsed time: 00:00:02
channel t1: deleting archive log(s)
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_33.arc recid=4 stamp=681044622
channel t2: finished piece 1 at 09-MAR-09
piece handle=/oracle/product/9.2.0.4/dbs/arch_03k9fqlf13.rmn comment=NONE
channel t2: backup set complete, elapsed time: 00:00:02
channel t2: deleting archive log(s)
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_34.arc recid=5 stamp=681044622
channel t3: finished piece 1 at 09-MAR-09
piece handle=/oracle/product/9.2.0.4/dbs/arch_04k9fqlf14.rmn comment=NONE
channel t3: backup set complete, elapsed time: 00:00:02
channel t3: deleting archive log(s)
archive log filename=/oracle/product/9.2.0.4/dbs/arch/ora9i_1_35.arc recid=6 stamp=681044623
Finished backup at 09-MAR-09
released channel: t1
released channel: t2
released channel: t3
released channel: t4

RMAN>

RMAN>

RMAN> exit

Recovery Manager complete.
$
--当存在归档日志的时候，备份没问题。
--由于已经被备走了归档日志，当前归档目录下没有归档日志，我们再来测试一下like关键字的备份：
$ ll /oracle/product/9.2.0.4/dbs/arch
total 0
$
$
$
$ rman target / nocatalog

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: ORA9I (DBID=2432039804)
using target database controlfile instead of recovery catalog

RMAN>

RMAN> run {
2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> allocate channel t3 type disk;
5> allocate channel t4 type disk;
6> crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
7> backup
8> format 'arch_%u%p%s.rmn'
9> archivelog like '/oracle/product/9.2.0.4/dbs/arch/ora9i_1%'
10> delete input;
11> }

allocated channel: t1
channel t1: sid=18 devtype=DISK

allocated channel: t2
channel t2: sid=17 devtype=DISK

allocated channel: t3
channel t3: sid=16 devtype=DISK

allocated channel: t4
channel t4: sid=11 devtype=DISK

specification does not match any archive log in the recovery catalog

Starting backup at 09-MAR-09
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/09/2009 11:04:45
RMAN-20242: specification does not match any archive log in the recovery catalog

RMAN>

RMAN>
--看，这里就报错了！！

了解了故障原因，解决的方法就比较容易了。在这里介绍2种方式：
1.在备份脚本中添加sql ‘alter system archivelog current’;使得在备份前手工的切出一个归档日志，不会在上次备份之后，一次归档都还没有切，找不到like关键字需要的归档。
2.使用skip inaccessible。

以下是2种解决方式的dp的log，均备份成功了：

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:19:28
   OB2BAR application on "fj_db01" successfully started.

ob2rman.exe started with arguments:
   -backup -full

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: FJMISC (DBID=169290886)

RMAN>
connected to recovery catalog database

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
10> sql 'alter system archive log current';
11> crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
12> backup
13> format 'fjmisc1_arch<fjmisc1_%s:%t:%p>.dbf'
14> archivelog like '/archlog1/fjmisc1%'
15> delete input;
16> }
allocated channel: dev_0
channel dev_0: sid=238 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330

allocated channel: dev_1
channel dev_1: sid=126 devtype=SBT_TAPE
channel dev_1: Data Protector A.05.50/330

allocated channel: dev_2
channel dev_2: sid=291 devtype=SBT_TAPE
channel dev_2: Data Protector A.05.50/330

allocated channel: dev_3
channel dev_3: sid=241 devtype=SBT_TAPE
channel dev_3: Data Protector A.05.50/330

sql statement: alter system archive log current

validation succeeded for archived log
archive log filename=/archlog1/fjmisc1_1_21588.arc recid=38323 stamp=681045935
validation failed for archived log
archive log filename=/archlog2/fjmisc2_2_16884.arc recid=38321 stamp=681045603
validation failed for archived log
archive log filename=/archlog2/fjmisc2_2_16885.arc recid=38324 stamp=681045936
Crosschecked 3 objects

Starting backup at 03/09/2009 [11:25:46]
channel dev_0: starting archive log backupset
channel dev_0: specifying archive log(s) in backup set
input archive log thread=1 sequence=21588 recid=38323 stamp=681045935
channel dev_0: starting piece 1 at 03/09/2009 [11:25:48]
[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:25:53
   STARTING Media Agent "HP:Ultrium 2-SCSI_1_fj_db02"

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:25:54
   By: UMA@fj_db02@/dev/rac/c4t0d0
   Loading medium from slot 1 to device /dev/rmt/1mn

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:26:47
   Starting OB2BAR Backup: fj_db01:fjmisc1_arch<fjmisc1_32561:681045946:1>.dbf "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:27:39
   Completed OB2BAR Backup: fj_db01:fjmisc1_arch<fjmisc1_32561:681045946:1>.dbf "Oracle8"

channel dev_0: finished piece 1 at 03/09/2009 [11:27:43]
piece handle=fjmisc1_arch<fjmisc1_32561:681045946:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_0: backup set complete, elapsed time: 00:01:57
channel dev_0: deleting archive log(s)
archive log filename=/archlog1/fjmisc1_1_21588.arc recid=38323 stamp=681045935
Finished backup at 03/09/2009 [11:27:43]
released channel: dev_1
released channel: dev_2
released channel: dev_3
released channel: dev_0

RMAN> **end-of-file**

RMAN>

Recovery Manager complete.
[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:27:45
   Oracle RMAN successfully finished.

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:27:45
   Issuing DP Managed Control File Backup ...

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:27:50
   Starting OB2BAR Backup: fj_db01:fjmisc1 DP Managed Control File Backup "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:27:53
   Completed OB2BAR Backup: fj_db01:fjmisc1 DP Managed Control File Backup "Oracle8"

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:27:54
   Starting backup of the Oracle Recovery Catalog Database ...

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:27:54
   Getting NLS_LANG and setting it into the environment ....

   AMERICAN_AMERICA.ZHS16GBK

   Default exp binary /oracle/app/oracle/product/9.2.0/bin/exp is used for catalog export.

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:28:17
   Export of the Recovery Catalog succeeded. Proceeding to backup.

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:28:18
   Starting OB2BAR Backup: fj_db01:Oracle Recovery Backup Catalog "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:28:23
   Completed OB2BAR Backup: fj_db01:Oracle Recovery Backup Catalog "Oracle8"

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:28:23
   Backup of the Oracle Catalog Database succeeded.

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:22:27
   OB2BAR application on "fj_db01" disconnected.

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:29:12
   /dev/rmt/1mn
   Medium header verification completed, 0 errors found

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:29:29
   By: UMA@fj_db02@/dev/rac/c4t0d0
   Unloading medium to slot 1 from device /dev/rmt/1mn

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:29:41
   COMPLETED Media Agent "HP:Ultrium 2-SCSI_1_fj_db02"

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:23:44

   Backup Statistics:

   Session Queuing Time (hours) 0.02
   ----------------------------------------
   Completed Disk Agents ........ 3
   Failed Disk Agents ........... 0
   Aborted Disk Agents .......... 0
   ----------------------------------------
   Disk Agents Total ........... 3
   ========================================
   Completed Media Agents ....... 1
   Failed Media Agents .......... 0
   Aborted Media Agents ......... 0
   ----------------------------------------
   Media Agents Total .......... 1
   ========================================
   Mbytes Total ................. 58 MB
   Used Media Total ............. 1
   Disk Agent Errors Total ...... 0

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:39:33
   OB2BAR application on "fj_db01" successfully started.

ob2rman.exe started with arguments:
   -backup -full

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: FJMISC (DBID=169290886)

RMAN>
connected to recovery catalog database

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=fjmisc1,OB2BARLIST=fjmisc1_arch,OB2BARHOSTNAME=fj_db01)';
10> crosscheck archivelog from time 'sysdate-1' until time 'sysdate';
11> backup
12> format 'fjmisc1_arch<fjmisc1_%s:%t:%p>.dbf'
13> archivelog all
14> delete input
15> skip inaccessible;
16> }
allocated channel: dev_0
channel dev_0: sid=456 devtype=SBT_TAPE
channel dev_0: Data Protector A.05.50/330

allocated channel: dev_1
channel dev_1: sid=306 devtype=SBT_TAPE
channel dev_1: Data Protector A.05.50/330

allocated channel: dev_2
channel dev_2: sid=45 devtype=SBT_TAPE
channel dev_2: Data Protector A.05.50/330

allocated channel: dev_3
channel dev_3: sid=412 devtype=SBT_TAPE
channel dev_3: Data Protector A.05.50/330

validation failed for archived log
archive log filename=/archlog2/fjmisc2_2_16884.arc recid=38321 stamp=681045603
validation failed for archived log
archive log filename=/archlog2/fjmisc2_2_16885.arc recid=38324 stamp=681045936
Crosschecked 2 objects

Starting backup at 03/09/2009 [11:45:39]
current log archived
archived log /archlog2/fjmisc2_2_16886.arc not found or out of sync with catalog
skipping inaccessible file /archlog2/fjmisc2_2_16886.arc
RMAN-06061: WARNING: skipping archivelog compromises recoverability
channel dev_0: starting archive log backupset
channel dev_0: specifying archive log(s) in backup set
input archive log thread=1 sequence=21589 recid=38325 stamp=681047144
channel dev_0: starting piece 1 at 03/09/2009 [11:45:51]
[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:45:57
   STARTING Media Agent "HP:Ultrium 2-SCSI_1_fj_db02"

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:45:58
   By: UMA@fj_db02@/dev/rac/c4t0d0
   Loading medium from slot 1 to device /dev/rmt/1mn

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:46:52
   Starting OB2BAR Backup: fj_db01:fjmisc1_arch<fjmisc1_32562:681047150:1>.dbf "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:47:51
   Completed OB2BAR Backup: fj_db01:fjmisc1_arch<fjmisc1_32562:681047150:1>.dbf "Oracle8"

channel dev_0: finished piece 1 at 03/09/2009 [11:47:57]
piece handle=fjmisc1_arch<fjmisc1_32562:681047150:1>.dbf comment=API Version 2.0,MMS Version 65.5.50.74
channel dev_0: backup set complete, elapsed time: 00:02:07
channel dev_0: deleting archive log(s)
archive log filename=/archlog1/fjmisc1_1_21589.arc recid=38325 stamp=681047144
Finished backup at 03/09/2009 [11:47:57]
released channel: dev_1
released channel: dev_2
released channel: dev_3
released channel: dev_0

RMAN> **end-of-file**

RMAN>

Recovery Manager complete.
[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:47:59
   Oracle RMAN successfully finished.

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:47:59
   Issuing DP Managed Control File Backup ...

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:48:04
   Starting OB2BAR Backup: fj_db01:fjmisc1 DP Managed Control File Backup "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:48:07
   Completed OB2BAR Backup: fj_db01:fjmisc1 DP Managed Control File Backup "Oracle8"

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:48:08
   Starting backup of the Oracle Recovery Catalog Database ...

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:48:08
   Getting NLS_LANG and setting it into the environment ....

   AMERICAN_AMERICA.ZHS16GBK

   Default exp binary /oracle/app/oracle/product/9.2.0/bin/exp is used for catalog export.

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:48:32
   Export of the Recovery Catalog succeeded. Proceeding to backup.

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:48:32
   Starting OB2BAR Backup: fj_db01:Oracle Recovery Backup Catalog "Oracle8"

[Normal] From: OB2BAR_Oracle8@fj_db01 "fjmisc1" Time: 2009-3-9 11:48:37
   Completed OB2BAR Backup: fj_db01:Oracle Recovery Backup Catalog "Oracle8"

[Normal] From: ob2rman.exe@FJ_DB01 "fjmisc1" Time: 03/09/09 11:48:38
   Backup of the Oracle Catalog Database succeeded.

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:42:41
   OB2BAR application on "fj_db01" disconnected.

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:49:27
   /dev/rmt/1mn
   Medium header verification completed, 0 errors found

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:49:45
   By: UMA@fj_db02@/dev/rac/c4t0d0
   Unloading medium to slot 1 from device /dev/rmt/1mn

[Normal] From: BMA@fj_db02 "HP:Ultrium 2-SCSI_1_fj_db02" Time: 2009-3-9 11:49:57
   COMPLETED Media Agent "HP:Ultrium 2-SCSI_1_fj_db02"

[Normal] From: BSM@fj-bak01 "fjmisc1_arch" Time: 2009-3-9 11:44:01

   Backup Statistics:

   Session Queuing Time (hours) 0.00
   ----------------------------------------
   Completed Disk Agents ........ 3
   Failed Disk Agents ........... 0
   Aborted Disk Agents .......... 0
   ----------------------------------------
   Disk Agents Total ........... 3
   ========================================
   Completed Media Agents ....... 1
   Failed Media Agents .......... 0
   Aborted Media Agents ......... 0
   ----------------------------------------
   Media Agents Total .......... 1
   ========================================
   Mbytes Total ................. 135 MB
   Used Media Total ............. 1
   Disk Agent Errors Total ...... 0

· 【文章发布信息】发表于： 2009-03-09 @ 14:15:09 · ||分类： ..experience, Working case

1 条评论 »

hoorace 于 2009-03-10 @ 22:33:20 留言：

建议以后公司的oracle的培训你来弄算了。

RSS 为此帖反馈评论 · 反向跟踪网站

OracleBlog.cn -天堂向左 DBA向右