Home » RDBMS Server » Backup & Recovery » RMAN-20242: specification does not match any archive log in the recovery catalog (solaris 10 oracle 10.2.0.3)
RMAN-20242: specification does not match any archive log in the recovery catalog [message #334726] Thu, 17 July 2008 15:13 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
experts,

archive backup was failing for following error. i checked the v$archived_log and i did not find any archive logs over there. what could be the reason. please find error stack.

can any one help me where i was wrong.

run {
12> allocate channel dev1 type 'SBT_TAPE';
13> allocate channel dev2 type 'SBT_TAPE';
14> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
15> backup
16>         format 'ctl_%d_%t_%s_%p'
17>         tag 'archiveset_ctl'
18>         current controlfile ;
19> backup
20>         filesperset=30
21>         setsize=6000000
22>         format='arch_%d_%t_%s_%p'
23>         archivelog like 
23> '/opt/mis/oracle/admin/BCXSINT/arch/BCXSINT%' delete input;
24> }
25> 
allocated channel: dev1
channel dev1: sid=1051 devtype=SBT_TAPE
channel dev1: VERITAS NetBackup for Oracle - Release 5.1 (2006040521)

allocated channel: dev2
channel dev2: sid=2166 devtype=SBT_TAPE
channel dev2: VERITAS NetBackup for Oracle - Release 5.1 (2006040521)

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

Starting backup at 17-JUL-08
channel dev1: starting full datafile backupset
channel dev1: specifying datafile(s) in backupset including current control file in backupset
channel dev1: starting piece 1 at 17-JUL-08
channel dev1: finished piece 1 at 17-JUL-08
piece handle=ctl_PLAZATRL_660270225_3_1 tag=ARCHIVESET_CTL comment=API Version 2.0,MMS Version 5.0.0.0
channel dev1: backup set complete, elapsed time: 00:00:46
Finished backup at 17-JUL-08

Starting backup at 17-JUL-08
released channel: dev1
released channel: dev2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/17/2008 00:24:31
RMAN-20242: specification does not match any archive log in the recovery catalog

Recovery Manager complete.
07/17/08 00:24:31: Job failed: notification sent

[Mod-edit: Reformatted post]

[Updated on: Thu, 17 July 2008 18:57] by Moderator

Report message to a moderator

Re: RMAN-20242: specification does not match any archive log in the recovery catalog [message #334761 is a reply to message #334726] Thu, 17 July 2008 18:52 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Ensure the LIKE clause that you specify actually matches your archivelog directory path and format.

You may also want to run the following:
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
Previous Topic: Configuring RMAN with MML.
Next Topic: RMAN backups
Goto Forum:
  


Current Time: Wed Apr 24 14:39:30 CDT 2024