ORA-00205: error in identifying control file, check alert log for more info

 

As part of moving the control file from current ASM Diskgroup to new Diskgroup, I did the following;

1. Backup the current controlfile as copy and trace.

2. Backup the current control file

3. Reconfigure the controlfile location using ALTER SYSTEM

4. Restore the controlfile, it will create the controlfiles on the new diskgroup as given in step 3.

SQL> alter database mount; alter database mount *

ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info

SQL> select * from v$controlfile; no rows selected

Cause:

Here, I have mistakenly given +DG_PERF_FLASH02 instead of +DG_PERF_FLASH_02

ALTER SYSTEM SET control_files='+DG_PERF_DATA_01','+DG_PERF_FLASH02' SCOPE=spfile sid='*';

It resulted as the control file restore failure

RMAN> RMAN> shutdown immediate; 2> 3> startup nomount; 4> 5> restore controlfile from '+DG_PERF_DATA_03/testDB/controlfile/current.486.839732817'; 6> 7> exit using target database control file instead of recovery catalog Oracle instance shut down connected to target database (not started) Oracle instance started Total System Global Area    2137886720 bytes Fixed Size                     2184304 bytes Variable Size               1476397968 bytes Database Buffers             654311424 bytes Redo Buffers                   4993024 bytes Starting restore at 20-FEB-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=216 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 02/20/2014 22:48:35 ORA-19504: failed to create file "+DG_PERF_FLASH02" ORA-17502: ksfdcre:4 Failed to create file +DG_PERF_FLASH02 ORA-15001: diskgroup "DG_PERF_FLASH02" does not exist or is not mounted ORA-15001: diskgroup "DG_PERF_FLASH02" does not exist or is not mounted ORA-19600: input file is control file  (+DG_PERF_DATA_01/testDB/controlfile/current.532.840062915) ORA-19601: output file is control file  (+DG_PERF_FLASH02) Recovery Manager complete. SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 20 22:48:35 2014 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ALTER DATABASE MOUNT * ERROR at line 1: ORA-00205: error in identifying control file, check alert log for more info ALTER DATABASE OPEN * ERROR at line 1: ORA-01507: database not mounted SQL>

 

Resolution

Fixed the control_files parameter and restored the controlfile from the old ASM diskgroup.

ALTER SYSTEM SET control_files='+DG_PERF_DATA_01','+DG_PERF_FLASH_02' SCOPE=spfile sid='*';