1 Reply Latest reply on Jul 17, 2017 6:54 AM by Beauty_and_dBest

    RMAN Recovery

    Beauty_and_dBest

      Hi ALL,

       

      11gR1

       

      I am recovering database from archivelogs, but I got this error

       

      Using RMAN:

       

      [oracle@mol ~]$ rman target /

       

      Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jul 16 23:27:13 2017

      Copyright (c) 1982, 2007, Oracle.  All rights reserved.

      connected to target database: PROD (DBID=310110964, not open)

       

      RMAN> recover database

      2> ;

       

      Starting recover at 16-JUL-17

      using target database control file instead of recovery catalog

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=2984 device type=DISK

       

      starting media recovery

      media recovery failed

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

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

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

      RMAN-03002: failure of recover command at 07/16/2017 23:31:49

      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: '/u01/oracle/PROD/db/apps_st/data/system01.dbf'

       

      RMAN>

       

       

      Using SYSDBA

      sqlplus / as sysdba

       

      SQL> recover database 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: '/u01/oracle/PROD/db/apps_st/data/system01.dbf'

       

       

      Please help...

       

       

      Kind regards,

      jc