RE: Strange problem with controlfile
From: CRISLER, JON A <JC1706_at_att.com>
Date: Wed, 28 Dec 2011 18:28:22 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD315ABEB_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
I just wanted to second what Andy says- use RMAN to move / duplicate your control files. I have messed around with this using cp but rman works better overall.
> RMAN-04014: startup failed: ORA-15124: ASM file name
> '+DATA2/FDSTG2/CONTROLFILE/fdstg2_control,
> +DATA1/fdstg2/controlfile/current.260.676234913' contains an invalid alias
> name
>
> We were planning to use restore controlfile to
> '+DATA2/FDSTG2/CONTROLFILE/fdstg2_control' from
> '+ARCH1/fdstg2/controlfile/current.256.676234913'; command to create copy
> of control file to DATA2 disk group. But Instance did not come up. Finally
> we had to start instance using one control file.
>
>
Date: Wed, 28 Dec 2011 18:28:22 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD315ABEB_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
I just wanted to second what Andy says- use RMAN to move / duplicate your control files. I have messed around with this using cp but rman works better overall.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Klock
Sent: Wednesday, December 28, 2011 9:31 AM
To: Sreejith.Sreekantan_at_ibsplc.com
Cc: oracle-l_at_freelists.org
Subject: Re: Strange problem with controlfile
Hi Sreejith,
I have seen this before. It has to do with the way OMF is handled on ASM.
The best way to do this is use RMAN to restore the controlfile to another
location. See this note for details: *How to duplicate a controlfile when
ASM is involved [ID 345180.1]*
I have found ways to get ASM to recognize files with non omf names, but the
above is the cleanest supported way.
Andy
RMAN-00571: ===========================================================> RMAN-03002: failure of startup command at 12/28/2011 12:22:53
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-04014: startup failed: ORA-15124: ASM file name
> '+DATA2/FDSTG2/CONTROLFILE/fdstg2_control,
> +DATA1/fdstg2/controlfile/current.260.676234913' contains an invalid alias
> name
>
> We were planning to use restore controlfile to
> '+DATA2/FDSTG2/CONTROLFILE/fdstg2_control' from
> '+ARCH1/fdstg2/controlfile/current.256.676234913'; command to create copy
> of control file to DATA2 disk group. But Instance did not come up. Finally
> we had to start instance using one control file.
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 28 2011 - 12:28:22 CST