Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: Restore old backup

    Hi,

    How can I restore backup of old incarnation in O9i



    Thanx

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Are you too lazy to check the RMAN Reference manual? :
    Resetting RMAN to a Previous Incarnation: Example
    The following scenario makes an old incarnation of database trgt current again:

    # step 1: obtain the primary key of old incarnation
    LIST INCARNATION OF DATABASE trgt;

    List of Database Incarnations
    DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
    ------- ------- -------- ---------------- --- ---------- ----------
    1 2 TRGT 1334358386 NO 154381 OCT 30 2001 16:02:12
    1 116 TRGT 1334358386 YES 154877 OCT 30 2001 16:37:39

    # step 2: start instance and reset database to incarnation key 2
    STARTUP FORCE NOMOUNT;
    RESET DATABASE TO INCARNATION 2;

    # step 3: restore control file from previous incarnation, then shut down instance
    # and mount control file
    RESTORE CONTROLFILE;
    STARTUP FORCE MOUNT;

    # step 4: restore and recover the database to a point before the RESETLOGS
    RESTORE DATABASE UNTIL SCN 154876;
    RECOVER DATABASE UNTIL SCN 154876;

    # step 5: make this incarnation the current incarnation and then list incarnations:
    ALTER DATABASE OPEN RESETLOGS;


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •