4 Replies Latest reply: Jun 11, 2014 2:28 AM by ASulthan RSS

    RMAN-06023: no backup or copy of datafile 4 found to restore

    ASulthan

      Hi

       

      When i  restore database  with asm I have face  issues below kindly let me how to resolve this issues

       


      RMAN> show all;

      using target database control file instead of recovery catalog
      RMAN configuration parameters for database with db_unique_name N4PROD are:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'c:\backup\%F';
      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'c:\backup\rman_%U.bck';
      CONFIGURE MAXSETSIZE TO UNLIMITED; # default
      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
      CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFN4
      PROD.ORA'; # default

      RMAN> run
      2> {
      3> restore database;
      4> recover database;
      5> }

      Starting restore at 10-JUN-14
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=22 device type=DISK

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 06/10/2014 17:20:23
      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

      RMAN>