Hi All,

I’m having problems with archive logs to restore a level 0 incremental backup using the RMAN without catalog.

I create the backup files using the commands:
rman target /
run {
ALLOCATE CHANNEL C1 TYPE DISK;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP INCREMENTAL LEVEL=0 CUMULATIVE TAG WEEKLY_LEVEL0 format '/backup/level0' DATABASE;
BACKUP ARCHIVELOG ALL format '/backup/archivelogs';
BACKUP CURRENT CONTROLFILE TAG WEEKLY_CTL_PRI format '/backup/control_primary';
BACKUP CURRENT CONTROLFILE FOR STANDBY TAG WEEKLY_CTL_STD format '/backup/control_standby';
BACKUP SPFILE format '/backup/spfile.ora';
}

If I validate the backup using “RESTORE DATABASE VALIDATE;”, RMAN says that the backup is valid, but when I restore a previous backup, I receive an error message about the archive logs:

starting media recovery
archive log thread 1 sequence 3 is already on disk as file /opt/oracle/u06/oradata/1_3.dbf
archive log filename=/opt/oracle/u06/oradata/1_3.dbf thread=1 sequence=3
unable to find archive log
archive log thread=1 sequence=4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/30/2003 17:09:49
RMAN-06054: media recovery requesting unknown log: thread 1 scn 587710
Recovery Manager complete.

The RMAN copy the archive logs files to their location but Oracle cannot find them to recovery…

I recover using these commands:
rman target /
STARTUP FORCE NOMOUNT;
SET DBID 3172882901;
RESTORE CONTROLFILE FROM '/backup/control_primary';
ALTER DATABASE MOUNT;
RESTORE SPFILE TO PFILE '$ORACLE_HOME/dbs/initTEMP.ora';
STARTUP FORCE MOUNT PFILE='$ORACLE_HOME/dbs/initTEMP.ora';
RESTORE TABLESPACE SYSTEM;
RESTORE TABLESPACE UNDOTBS;
RESTORE TABLESPACE USER_DATA;
RESTORE TABLESPACE USER_IDX;
RECOVER DATABASE;
EXIT;

Any Clue?
Thanks and Regards