HI,
I take the backup using following rman incremental level 0 backup and backup was successfully done, but when we restore it following error received.
Backup:
========================================================================================
#!/bin/bash
OF=sales-$(date +%Y%m%d)
export ORACLE_HOME=/d01/oracle/app/product/10.2.0/dbhome_1
export ORACLE_SID=sales
export PATH=$PATH:$ORACLE_HOME/bin
rman target=/ log=/home/oracle/rmanlogs/RMAN-$OF.log <<EOF
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RUN
{allocate channel ch1 type disk;
backup as compressed backupset
format '/backup/$OF-df%p-%s.bk'
INCREMENTAL LEVEL 0 DATABASE include current controlfile ;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT' ;
}
EOF
exit
========================================================================================
ERROR:
========================================================================================
RMAN> catalog backuppiece '/d01/sales-20140403-df1-3125.bk';
Starting implicit crosscheck backup at 03-APR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=318 devtype=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 03-APR-14
Starting implicit crosscheck copy at 03-APR-14
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 03-APR-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_87_9bjs3khd_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_84_9bjs0pp8_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_83_9bjs078q_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_82_9bjrzm0y_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_85_9bjs1l8g_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_86_9bjs2p9f_.arc
File Name: /d01/oracle/app/product/10.2.0/dbhome_1/flash_recovery_area/SALES/archivelog/2013_12_11/o1_mf_1_81_9bjrym4b_.arc
cataloged backuppiece
backup piece handle=/d01/sales-20140403-df1-3125.bk recid=3112 stamp=843929241
RMAN>
RMAN> restore database;
Starting restore at 03-APR-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2014 16:47:47
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
========================================================================================
please advise..
Regards,