RE: RMAN duplicate using OLD restored backup on same server help?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2011 11:23:27 -0500
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@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Taylor, Chris David
Sent: Thursday, October 20, 2011 10:10 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
