最近在做巡检的时候发现,有台数据库服务器归档日志备份经常会出现一些问题,"specification does not match any archive log in the recovery catalog",估计是arch目录中的文件名称和catalog中的文件名称有差异.所以此时需要手工执行crosscheck过程,之后Rman备份可以恢复正常.
[@more@]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 对在此过程中的技术支持..
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/60217/viewspace-1016352/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/60217/viewspace-1016352/