Re: Move Control File in ASM
From: jason arneil <jason.arneil_at_gmail.com>
Date: Fri, 23 May 2008 20:34:26 +0100
Message-Id: <1A078002-9D63-4BF3-87B7-D32D138482B3@gmail.com>
Date: Fri, 23 May 2008 20:34:26 +0100
Message-Id: <1A078002-9D63-4BF3-87B7-D32D138482B3@gmail.com>
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.
Cheers,
jason.
-- http://jarneil.wordpress.com On 23 May 2008, at 11:34, Ian Cary wrote:Received on Fri May 23 2008 - 14:34:26 CDT
> 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
-- http://www.freelists.org/webpage/oracle-l