2009/02/20

RMAN-20242 While Trying To Restore ArchiveLogs on RAC

Oracle DB RAC: 10.2.0.2

On RAC database, when you want to restore archivelog files from backup using RMAN,
always remember to specify which thread you want to restore. Otherwise, you will have
the following error:

RMAN-20242: specification does not match any archive log in the recovery catalog

For example, if you want to restore archivelog logseq=9455 for thread 2, then insread of using

RMAN> resoter archivelog logseq=9455;
you shold use

RMAN> resoter archivelog logseq=9455 thread 2;

3 comments:

Devinder said...

Thanks a lot, whosoever you are, this saved me a lot of heartache.

bronix said...

Thanks, it really helps
is using from time 'aaaaa' until time 'bbbbb' includes whatever thread, or I should specify?

Thanks

Unknown said...

Youre so cool! I dont suppose Ive read something like this before. So nice to seek out someone with some unique thoughts on this subject. realy thank you for beginning this up. this web site is one thing that is wanted on the web, someone with a little bit originality. useful job for bringing one thing new to the internet! online casino slots