5 Replies Latest reply: Feb 29, 2012 11:25 AM by PVOWUSU RSS

    rman recovery ERROR

    PVOWUSU
      Hi gurus,

      i am performing a recovery in RMAN and encountered the following error:

      starting media recovery

      media recovery failed

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

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

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

      RMAN-03002: failure of recover command at 02/29/2012 13:41:55

      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: '/UBSSYSTEM/ghadb_system_001.dbf'

      The Platform is LINUX RED HAT 5
      DB VERSION IS 10.2.0.04

      Additional Info:

      The backupset is from production db and the recovery is being done on test db ie we took an rman backp from the production db and we want to recover it in the
      test db. both Production and Test have the same SID name ie GHADB.
      Thank you.

      Edited by: PVOWUSU on Feb 29, 2012 8:04 AM
        • 1. Re: rman recovery ERROR
          CKPT
          ORA-19909: datafile 1 belongs to an orphan incarnation
          ORA-01110: data file 1: '/UBSSYSTEM/ghadb_system_001.dbf'
          System tablespace datafile looks contained of old incarnation.

          Post
          SQL> select name,RESETLOGS_CHANGE# from v$datafile_header;

          PVOWUSU      
               Newbie
               
          Handle:      PVOWUSU
          Status Level:      Newbie
          Registered:      Aug 30, 2010
          Total Posts:      68
          Total Questions:      23 (20 unresolved)

          Check your profile stats, Mark all questions as answered if they already suggested. Keep the forum clean.

          Edited by: CKPT on Feb 29, 2012 9:40 PM
          • 2. Re: rman recovery ERROR
            orafad
            RMAN forum: {forum:id=74}
            • 3. Re: rman recovery ERROR
              PVOWUSU
              Thanks very much for your swift response. Will keep the forum clean as you suggested.

              Below is the output from the script

              NAME RESETLOGS_change#
              ---------------------------------------- --------------------
              /UBSSYSTEM/ghadb_system_001.dbf 3753965407
              /UBSUNDO/ghadb_undotbs_001.dbf 3753965407
              /UBSSYSTEM/ghadb_sysaux_001.dbf 3753965407
              /UBSDATA/ghadb_users_001.dbf 3753965407
              /UBSDATA/ghadb_fcclive_001.dbf 3753965407
              /UBSDATA/ghadb_fcclive_002.dbf 3753965407
              /UBSDATA/ghadb_fcclive_003.dbf 3753965407
              /UBSDATA/ghadb_fcclive_004.dbf 3753965407
              /UBSDATA/ghadb_flexml_001.dbf 3753965407
              /UBSDATA/ghadb_accessonline_001.dbf 3753965407
              /UBSDATA/ghadb_businessobjects_001.dbf 3753965407

              NAME RESETLOGS_CHANGE#
              ---------------------------------------- --------------------
              /UBSDATA/ghadb_infopool_001.dbf 3753965407
              /UBSSYSTEM/ghadb_system_002.dbf 3753965407
              /UBSSYSTEM/ghadb_sysaux_002.dbf 3753965407
              /UBSSYSTEM/ghadb_sysaux_003.dbf 3753965407
              /UBSDATA/ghadb_users_002.dbf 3753965407
              /UBSDATA/ghadb_users_003.dbf 3753965407
              /UBSDATA/ghadb_users_004.dbf 3753965407
              /UBSDATA/ghadb_users_005.dbf 3753965407
              /UBSDATA/ghadb_users_006.dbf 3753965407

              20 rows selected.

              Please what should be my next course of action in resolving this issue.

              THANK YOU.
              • 4. Re: rman recovery ERROR
                CKPT
                The backupset is from production db and the recovery is being done on test db ie we took an rman backp from the production db and we want to recover it in the
                test db. both Production and Test have the same SID name ie GHADB.

                So you are using backup of production and performing recovery using archives of test database.

                Even if your database name is change, when your test instance was opened with resetlogs. New incarnation will be generated.

                Now it mismatches with production & test.

                So you can't perform as you are expecting.


                HTH.
                • 5. Re: rman recovery ERROR
                  PVOWUSU
                  Thank you very much for your responses.
                  Very much appreciated.