标题: RMAN恢复数据库失败的问题 [打印本页] 作者: zhkou 时间: 2003-12-11 19:05 标题: RMAN恢复数据库失败的问题 在用RMAN恢复数据文件时错误提示如下。从List of Archived Logs Included中看，并没有seq=5、seq=6的内容，为何提示：
no backup of log thread 1 seq 6 scn 7889845 found
no backup of log thread 1 seq 5 scn 7779110 found
rman的错误提示：
RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 6 scn 7889845 found to restore
RMAN-06025: no backup of log thread 1 seq 5 scn 7779110 found to restore
alert.log日志：
Full restore complete of datafile 2 /dev/vx/rdsk/oradg/lv_tools01
checkpoint is 7889778
Full restore complete of datafile 3 /dev/vx/rdsk/oradg/lv_rbs
checkpoint is 7889778
Thu Dec 11 18:35:49 2003
alter database recover datafile list
clear
Thu Dec 11 18:35:49 2003
Completed: alter database recover datafile list
clear
Thu Dec 11 18:35:49 2003
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Media Recovery Datafile: 1
Media Recovery Datafile: 2
Media Recovery Datafile: 3
Media Recovery Datafile: 4
Media Recovery Datafile: 5
Media Recovery Datafile: 6
Completed: alter database recover datafile list
1 , 2 , 3 ,
Thu Dec 11 18:35:49 2003
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
Media Recovery Log
ORA-279 signalled during: alter database recover if needed
start until canc...
Thu Dec 11 18:35:50 2003
alter database recover cancel
ORA-1547 signalled during: alter database recover cancel...
另外：
List of Archived Logs Included
Thrd Seq Low SCN Next SCN Low Time Next Time
---- ------- ---------- ---------- --------------- ---------------
1 1 7024952 7025145 19-NOV-03 19-NOV-03
1 2 7025145 7246974 19-NOV-03 24-NOV-03
1 3 7246974 7547981 24-NOV-03 01-DEC-03
