hi all,

i am trying to recover a full database backup using rman. the full database backup is running without any problems. if i want to recover a full backup, at the end rman complains about a missing archivelog

RMAN-08060: unable to find archivelog
RMAN-08510: archivelog thread=1 sequence=3

during the backup only the logsequence 2 is backed up and available ...

RMAN-08504: input archivelog thread=1 sequence=2 recid=10 stamp=458922052
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/arch_P42_08dll625_1 comment=NONE

so i don't understand why rman looks for the sequence 3 during media recovery ...

below i attached the whole output of the backup and the restore (inluding the rman scripts). could please somebody give me any hints because i have no more ideas. i tried several rman/backup scripts but none worked for me ....

i will summarize !

thanks,
chris

********************
BACKUP
********************

RMAN>
RMAN> connect target /
2>
3> connect rcvcat rman_p42/rman_p42@CAT
4>
5> run {
6> resync catalog;
7> allocate channel d1 type disk format "/backup/db_%d_%u";
8> backup (database include current controlfile);
9> release channel d1;
10>
11> allocate channel d1 type disk format "/backup/arch_%d_%u_%c";
12> backup (archivelog all delete input);
13> release channel d1;
14>
15> sql "alter system archive log current";
16>
17> allocate channel d1 type disk format "/backup/arch_%d_%u_%c";
18> backup (archivelog all);
19> release channel d1;
20>
21> }
22>
RMAN-06005: connected to target database: P42 (DBID=536507962)

RMAN-06008: connected to recovery catalog database

RMAN-03022: compiling command: resync
RMAN-03023: executing command: resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete

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

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel d1: starting full datafile backupset
RMAN-08502: set_count=6 set_stamp=458921871 creation_time=11-APR-02
RMAN-08010: channel d1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001 name=/global/suncl01_dg/oracle/p42/data/system/system01.dbf
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00002 name=/global/suncl01_dg/oracle/p42/data/rbs/rbs01.dbf
RMAN-08522: input datafile fno=00003 name=/global/suncl01_dg/oracle/p42/data/temp/temp01.dbf
RMAN-08522: input datafile fno=00004 name=/global/suncl01_dg/oracle/p42/data/user/users01.dbf
RMAN-08522: input datafile fno=00005 name=/global/suncl01_dg/oracle/p42/data/index/index01.dbf
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/db_P42_06dll5sf comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:02:47
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

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

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=7 set_stamp=458922047 creation_time=11-APR-02
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=1 recid=9 stamp=458921851
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/arch_P42_07dll61v_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-08071: channel d1: deleting archivelog(s)
RMAN-08514: archivelog filename=/global/suncl01_dg/oracle/p42/data/arch/1_1.dbf recid=9 stamp=458921851
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter system archive log current
RMAN-03023: executing command: sql

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

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08009: channel d1: starting archivelog backupset
RMAN-08502: set_count=8 set_stamp=458922053 creation_time=11-APR-02
RMAN-08014: channel d1: specifying archivelog(s) in backup set
RMAN-08504: input archivelog thread=1 sequence=2 recid=10 stamp=458922052
RMAN-08013: channel d1: piece 1 created
RMAN-08503: piece handle=/backup/arch_P42_08dll625_1 comment=NONE
RMAN-08525: backup set complete, elapsed time: 00:00:02
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

Recovery Manager complete.




****************************************
RESTORE
*****************************************
Recovery Manager: Release 8.1.7.0.0 - Production

RMAN>
RMAN> connect target /
2>
3> connect rcvcat rman_p42/rman_p42@CAT
4>
5> run {
6>
7> allocate channel d1 type disk;
8> restore controlfile;
9> alter database mount;
10> restore database;
11> recover database;
12> alter database open resetlogs;
13> release channel d1;
14>
15> }
16>
RMAN-06006: connected to target database: p42 (not mounted)

RMAN-06008: connected to recovery catalog database

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

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel d1: starting datafile backupset restore
RMAN-08502: set_count=6 set_stamp=458921871 creation_time=11-APR-02
RMAN-08021: channel d1: restoring controlfile
RMAN-08505: output filename=/global/suncl01_dg/oracle/p42/data/controlA/control01.ctl
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/db_P42_06dll5sf tag=null params=NULL
RMAN-08024: channel d1: restore complete
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/global/suncl01_dg/oracle/p42/data/controlA/control01.ctl
RMAN-08505: output filename=/global/suncl01_dg/oracle/p42/data/controlB/control02.ctl

RMAN-03022: compiling command: alter db
RMAN-06199: database mounted

RMAN-03022: compiling command: restore
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel d1: starting datafile backupset restore
RMAN-08502: set_count=6 set_stamp=458921871 creation_time=11-APR-02
RMAN-08089: channel d1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to /global/suncl01_dg/oracle/p42/data/system/system01.dbf
RMAN-08523: restoring datafile 00002 to /global/suncl01_dg/oracle/p42/data/rbs/rbs01.dbf
RMAN-08523: restoring datafile 00003 to /global/suncl01_dg/oracle/p42/data/temp/temp01.dbf
RMAN-08523: restoring datafile 00004 to /global/suncl01_dg/oracle/p42/data/user/users01.dbf
RMAN-08523: restoring datafile 00005 to /global/suncl01_dg/oracle/p42/data/index/index01.dbf
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/db_P42_06dll5sf tag=null params=NULL
RMAN-08024: channel d1: restore complete
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03022: compiling command: recover

RMAN-03022: compiling command: recover(1)
RMAN-03023: executing command: partial resync

RMAN-03022: compiling command: recover(2)

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03023: executing command: recover(4)
RMAN-08017: channel d1: starting archivelog restore to default destination
RMAN-08022: channel d1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=2
RMAN-08023: channel d1: restored backup piece 1
RMAN-08511: piece handle=/backup/arch_P42_08dll625_1 tag=null params=NULL
RMAN-08024: channel d1: restore complete
RMAN-08515: archivelog filename=/global/suncl01_dg/oracle/p42/data/arch/1_2.dbf
thread=1 sequence=2
RMAN-08060: unable to find archivelog
RMAN-08510: archivelog thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03006: non-retryable error occurred during execution of command: recover(4)RMAN-07004: unhandled exception during command execution on channel default
RMAN-20000: abnormal termination of job step
RMAN-06054: media recovery requesting unknown log: thread 1 scn 34300

Recovery Manager complete.