Strange problem with controlfile
Date: Wed, 28 Dec 2011 19:02:49 +0530
Message-ID: <OF5F03E11C.82CC2E3A-ON65257974.0049AA6A-65257974.004A6A22_at_ibsplc.com>
Hi Friends,
Oracle 11.2.0.2 2 node RAC on Solaris 10 RAC with one instance kept down.
So, I am working on Instance 2 and trying to relocate one of the multiplexed control file in ARCH1 disk group to DATA2 disk group. We wanted to remove the ARCH1 disk group storage from this ASM. The steps are as follows
1.Change control_files parameter
alter system set control_files='+DATA2/FDSTG2/CONTROLFILE/fdstg2_control,
+DATA1/fdstg2/controlfile/current.260.676234913' scope=spfile sid='*';
2.shutdown the database
3.startup nomount
Here I got this error
RMAN> startup nomount
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03002: failure of startup command at 12/28/2011 12:22:53 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.
I used asmcmd cp command to copy the file cp
+ARCH1/fdstg2/controlfile/current.256.676234913
+DATA2/FDSTG2/CONTROLFILE/fdstg2_control that was successfull, still same
error came.
Before this, I used asmcmd cp command to create the same file, which I had removed using 'rm' command before starting the whole activity.
My questions is
Why was the control file checked when I gave startup NOMOUNT ?
With Regards,
Sreejith
-- Sreejith S Nair Associate Systems Architect | AOS DBA Team IBS Software Services Private Ltd. 2nd Floor, IBS Campus, Technopark Campus, Trivandrum - 695 581, Kerala, India ((Direct) +91 471 661 4707 ) +91 808 648 5523 *sreejith.sreekantan_at_ibsplc.com 8 www.ibsplc.com DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect." -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 28 2011 - 07:32:49 CST