OraFAQ Forum: Backup & Recovery » Recovery fails on archived log, which is in the backup set.

Home » RDBMS Server » Backup & Recovery » Recovery fails on archived log, which is in the backup set.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery fails on archived log, which is in the backup set. [message #533989]

Fri, 02 December 2011 01:13

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

Report message to a moderator

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

Michel Cadot
Messages: 68509
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do NOT explain what you think you did.
SHOW US!

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68509
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 21:20:55 CDT 2023