Recovery fails with 06053 and 06025
Date: Wed, 16 Jul 2008 22:29:39 -0700 (PDT)
Message-ID: <a17cbf84-77aa-4f89-bb4f-9d5d92893b44@z72g2000hsb.googlegroups.com>
Hello,
First of all I have no experience on Oracle. I'm simple programmer with task out of my skills.
I was given task to restore database to a new location with few simple commands.
First I take full backup of the database with RMAN
BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 4; DELETE OBSOLETE; Then I do restore to another location.
I connect the target and so
Then I restore controlfile from autobackup maxdays=10; Everything goes fine I mount the database,
Then I use restore database;
That goes fine.
After that all goes wrong.
I tried to do
RMAN> recover database delete archivelog;
K$B&2(Bynnistet$B&2&2(Bn recover, 16.07.2008 k$B&2(Byt$B!`(Bss$B&2(B on kanava ORA_DISK_1
k$B&2(Bynnistet$B&2&2(Bn v$B&2(Blinepalautuminen
RMAN-00571:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
RMAN-00579: the following error occurred at 07/16/2008 20:29:31 RMAN-03002: failure during compilation of command RMAN-03013: command type: recover RMAN-03002: failure during compilation of command RMAN-03013: command type: recover(4) RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 1 seq 453183 scn 4864997667 foundto restore
RMAN-06025: no backup of log thread 1 seq 453182 scn 4864993160 found to restore
RMAN-06025: no backup of log thread 1 seq 453181 scn 4864988601 found to restore
RMAN-06025: no backup of log thread 1 seq 453180 scn 4864985052 found to restore
...
Okay so I understand I'm missing something. I tried to do recovery until the time last full backup was taken no help. Then I tried to do until last sequence i found from List backup. I always keep getting the same errors.
Finaly I tried to do following
SQL> recover database using backup controlfile until cancel;
No it says that it's missing following redolog REDOLOGS\AAS_356807.ARC and change 4078425941 made in 11/28/2007 13:40:26 thread 1 sequence 356807
Of course such REDOLOG can't be found. Or I have no idea where to find it.
I have no idea how to get pass this problem. Any ideas?
I don't even have access to metalink ;( Received on Thu Jul 17 2008 - 00:29:39 CDT