Home » RDBMS Server » Backup & Recovery » Recovery fails on archived log, which is in the backup set.
Recovery fails on archived log, which is in the backup set. [message #533989] Fri, 02 December 2011 01:13 Go to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello All,

I ran the Full database backup as,

RUN {ALLOCATE CHANNEL CH0 TYPE 'sbt_tape';
BACKUP DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT;
RELEASE CHANNEL CH0;
}


Then I ran the restore, it failed with
Quote:
RMAN-06054: media recovery requesting unknown archived log....


When I backup archivelogs and choose to delete the input, it does not delete the multiplexed copy, but the specific file being backed up.
So, ideally it should find it in Flah Area or at least in the backed up pieces which are there with it.
Still why is it failing?

Also, in recovery, it is deleting the archived log after applying, RMAN does this if we use
recover...  delete archivelog
command.
I am using only RECOVER, still in output I can see RMAN deleting the log after it has applied it. WHY?

Thannks & Regards,
swaorclser
Re: Recovery fails on archived log, which is in the backup set. [message #533993 is a reply to message #533989] Fri, 02 December 2011 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT explain what you think you did.
SHOW US!

Regards
Michel
Re: Recovery fails on archived log, which is in the backup set. [message #534002 is a reply to message #533993] Fri, 02 December 2011 01:43 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Okay!

I have already posted the backup script which I had run.

Here is the restore/recover script I fired,

RUN {
ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';
RESTORE CONTROLFILE FROM 'BE_1hmsq56m_1_1';
ALTER DATABASE MOUNT;
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL ch0;
alter database open resetlogs;
}


output

Quote:

unable to find archived log
archived log thread=1 sequence=31
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/29/2011 14:18:16
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 31 and starting SCN of 1666945


Thanks & Regards,
swaorclser
Re: Recovery fails on archived log, which is in the backup set. [message #534003 is a reply to message #534002] Fri, 02 December 2011 01:48 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I want the complete RMAN session, backup and restore.

Quote:
unable to find archived log

The message is clear.
Whatever you think RMAN is unable to find it either in backup or in archived logs destination.

Regards
Michel
Previous Topic: ORA-00283: recovery session canceled due to errors
Next Topic: Corrupt control file?
Goto Forum:
  


Current Time: Fri Mar 29 07:38:06 CDT 2024