Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

rman restore incremental level 0 backup having ERROR.

User_BAKZAApr 3 2014 — edited Apr 3 2014

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,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details