RMAN-20242: specification does not match any archive log in the recovery catalog [message #334726] |
Thu, 17 July 2008 15:13 |
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
|
|
|
|