rman restore incremental level 0 backup having ERROR.

User_BAKZA

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,

ASulthan

Hi

Are you restore Database same Server or Different Server ?

User_BAKZA

Different server....

ASulthan

Hi  Have you look this below doc might be help full

Restore RMAN backup to another server for testing disaster recovery procedures as well as for cloning &amp;laquo; Oracle…

Hemant K Chitale

Did the backup really have only 1 backuppiece ?

How did you restore the controlfile (before the restore database command) ? Which "version" (i.e. a backup made before the database backup or after the database backup) of the controlfile was restored ?

Hemant K Chitale

Renu-Oracle

Hi,

To verify status of backups on new server:

RMAN> crosscheck backup;
RMAN> crosscheck copy;

RMAN>list backup of database;

RMAN>restore database preview;

Common Causes for RMAN-06023 and RMAN-06026 (Doc ID 1366610.1)

Thanks,

Renu