RMAN-06059 ORA-19625 用crosscheck重新同步归档日志后，rman依旧报错

henrywang

AIX5.3 64bit + ORACLE 9.2.0.8.0 RAC



现在做归档备份时报错,报错信息如下：

connected to recovery catalog database

RMAN> run {
2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> sql "alter system switch logfile";
5> sql "alter system switch logfile";
6> sql "alter system switch logfile";
7> backup
8> format "/backdata/rman/data/%d_arch_%s_%p_%D_%M"
9> archivelog all delete input
10> filesperset 10;
11> release channel t1;
12> release channel t2;
13> }
14>
allocated channel: t1
channel t1: sid=57 devtype=DISK

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

sql statement: alter system switch logfile

sql statement: alter system switch logfile

sql statement: alter system switch logfile

Starting backup at 09-OCT-13
current log archived
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/09/2013 12:00:26
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /arch1/1_19451.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

Recovery Manager complete.



我已经用crosscheck重新sync rman备份archive log记录，问题还是存在，我的操作如下：

1. $rman

2. connect target /

3. crosscheck archivelog all;

4. delete expired archivelog all;



我在测试环境做实验，用crosscheck同步归档日志后，没问题，但是在这个生产环境，就不行，请大师帮忙诊断一下，谢谢！

lunar

list archivelog all;
crosscheck archivelog like '/arch1/1_19%';
list archivelog all;

henrywang

RMAN> list archivelog all;

using target database controlfile instead of recovery catalog

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
47424   1    30037   A 09-OCT-13 /arch1/1_30037.dbf
47423   1    30038   A 09-OCT-13 /arch1/1_30038.dbf
47425   1    30039   A 09-OCT-13 /arch1/1_30039.dbf
47426   1    30040   A 09-OCT-13 /arch1/1_30040.dbf
47430   1    30041   A 09-OCT-13 /arch1/1_30041.dbf
47428   1    30042   A 09-OCT-13 /arch1/1_30042.dbf
47429   1    30043   A 09-OCT-13 /arch1/1_30043.dbf
47431   1    30044   A 09-OCT-13 /arch1/1_30044.dbf
47435   1    30045   A 09-OCT-13 /arch1/1_30045.dbf
47434   1    30046   A 10-OCT-13 /arch1/1_30046.dbf
47436   1    30047   A 10-OCT-13 /arch1/1_30047.dbf
47437   1    30048   A 10-OCT-13 /arch1/1_30048.dbf

RMAN> crosscheck archivelog like'/arch1/1_19%';

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=58 devtype=DISK
specification does not match any archive log in the recovery catalog

问题还存在