Re: controlfile restore
- From: Outsider <mufc01666@xxxxxxxxx>
- To: Ronan.Merrick@xxxxxx
- Date: Tue, 11 Mar 2014 18:07:17 +0100
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 RegardsStay in touch...*
On 11 March 2014 17:42, <Ronan.Merrick@xxxxxx> 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
>
> [image: Inactive hide details for Outsider <mufc01666@xxxxxxxxx>]Outsider
> <mufc01666@xxxxxxxxx>
>
>
>
> *Outsider <mufc01666@xxxxxxxxx <mufc01666@xxxxxxxxx>>*
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>
> 11/03/2014 16:39
> Please respond to
> mufc01666@xxxxxxxxx
>
>
>
> To
>
>
> Oracle L <oracle-l@xxxxxxxxxxxxx>
>
>
> 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/
>
>
Other related posts:
