Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> recovery error RMAN-06053

recovery error RMAN-06053

From: Kaptain524 <Kaptain524_at_zxmail.com>
Date: 14 Jan 2004 16:15:31 -0800
Message-ID: <3f6a20bd.0401141615.9c86c48@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 Wed Jan 14 2004 - 18:15:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US