Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rman : restore archivelog =>RMAN-20242: specification does not match any ar

310749Aug 2 2010 — edited Aug 2 2010
Hello,

I want to restore an archivelog from a hot backup.
I have the following error : RMAN-20242: specification does not match any archive log in the recovery catalog
Someone has a idea ?

RMAN> catalog start with 'c:\backup';
RMAN> list backupset 53;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------------
53 35.29M DISK 00:00:00 '02-08-2010 12:26:15'
BP Key: 80 Status: AVAILABLE Compressed: NO Tag: SAVE_ARCHIVELOG
Piece Name: C:\BACKUP\O1_MF_ANNNN_SAVE_ARCHIVELOG_65F7B8WV_.BKP
List of Archived Logs in backup set 53
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------------------- ---------- ---------
1 1 750806 '29-07-2010 12:36:21' 762149 '02-08-2010 09:58:41'
1 2 762149 '02-08-2010 09:58:41' 762160 '02-08-2010 09:58:42'
1 3 762160 '02-08-2010 09:58:42' 764888 '02-08-2010 10:19:33'
1 4 764888 '02-08-2010 10:19:33' 772492 '02-08-2010 12:26:15'

RMAN> list backup of archivelog sequence 2;


RMAN> restore archivelog sequence 2;

Starting restore at '02-08-2010 18:18:52'
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/02/2010 18:18:52
RMAN-20242: specification does not match any archive log in the recovery catalog
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2010
Added on Aug 2 2010
7 comments
5,051 views