FAQ
1. I have an old backup I saved of a test database - TEST3 using an RMAN catalog.

2. The backup information in the CATALOG has now been removed since the backup has been deleted from the primary backup location as part of subsequent backups.


3. I have the original BACKUP SET from the backup I need to restore including the CONTROLFILE.



4. I need to restore this BACKUP SET and backup CONTROLFILE to a *DIFFERENT* database (TEST2) on the *SAME* server


Here's what I have tried:


1. Restore BACKUP SET files to original backup location including the backup controlfile

2. Modify INIT.ORA file for TEST2 database for DB_FILE_NAME_CONVERT

3. CONNECT to RMAN CATALOG, TARGET and AUXILIARY databases

4. I did a CATALOG backup piece for each piece

5. Here's the output from LIST BACKUP http://pastebin.com/0rshnCeT

6. Here's the duplicate RMAN script using SET UNTIL SCN http://pastebin.com/mTVttnxT

7. I receive the following errors: http://pastebin.com/CZDYqjV2

What am I missing? I know it's something obvious.




Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@ingrambarge.com

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

Search Discussions

  • TJ Kiernan at Oct 20, 2011 at 3:49 pm
    You didn't mention it, but did you restore the controlfile to TEST2 from TEST3? Duplicate won't restore the controlfile.

    Did you catalog the backups on both databases? Both TEST3 and TEST2 need to be aware that the backups are there.

    Duplicating from an older backup has been a pain for me. What I would do here is a plain ol' restore/recover.

    I haven't been able to make DB_FILE_NAME_CONVERT work in this situation, but a simple sql script will give you the results to copy/paste from:

    select 'set newname for datafile '''||name||''' to '''||replace(name, '<old path>', '<new path')||''';'
    from v$datafile;

    Then in RMAN, connected to TEST2 as your target, run

    run {
    ***Paste your SET NEWNQME results here***
    switch datafile all;
    restore database;
    recover database until SCN ***your SCN***;
    ***Log file statements here***
    alter database open resetlogs;
    }



    Thanks,
    T. J.

    The information contained in this message is privileged and confidential information intended only for the use of the individual or entity identified above. If the receiver of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by replying to his/her e-mail address noted above and delete the original message, including any attachments. Thank you.

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Taylor, Chris David
    Sent: Thursday, October 20, 2011 10:10 AM
    To: 'oracle-l@freelists.org'
    Subject: RMAN duplicate using OLD restored backup on same server help?

    1. I have an old backup I saved of a test database - TEST3 using an RMAN catalog.

    2. The backup information in the CATALOG has now been removed since the backup has been deleted from the primary backup location as part of subsequent backups.


    3. I have the original BACKUP SET from the backup I need to restore including the CONTROLFILE.



    4. I need to restore this BACKUP SET and backup CONTROLFILE to a *DIFFERENT* database (TEST2) on the *SAME* server


    Here's what I have tried:


    1. Restore BACKUP SET files to original backup location including the backup controlfile

    2. Modify INIT.ORA file for TEST2 database for DB_FILE_NAME_CONVERT

    3. CONNECT to RMAN CATALOG, TARGET and AUXILIARY databases

    4. I did a CATALOG backup piece for each piece

    5. Here's the output from LIST BACKUP http://pastebin.com/0rshnCeT

    6. Here's the duplicate RMAN script using SET UNTIL SCN http://pastebin.com/mTVttnxT

    7. I receive the following errors: http://pastebin.com/CZDYqjV2

    What am I missing? I know it's something obvious.




    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-663-1673
    Email: chris.taylor@ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.


    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Taylor, Chris David at Oct 20, 2011 at 4:24 pm
    I think I finally figured it out....

    I had to use *this* SCN:

    From List Backup command
    ---- >>>> Control File Included: Ckp SCN: 14169962068 Ckp time: 13-OCT-11

    Apparently I don't understand the SCNs nor the Seq #s listed in the "List Backup" command because when I tried to use one of those SCNs below, *OR* the log sequence numbers, RMAN would complain of "no backup of the datafile found to restore"....

    What a nightmare.

    List of Archived Logs in backup set 9217047
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 101 14157277044 12-OCT-11 14157280857 12-OCT-11
    1 102 14157280857 12-OCT-11 14157286292 12-OCT-11
    1 103 14157286292 12-OCT-11 14157292373 12-OCT-11
    1 104 14157292373 12-OCT-11 14157298477 12-OCT-11
    1 105 14157298477 12-OCT-11 14157302940 12-OCT-11
    1 106 14157302940 12-OCT-11 14157307745 12-OCT-11
    1 107 14157307745 12-OCT-11 14169918183 12-OCT-11
    1 108 14169918183 12-OCT-11 14169922156 12-OCT-11
    1 109 14169922156 12-OCT-11 14169924664 12-OCT-11
    1 110 14169924664 12-OCT-11 14169929554 12-OCT-11
    1 111 14169929554 12-OCT-11 14169933863 12-OCT-11
    1 112 14169933863 12-OCT-11 14169934037 12-OCT-11
    1 113 14169934037 12-OCT-11 14169938293 12-OCT-11
    1 114 14169938293 12-OCT-11 14169942105 12-OCT-11
    1 115 14169942105 12-OCT-11 14169946799 12-OCT-11
    1 116 14169946799 12-OCT-11 14169951949 12-OCT-11
    1 117 14169951949 12-OCT-11 14169954350 12-OCT-11
    1 118 14169954350 12-OCT-11 14169955929 12-OCT-11
    1 119 14169955929 12-OCT-11 14169959172 12-OCT-11
    1 120 14169959172 12-OCT-11 14169962038 13-OCT-11

    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-663-1673
    Email: chris.taylor@ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Taylor, Chris David
    Sent: Thursday, October 20, 2011 10:10 AM
    To: 'oracle-l@freelists.org'
    Subject: RMAN duplicate using OLD restored backup on same server help?

    1. I have an old backup I saved of a test database - TEST3 using an RMAN catalog.

    2. The backup information in the CATALOG has now been removed since the backup has been deleted from the primary backup location as part of subsequent backups.


    3. I have the original BACKUP SET from the backup I need to restore including the CONTROLFILE.



    4. I need to restore this BACKUP SET and backup CONTROLFILE to a *DIFFERENT* database (TEST2) on the *SAME* server


    Here's what I have tried:


    1. Restore BACKUP SET files to original backup location including the backup controlfile

    2. Modify INIT.ORA file for TEST2 database for DB_FILE_NAME_CONVERT

    3. CONNECT to RMAN CATALOG, TARGET and AUXILIARY databases

    4. I did a CATALOG backup piece for each piece

    5. Here's the output from LIST BACKUP http://pastebin.com/0rshnCeT

    6. Here's the duplicate RMAN script using SET UNTIL SCN http://pastebin.com/mTVttnxT

    7. I receive the following errors: http://pastebin.com/CZDYqjV2

    What am I missing? I know it's something obvious.




    Chris Taylor
    Sr. Oracle DBA
    Ingram Barge Company
    Nashville, TN 37205
    Office: 615-517-3355
    Cell: 615-663-1673
    Email: chris.taylor@ingrambarge.com

    CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.


    --
    http://www.freelists.org/webpage/oracle-l




    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 20, '11 at 3:11p
activeOct 20, '11 at 4:24p
posts3
users2
websiteoracle.com

2 users in discussion

Taylor, Chris David: 2 posts TJ Kiernan: 1 post

People

Translate

site design / logo © 2022 Grokbase