Home » RDBMS Server » Server Administration » Add controlfile in ASM encounter error ORA-00214 ? (oracle10gR2 ASM Solaris10 for x86)
Add controlfile in ASM encounter error ORA-00214 ? [message #311114] Thu, 03 April 2008 07:47 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

Oracle10g + ASM

Database has 1 controlfile in ASM and I want to make 2 controlfile in ASM.

I can not use OS command "cp" to copy controlfile in ASM.

So I execute the following command:

RMAN> backup as copy format='+DATA/control02.ctl' current controlfile;

SQL> alter system set control_files='+DATA/control01.ctl','+DATA/control02.ctl' scope=spfile;

SQL> shutdown immediate;

SQL> startup

ORA-00214: control file '+DATA/control01.ctl' version 1391 inconsistent with file '+DATA/control02.ctl' version 1379


what should I do for the second controlfile?

Re: Add controlfile in ASM encounter error ORA-00214 ? [message #311127 is a reply to message #311114] Thu, 03 April 2008 08:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what should I do for the second controlfile?
Replace it with the newer one.
Re: Add controlfile in ASM encounter error ORA-00214 ? [message #311153 is a reply to message #311114] Thu, 03 April 2008 10:26 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member
I have replaced it more times. but always appears same error.
Re: Add controlfile in ASM encounter error ORA-00214 ? [message #313376 is a reply to message #311114] Fri, 11 April 2008 09:54 Go to previous message
divroro12
Messages: 105
Registered: March 2008
Location: Laurel, MD USA
Senior Member
Check Metalink Note:345180.1

divroro12
Previous Topic: not null
Next Topic: Change the character set after database creation
Goto Forum:
  


Current Time: Fri Sep 06 16:57:07 CDT 2024