Re: controlfile restore
Date: Tue, 11 Mar 2014 18:07:17 +0100
Message-ID: <CAO6u0XbA+6UEbJ82qkQn6HU_WQzdyY0L1317aw+EMTW7VX0dZg_at_mail.gmail.com>
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_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
>
> [image: Inactive hide details for Outsider <mufc01666_at_gmail.com>]Outsider
> <mufc01666_at_gmail.com>
>
>
>
> *Outsider <mufc01666_at_gmail.com <mufc01666_at_gmail.com>>*
> Sent by: oracle-l-bounce_at_freelists.org
>
> 11/03/2014 16:39
> Please respond to
> mufc01666_at_gmail.com
>
>
>
> To
>
>
> Oracle L <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:07:17 CET
