Re: recovery error RMAN-06053

On 14 Jan 2004 16:15:31 -0800, Kaptain524_at_zxmail.com (Kaptain524) wrote:

>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:35
>RMAN-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 303118
>20040114_11:01:20
>
>
>Any help would be appreciated.
>
>Thanks,
>Kaptain524

The error message means your recovery failed, and you have incomplete recovery.
So yes, you need to be concerned about this message. Your list command tells you the archivelog is stored in the recovery catalog or in the controlfile. It doesn't check the file is present on disk. The error message tells you it isn't.

--
Sybrand Bakker, Senior Oracle DBA