RMAN duplicate using OLD restored backup on same server help?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2011 10:10:08 -0500
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
Other related posts:
