Home -> Mailing Lists -> Oracle-L -> RE: RMAN duplicate using OLD restored backup on same server help?

RE: RMAN duplicate using OLD restored backup on same server help?

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Thu, 20 Oct 2011 11:23:27 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D6A3304E266_at_SPOBMEXC14.adprod.directory> 





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_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.




-----Original Message-----



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Thursday, October 20, 2011 10:10 AM
To: 'oracle-l_at_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_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.




--



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






--



http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 20 2011 - 11:23:27 CDT












Original text of this message