Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> recovery error RMAN-06053
Hello,
After doing a full database recovery with RMAN (Oracle 9.2), I am getting RMAN-06053. But I can still open the database afterwards and find the recovered data I wanted. Should I be concerned about this error message? Is there anything I can do to prevent it? The documentation says that it means the backup data is not "AVAILABLE." But as far as I can tell, it is. So why am I getting this error?
####### backup script
connect target usr/pass_at_prod
connect catalog rman/pass_at_rcat
SQL "ALTER SYSTEM SWITCH LOGFILE";
BACKUP DATABASE PLUS ARCHIVELOG;
####### recovery script
connect target usr/pass_at_prod;
connect catalog rman/pass_at_rcat;
crosscheck backup;
#restore and replicate the controlfile to the new instance
run {
set until time "TO_DATE( '01/14/2003 13:00:00', 'MM/DD/YYYY
HH24:MI:SS' )";
restore database;
recover database;
}
#######
And here is the error it gives me after the "restore" command:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 01/14/2004 16:10:35RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 1 seq 3 scn 253558 found to restore
Doing a LIST command in RMAN gave me this info about a backupset containing the missing SCN:
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ----------------- 2124 532K DISK 00:00:01 20040114_11:01:25 BP Key: 2125 Status: AVAILABLE Tag: TAG20040114T110124 Piece Name: E:\BACKUPS\20040114_0DFBH7K4_1.002 List of Archived Logs in backup set 2124 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ----------------- ---------- --------- 1 3 253558 20040112_17:06:59 303115 20040114_11:01:18 1 4 303115 20040114_11:01:18 30311820040114_11:01:20
Any help would be appreciated.
Thanks,
Kaptain524
Received on Wed Jan 14 2004 - 18:15:31 CST