This discussion is archived
5 Replies Latest reply: Feb 29, 2012 9:25 AM by PVOWUSU RSS

rman recovery ERROR

PVOWUSU Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    RMAN forum: {forum:id=74}
  • 3. Re: rman recovery ERROR
    PVOWUSU Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thank you very much for your responses.
    Very much appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points