RE: Move Control File in ASM
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-lReceived on Fri May 23 2008 - 15:15:12 CDT