RE: RMAN duplicate using OLD restored backup on same server help?
- From: "TJ Kiernan" <tkiernan@xxxxxxxxxxx>
- To: <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2011 10:48:32 -0500
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@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:
