Re: Strange problem with controlfile
Date: Thu, 29 Dec 2011 10:21:39 +0530
Message-ID: <OF1CE54028.49E7DAD0-ON65257975.00186745-65257975.001AB38C_at_ibsplc.com>
Hi Andy,
Thanks for the MOS doc.
Sad thing is that, I have followed the exact similar steps mentioned in the part - Duplicating a controlfile into ASM using a specific name. In Step D, start up nomount complains about the 'non existent' control file which as per my understanding should not look for a control file in NOMOUNT STATE http://docs.oracle.com/cd/E11882_01/server.112/e25789/startup.htm#CNCPT1293
Complete Steps I did below.
ibsjpsrv4 oracle [fdstg22]:sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Dec 28 12:14:39 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Production
With the Partitioning, Real Application Clusters, Automatic Storage
Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
control_file_record_keep_time integer 7
control_files string +ARCH1/fdstg2/controlfile/curr
ent.256.676234913,
+DATA1/fdst
g2/controlfile/current.260.676
234913
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> select name from v$controlfile;
NAME
+ARCH1/fdstg2/controlfile/current.256.676234913
+DATA1/fdstg2/controlfile/current.260.676234913
SQL> SQL> SQL> alter system set
control_files='+DATA2/FDSTG2/CONTROLFILE/fdstg2_control,
+DATA1/fdstg2/controlfile/current.260.676234913' scope=spfile sid='*';
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage
Management, OLAP,
Data Mining and Real Application Testing options
ibsjpsrv4 oracle [fdstg22]:rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Wed Dec 28 12:22:34 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
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
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 From: Andy Klock <andy_at_oracledepot.com> To: Sreejith.Sreekantan_at_ibsplc.com Cc: oracle-l_at_freelists.org Date: 12/28/2011 07:59 PM Subject: Re: Strange problem with controlfile Sent by: oracle-l-bounce_at_freelists.org 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-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. > > -- http://www.freelists.org/webpage/oracle-l 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 - 22:51:39 CST