5 Replies Latest reply on Feb 11, 2016 7:37 AM by Beauty_and_dBest

    Recover database

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      11gR2

      OL6.5

       

       

      We have a test instance of which I want to refresh its data from latest data of PROD instance. because the functional & users want to simulate-test latest issues.

      The test instance is also named PROD so It will be easily from me to restore the latest backup from PROD to it.

       

      Now I am restoring the backup but I got error:

       

      RMAN> restore controlfile from '/home/FRA/PROD/backupset/2016_02_11/o1_mf_ncnnf_TAG20160211T012128_ccpwdsc2.bkp';

       

      Starting restore at 11-FEB-16

      using channel ORA_DISK_1

       

      channel ORA_DISK_1: restoring control file

      channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

      output file name=/home/oraprod/PROD/data/cntrl01.dbf

      output file name=/home/oraprod/PROD/data/cntrl02.dbf

      output file name=/home/oraprod/PROD/data/cntrl03.dbf

      Finished restore at 11-FEB-16

       

      RMAN> alter database mount;

       

      database mounted

      released channel: ORA_DISK_1

       

      RMAN> recover database;

       

      Starting recover at 11-FEB-16

      Starting implicit crosscheck backup at 11-FEB-16

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=239 device type=DISK

      Crosschecked 4 objects

      Finished implicit crosscheck backup at 11-FEB-16

       

      Starting implicit crosscheck copy at 11-FEB-16

      using channel ORA_DISK_1

      Finished implicit crosscheck copy at 11-FEB-16

       

      searching for all files in the recovery area

      cataloging files...

      cataloging done

       

      List of Cataloged Files

      =======================

      File Name: /home/FRA/PROD/backupset/2016_02_11/o1_mf_ncnnf_TAG20160211T012128_ccpwdsc2_.bkp

       

      using channel ORA_DISK_1

       

      starting media recovery

      media recovery failed

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 02/11/2016 12:53:45

      ORA-00283: recovery session canceled due to errors

      RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed

      start until cancel using backup controlfile

      ORA-00283: recovery session canceled due to errors

      ORA-19909: datafile 1 belongs to an orphan incarnation

      ORA-01110: data file 1: '/home/oraprod/PROD/data/system01.dbf'

       

      RMAN>



      Please help....