Re: recovery error RMAN-06053

hello kaptain,
seems to be a typo in

set until time "TO_DATE( '01/14/2003 13:00:00',

(2003)

ahoi

s.kapitza

Kaptain524_at_zxmail.com (Kaptain524) wrote in message news:<3f6a20bd.0401141615.9c86c48_at_posting.google.com>...
> 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
Received on Thu Jan 15 2004 - 05:27:56 CST