RE: Move Control File in ASM
- From: jason arneil <jason.arneil@xxxxxxxxx>
- To: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- Date: Fri, 23 May 2008 21:15:12 +0100
> 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:
