RE: RMAN recovery question
Date: Tue, 5 Jun 2012 10:36:05 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B286A748_at_SPOBMEXC14.adprod.directory>
Unless I'm mistaken (and entirely possible) you should do:
RMAN> restore controlfile from 'full_path/snapshot_controlfile_name' to 'path';
Examples:
RMAN> restore controlfile from '/u01/app/oracle/backup/enter_file_name_here' to '/tmp/control01.ctl';
HOWEVER, I would probably recommend doing a RMAN duplicate. Which version of the DB are you using?
Basic instructions for 10.2.x:
1.) copy backups from primary to your new server in the same disk location as your primary 2.) copy archivelogs from primary to your new server in the same disk location as your primary 3.) then in RMAN connect to target (production db) and to auxiliary db (your new copy) 4.) set your until time 5.) "duplicate target database to your_new_db_name"
I typed that in a hurry so hopefully you get the gist.
Chris Taylor
"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)
Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ramadoss, Karthik
Sent: Tuesday, June 05, 2012 9:40 AM
To: 'oracle-l_at_freelists.org'
Subject: RMAN recovery question
I have a full RMAN backup of a database. I am trying to do a point in time recovery to another server from the backup (and then change db name/db id with nid). However, the controlfile autobackup was deleted. I do have the snapshot controlfile from the time the backup was taken.
How do I proceed?
Thanks in advance,
Karthik
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 05 2012 - 10:36:05 CDT