ORA-214 mounting a RAC database

Analyzing and fixing ORA-214 error during startup mount

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '+DATA/grac4/controlfile/current.260.826111693' version 63613 inconsistent with file
'+FRA2/grac4/controlfile/current.321.852654927' version 63564

SQL>   show parameter control

NAME                            TYPE     VALUE
------------------------------------ ----------- ------------------------------
control_files                  string     +DATA/grac4/controlfile/current.260.826111693, 
                                          +FRA2/grac4/controlfile/current.321.8526549

-->  '+DATA/grac4/controlfile/current.260.826111693' version 63613 has a newer version number

Use RMAN to restore that controlfile
RMAN>  restore controlfile to '+FRA2' from '+DATA/grac4/controlfile/current.260.826111693';
Starting restore at 12-JUL-14
using channel ORA_DISK_1
channel ORA_DISK_1: copied control file copy
Finished restore at 12-JUL-14

Remove the old and outdated conrolfile
[grid@grac41 ~]$  asmcmd rm '+FRA2/grac4/controlfile/current.321.852654927'
[grid@grac41 ~]$  asmcmd ls +FRA2/grac4/controlfile/
Backup.257.852572581
current.338.852722827

Finally change the control_files 
SQL> alter system set control_files='+DATA/grac4/controlfile/current.260.826111693',
     '+FRA2/grac4/controlfile/current.338.852722827' scope=spfile sid='*';
System altered.
SQL> startup force mount
SQL> show parameter control_f
NAME                                 TYPE     VALUE
------------------------------------ ----------- ------------------------------
control_files                         string     +DATA/grac4/controlfile/current.260.826111693, 
                                                 +FRA2/grac4/controlfile/current.338.852722827

Reference

Leave a Reply

Your email address will not be published. Required fields are marked *