RE: Move Control File in ASM

From: jason arneil <jason.arneil_at_gmail.com>
Date: Fri, 23 May 2008 21:15:12 +0100
Message-Id: <A18F5D1E-60F0-412F-8829-74C9BCB2CA3C@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.
 >

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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 23 2008 - 15:15:12 CDT

Original text of this message