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-06089: arch_1_16882.arc not found or out of sync with catalog

DEBABRATA ROY -ITANAGAR-INDIA-9402275355Sep 4 2006 — edited Sep 7 2006
Hi,
I am facing a big problem during taking up rman backup. problem is defined below as appeared during backup. Immediate solution required.

$ rman target system nocatalog cmdfile=full_rmanbk_ap;

Recovery Manager: Release 8.1.7.0.0 - Production

target database Password:
target database Password:
RMAN-06005: connected to target database: AGAP (DBID=4188968567)
RMAN-06009: using target database controlfile instead of recovery catalog

RMAN> run
2> {
3> allocate channel c1 type disk format '/home/rmanbkap/b_%u_%s_%p';
4> allocate channel c2 type disk format '/home/rmanbkap/b_%u_%s_%p';
5> allocate channel c3 type disk format '/home/rmanbkap/b_%u_%s_%p';
6> set limit channel c1 kbytes 1600000;
7> set limit channel c2 kbytes 1600000;
8> set limit channel c3 kbytes 1600000;
9> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
10> backup incremental level 0 database;
11> backup archivelog all delete input;
12> copy current controlfile to '/rmanbkap/control01.bak';
13> release channel c1;
14> release channel c2;
15> release channel c3;
16> }
17>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=43 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c2
RMAN-08500: channel c2: sid=44 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c3
RMAN-08500: channel c3: sid=45 devtype=DISK

RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: set limit
RMAN-03023: executing command: set limit

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
RMAN-03023: executing command: sql

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting incremental level 0 datafile backupset
RMAN-08502: set_count=1 set_stamp=600266091 creation_time=04-SEP-06
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=/home2/oracle/sw/oradata/agap/agap01.dbf
RMAN-08522: input datafile fno=00001 name=/home2/oracle/sw/oradata/agap/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08008: channel c2: starting incremental level 0 datafile backupset
RMAN-08502: set_count=2 set_stamp=600266092 creation_time=04-SEP-06
RMAN-08010: channel c2: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00003 name=/home2/oracle/sw/oradata/agap/rbs01.dbf
RMAN-08522: input datafile fno=00004 name=/home2/oracle/sw/oradata/agap/temp01.dbf
RMAN-08522: input datafile fno=00005 name=/home2/oradata/agap/users01.dbf
RMAN-08008: channel c3: starting incremental level 0 datafile backupset
RMAN-08502: set_count=3 set_stamp=600266093 creation_time=04-SEP-06
RMAN-08010: channel c3: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00008 name=/home2/oracle/sw/oradata/agap/ap02.dbf
RMAN-08522: input datafile fno=00006 name=/home2/oracle/sw/oradata/agap/indx01.dbf
RMAN-08522: input datafile fno=00002 name=/home2/oracle/sw/oradata/agap/tools01.dbf
RMAN-08013: channel c2: piece 1 created
RMAN-08503: piece handle=/home/rmanbkap/b_02hselbc_2_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:03:56
RMAN-08013: channel c1: piece 1 created
RMAN-08503: piece handle=/home/rmanbkap/b_01hselbb_1_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:04:32
RMAN-08013: channel c3: piece 1 created
RMAN-08503: piece handle=/home/rmanbkap/b_03hselbd_3_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:04:30

RMAN-03022: compiling command: backup
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-08031: released channel: c2
RMAN-08031: released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: backup
RMAN-06089: archived log /home/oracle/sw/admin/agap/arch/arch_1_16882.arc not found or out of sync with catalog

Recovery Manager complete.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2006
Added on Sep 4 2006
15 comments
7,447 views