用rman備份升級數據庫遇到ORA-00353錯誤!!!

显示全部楼层 · 2006-11-24 14:24:00

用oracle8.1.7.4數據庫的rman備份升級到oracle9.2.0.7﹐在oracle9.2.0.7中執行完restore database之后﹐接著執行recover database時遇到ORA-00353錯誤。
具體問題﹐請看我下面連續執行的几個recover database﹕
RMAN> recover database; --序列75982已恢復完成﹐在恢復75983時報錯[/COLOR]

Starting recover at 24-11月-06
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 75982 is already on disk as file /oracle/admin/prm/arch/arch_1_75982.arc
archive log thread 1 sequence 75983 is already on disk as file /oracle/admin/prm/arch/arch_1_75983.arc
archive log filename=/oracle/admin/prm/arch/arch_1_75982.arc thread=1 sequence=75982
archive log filename=/oracle/admin/prm/arch/arch_1_75983.arc thread=1 sequence=75983
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2006 14:12:24
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/admin/prm/arch/arch_1_75983.arc'
ORA-00283: recovery session canceled due to errors
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 9279297577353 time 11/24/2006 00:16:50
ORA-00334: archived log: '/oracle/admin/prm/arch/arch_1_75983.arc'
RMAN> recover database; --序列75983已恢復完成﹐在恢復75984時報錯[/COLOR]
Starting recover at 24-11月-06
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 75983 is already on disk as file /oracle/admin/prm/arch/arch_1_75983.arc
archive log filename=/oracle/admin/prm/arch/arch_1_75983.arc thread=1 sequence=75983
archive log filename=/oracle/admin/prm/arch/arch_1_75984.arc thread=1 sequence=75984
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2006 14:15:02
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/admin/prm/arch/arch_1_75984.arc'
ORA-00283: recovery session canceled due to errors
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 9279297577773 time 11/24/2006 00:30:05
ORA-00334: archived log: '/oracle/admin/prm/arch/arch_1_75984.arc'
RMAN> recover database;--序列75984已恢復完成﹐在恢復75985時報錯[/COLOR]
Starting recover at 24-11月-06
using channel ORA_DISK_1
starting media recovery
archive log filename=/oracle/admin/prm/arch/arch_1_75984.arc thread=1 sequence=75984
archive log filename=/oracle/admin/prm/arch/arch_1_75985.arc thread=1 sequence=75985
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/24/2006 14:24:25
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/admin/prm/arch/arch_1_75985.arc'
ORA-00283: recovery session canceled due to errors
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 2 change 9279302668065 time 11/24/2006 06:02:44
ORA-00334: archived log: '/oracle/admin/prm/arch/arch_1_75985.arc'
也就是說每次recover database只能恢復一個歸檔重做日志[/COLOR]