Re: controlfile restore
Date: Tue, 11 Mar 2014 17:32:52 +0000
Message-ID: <CF44C0D7.55400%Mark.Bobak_at_ProQuest.com>
I think you need to set the auto backup format as described here in the documentation: http://docs.oracle.com/cd/E15586_01/backup.1111/e10642/rcmadvre.htm#BRADV89836
"RMAN uses the autobackup format and DBID to determine where to hunt for the control file autobackup. If one is found, RMAN restores the control file to all control file locations listed in the CONTROL_FILES initialization parameter."
-Mark
From: Root <mufc01666_at_gmail.com<mailto:mufc01666_at_gmail.com>> Reply-To: Root <mufc01666_at_gmail.com<mailto:mufc01666_at_gmail.com>> Date: Tuesday, March 11, 2014 at 1:07 PM To: "Ronan.Merrick_at_cso.ie<mailto:Ronan.Merrick_at_cso.ie>" <Ronan.Merrick_at_cso.ie<mailto:Ronan.Merrick_at_cso.ie>> Cc: Oracle L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>, "oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>" <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> Subject: Re: controlfile restore
Thanks for reply Ronan, in this case we don't use catalog. I have different behavior when I run restore from disk and from tape. From disk it is just error database not mounted. From tape nothing I waited for half hour and just kill the RMAN process.
Maybe RMAN just cannot find the file. Or just need few hours to finish it......
run
{
SET DBID=3555660907;
ALLOCATE CHANNEL 't11' type 'sbt_tape' parms="ENV=(TDPO_OPTFILE=/opt/oracle/admin/XYZS1/tsm207/tdpo.opt)";
SET UNTIL TIME "to_date('2014-03-06:17:50:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore controlfile from AUTOBACKUP;
}
Any ideas ?
Tiran
Best Regards
Stay in touch...
On 11 March 2014 17:42, <Ronan.Merrick_at_cso.ie<mailto:Ronan.Merrick_at_cso.ie>> wrote:
Hi Tiran,
You need to be connected to a recovery catalog to run this. Otherwise, how can RMAN know about the available backup since these are stored in controlfile/catalog?
Ronan Merrick
Oracle DBA
Census IT
Ph: (+3531) 8951309<tel:%28%2B3531%29%208951309>
[cid:0__=0FBBF60BDFC80B688f9e8a93df9386909_at_cso.ie][cid:1__=0FBBF60BDFC80B688f9e8a93df9386909_at_cso.ie]
[Inactive hide details for Outsider <mufc01666_at_gmail.com>]Outsider <mufc01666_at_gmail.com<mailto:mufc01666_at_gmail.com>>
Outsider <mufc01666_at_gmail.com<mailto:mufc01666_at_gmail.com>> Sent by: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>
11/03/2014 16:39
Please respond to
mufc01666_at_gmail.com<mailto:mufc01666_at_gmail.com>
To
Oracle L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
cc
Subject
controlfile restore
Hi,
Sorry for simple question but I looking for some way to do restore controlfile with RMAN SET UNTIL TIME. For example you have 100 controlfiles in tape device and don't want to look and find manually the exact one which you need just put RMAN SET UNTIL TIME and restore it.
Why I always get ORA-01507: database not mounted (restore controlfile from AUTOBACKUP;) ? Controlfile must be restored in nomount state.
thanks
Tiran
Best Regards
Stay in touch...
Subject to the disclaimer at http://www.cso.ie/en/emaildisclaimer/
Faoi réir ag an séanadh ag http://www.cso.ie/en/seanadhriomhphoist/
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 11 2014 - 18:32:52 CET
