RMAN duplicate using OLD restored backup on same server help?

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Thu, 20 Oct 2011 10:10:08 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D6A3304E21D_at_SPOBMEXC14.adprod.directory>

  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
  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_at_ingrambarge.com<mailto:chris.taylor_at_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.

Received on Thu Oct 20 2011 - 10:10:08 CDT

Original text of this message