Restoring backup fails with RMAN-06054
680825Nov 4 2009 — edited Nov 12 2009I'm trying to restore a 10g database from backup (with catalog) to a new host (disaster recovery) but the recovery fails like this:
unable to find archive log
archive log thread=1 sequence=1234
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/04/2009 16:11:16
RMAN-06054: media recovery requesting unknown log: thread 1 seq 1234 lowscn 83314466
These are the backup scripts I use:
Weekly:
connect target rman/bla@SRV6
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rman/rman/SRV6_DB1/%F.ctrl';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 5G;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/rman/rman/SRV6_DB/snapcf_SRV6_DB.f';
backup database format '/rman/rman/SRV6_DB/ora_df%t_s%s_s%p';
backup archivelog all delete input format '/rman/rman/SRV6_DB/arch_%d_%u_%s';
delete noprompt force obsolete;
report need backup;
Daily:
connect target sys/ind@SRV6_DB
change archivelog all crosscheck;
backup archivelog all delete input format '/rman/rman/SRV6_DB/arch_%d_%u_%s';
delete noprompt force obsolete;
report need backup;
exit;
Now I've looked around here ... googled ... metalinked ... but I'm getting lost a little.
Are the backup scripts not right or am I doing something wrong during restore/recovery?
I can setup a dummy db for rrestore ... restore spfile from autobackup works fine ... restore controlfile from autobackup works fine too ... restore database also no problem ... but recovery shows above error ...