RE: Move Control File in ASM

> Hi Ian,
> Take a look at Metalink Note:345180.1. The subject of this note is "How to duplicate a controlfile when ASM is involved". >It basically states you have the database at the mount state and run the rman restore command. 
>

Typo! That should be nomount state.

>
> Cheers,
>
>jason.
>
>--
>http://jarneil.wordpress.com
>

On 23 May 2008, at 11:34, Ian Cary wrote:


Jason,
Just to point out that the OP asked how to move the controlfile and made no mention of an rman backup. If you try the command you sent without one you 
just get the following error.
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== 
RMAN-03002: failure of restore command at 05/23/2008 11:12:34
ORA-19607: +DATA/itest_control02.ctl is an active control file
Actually giving this a bit more thought I think your command will fail even 
with a backup in place and should read

RMAN>restore controlfile to '<NEW LOCATION>' from '<BACKUP LOCATION>'


Regards,

Ian

Other related posts: