Failed to start new restored database with ORA-00205: error in identifying control file (Doc ID 1386481.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2015 ***

Symptoms

In 10.2, when try to shutdown and restart the new restored database with ASM,
failed to start the database.

 


SQL> startup
ORACLE instance started.
------ Feed Back -----------------
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 92277380 bytes
Database Buffers 188743680 bytes
Redo Buffers 2924544 bytes
ORA-00205: error in identifying control file, check alert log for more info





Fri Dec 16 09:18:44 2011
ORA-00202: control file: '+DATA/db01/controlfile/current.261.769959123'
ORA-17503: ksfdopn:2 Failed to open file +DATA/db01/controlfile/current.261.769959123
ORA-15012: ASM file '+DATA/db01/controlfile/current.261.769959123' does not exist
Fri Dec 16 09:18:44 2011
ORA-205 signalled during: ALTER DATABASE MOUNT...




Changes


To restore source database with ASM via RMAN, customer performed:


===== Backup source database with ASM via RMAN ===
===== copy the backups from source database server to target server =====

===== Restore and recovery on target server=====
1. Installed Oracle Database software
The same system environment, and ASM already start
Build directory
$ mkdir $ORACLE_BASE/flash_recovery_area
$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID
$ cd $ORACLE_BASE/admin/$ORACLE_SID
$ mkdir adump bdump cdump udump


2. restore ASM files
$ cp /backup/files/*ASM* $ORACLE_HOME/dbs/

3. Start +ASM instance
$ export ORACLE_SID=+ASM
$ sqlplus / as sysdba
SQL> startup

4. Restore Pfile
$ export ORACLE_SID=db01
$ cp /backup/files/init$ORACLE_SID.ora $ORACLE_HOME/dbs/

5. start target server database to NOMOUNT
$ rman
RMAN> connect target /;
RMAN> startup nomount

6. Restore controlfile to target server
RMAN> restore controlfile from '/backup/rman/controlfile_20111215_20.bps';

7. change to MOUNT
RMAN> alter database mount;

8. restore
RMAN> restore database;

9. recover database
$ export ORACLE_SID=db01
$ sqlplus / as sysdba

SQL> recover database using backup controlfile until cancel;
AUTO

10. change database to OPEN
SQL> alter database open resetlogs;

11. restore other files
$ cp /backup/files/tnsnames.ora $ORACLE_HOME/network/admin/
$ cp /backup/files/listener.ora $ORACLE_HOME/network/admin/
$ cp /backup/files/orapw* $ORACLE_HOME/dbs/
$ metmgr

SQL> shutdown immediate

SQL> startup
Error occurred

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms