最近在做巡检的时候发现,有台数据库服务器归档日志备份经常会出现一些问题,"specification does not match any archive log in the recovery catalog"，估计是arch目录中的文件名称和catalog中的文件名称有差异.所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常.

1.连接数据库

rman target / catalog rman/rman@fjrman --> 在db01上连接dp的备份数据库.fjrman为备份数据库的连接串

2.Crosscheck日志

RMAN> crosscheck archivelog all;

configuration for SBT_TAPE channel 2 is ignored
configuration for SBT_TAPE channel 3 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=108 devtype=DISK
validation failed for archived log
archive log filename=/archlog1/1_2.dbf recid=6 stamp=610532020
validation failed for archived log
archive log filename=/archlog1/1_3.dbf recid=1 stamp=610532011
validation failed for archived log
archive log filename=/archlog1/1_4.dbf recid=3 stamp=610532011
validation failed for archived log
archive log filename=/archlog1/1_5.dbf recid=4 stamp=610532012
validation failed for archived log
archive log filename=/archlog1/1_6.dbf recid=7 stamp=610532020
validation failed for archived log
archive log filename=/archlog1/1_7.dbf recid=8 stamp=610532022
validation failed for archived log
archive log filename=/archlog1/fjmisc1_1_8.arc recid=10 stamp=610533140

...................

2.使用list expired archivelog all 命令查看所有过期归档日志:

RMAN> list expired archivelog all;

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
21288 1 2 X 30-DEC-06 /archlog1/1_2.dbf
21283 1 3 X 30-DEC-06 /archlog1/1_3.dbf
21285 1 4 X 30-DEC-06 /archlog1/1_4.dbf
21286 1 5 X 30-DEC-06 /archlog1/1_5.dbf
21289 1 6 X 30-DEC-06 /archlog1/1_6.dbf
21290 1 7 X 30-DEC-06 /archlog1/1_7.dbf
21292 1 8 X 30-DEC-06 /archlog1/fjmisc1_1_8.arc
21293 1 9 X 30-DEC-06 /archlog1/fjmisc1_1_9.arc
21294 1 10 X 30-DEC-06 /archlog1/fjmisc1_1_10.arc
21296 1 11 X 30-DEC-06 /archlog1/fjmisc1_1_11.arc

.........................

3.使用delete expired archivelog all 命令删除所有过期归档日志:

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=108 devtype=DISK

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
21288 1 2 X 30-DEC-06 /archlog1/1_2.dbf
21283 1 3 X 30-DEC-06 /archlog1/1_3.dbf
21285 1 4 X 30-DEC-06 /archlog1/1_4.dbf
21286 1 5 X 30-DEC-06 /archlog1/1_5.dbf
21289 1 6 X 30-DEC-06 /archlog1/1_6.dbf
21290 1 7 X 30-DEC-06 /archlog1/1_7.dbf
21292 1 8 X 30-DEC-06 /archlog1/fjmisc1_1_8.arc
21293 1 9 X 30-DEC-06 /archlog1/fjmisc1_1_9.arc
21294 1 10 X 30-DEC-06 /archlog1/fjmisc1_1_10.arc
21296 1 11 X 30-DEC-06 /archlog1/fjmisc1_1_11.arc
21297 1 12 X 30-DEC-06 /archlog1/fjmisc1_1_12.arc

.................

deleted archive log
archive log filename=/archlog2/fjmisc2_2_16385.arc recid=37536 stamp=676718350
Deleted 1582 EXPIRED objects

----The End------

感谢 Jimmy He 对在此过程中的技术支持..