Strange problem with controlfile

From: Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>
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-l
Received on Wed Dec 28 2011 - 07:32:49 CST

Original text of this message