大家好,
本人是oracle database 初学者,在用rman 备份数据库后进行最后一步recover database恢复时提示找不到归档日志,但在备份时有进行过归档日志的备份.还请多多指教.
RMAN> recover database;
Starting recover at 30-SEP-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
unable to find archive log
archive log thread=1 sequence=2
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\RMAN\SYSTEM01.DBF'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/30/2007 08:08:21
RMAN-06054: media recovery requesting unknown log: thread 1 scn 1422244
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\RMAN\SYSTEM01.DBF'
怎么提示没还原file1啊
list backup of archivelog all ; 看下有没sequence#为2的
多谢各位兄弟的指教,我检查了日志文件,确实没有'D:\ORACLE\ORADATA\RMAN\SYSTEM01.DBF'的记录
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2077MDISK00:00:12 24-SEP-07
BP Key: 20 Status: EXPIRED Tag: TAG20070924T125413
Piece Name: D:\ORACLE\RMANBAK\0JISO9FL_1_1
List of Archived Logs in backup set 20
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
12 244954 19-SEP-07 464562 20-SEP-07
List of Archived Logs in backup set 33
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
12 109137626-SEP-07 125662827-SEP-07
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3499MDISK00:00:12 27-SEP-07
BP Key: 34 Status: EXPIRED Tag: TAG20070927T162019
Piece Name: D:\ORACLE\RMANBAK\1FIT0IM4_1_1