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='*'; |
