Re: controlfile restore
From: <Ronan.Merrick_at_cso.ie>
Date: Tue, 11 Mar 2014 16:42:33 +0000
Message-ID: <OF47C35CE4.C83802FE-ON80257C98.005B8DF8-80257C98.005BC9A9_at_cso.ie>
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...
Date: Tue, 11 Mar 2014 16:42:33 +0000
Message-ID: <OF47C35CE4.C83802FE-ON80257C98.005B8DF8-80257C98.005BC9A9_at_cso.ie>
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
Outsider <mufc01666_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org 11/03/2014 16:39
|
|
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 - 17:42:33 CET
