Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00205: error in identifying control file

WebJul 25 2011 — edited Jul 25 2011
Hi.
I can't open database
oracle@oracle1:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 25 17:54:31 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 5.3982E+10 bytes
Fixed Size    2218032 bytes
Variable Size 3.0333E+10 bytes
Database Buffers 2.3354E+10 bytes
Redo Buffers  292569088 bytes

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>
Here is alert log
Mon Jul 25 17:55:32 2011
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining, Oracle Database Vault and Real Application Testing options.
Using parameter settings in server-side pfile /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initELSSB1.ora
System parameters with non-default values:
  processes                = 1200
  sessions                 = 1856
  spfile                   = "+CLUS/elssb/spfileelssb.ora"
  memory_target            = 51712M
  control_files            = "+CLUS/elssb/controlfile/current.259.757429555"
  control_files            = "+FBDATA/elssb/controlfile/current.259.757429557"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  cluster_database         = TRUE
  db_create_file_dest      = "+CLUS"
  db_recovery_file_dest    = "+FBDATA"
  db_recovery_file_dest_size= 100G
  thread                   = 1
  undo_tablespace          = "UNDOTBS1"
  instance_number          = 1
  recyclebin               = "OFF"
  os_roles                 = FALSE
  remote_login_passwordfile= "EXCLUSIVE"
  audit_sys_operations     = TRUE
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=ELSSBXDB)"
  remote_listener          = "scan2-vip:1521"
  audit_file_dest          = "/oracle/app/oracle/admin/ELSSB/adump"
  audit_trail              = "DB"
  db_name                  = "ELSSB"
  open_cursors             = 300
  sql92_security           = TRUE
  diagnostic_dest          = "/oracle/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
  172.16.0.60
  172.16.1.60
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Mon Jul 25 17:55:33 2011
PMON started with pid=2, OS id=15239 
Mon Jul 25 17:55:33 2011
VKTM started with pid=3, OS id=15241 
VKTM running at (100ms) precision 
Mon Jul 25 17:55:33 2011
GEN0 started with pid=4, OS id=15245 
Mon Jul 25 17:55:33 2011
DIAG started with pid=5, OS id=15247 
Mon Jul 25 17:55:33 2011
DBRM started with pid=6, OS id=15249 
Mon Jul 25 17:55:33 2011
PING started with pid=7, OS id=15251 
Mon Jul 25 17:55:33 2011
PSP0 started with pid=8, OS id=15253 
Mon Jul 25 17:55:33 2011
ACMS started with pid=9, OS id=15255 
Mon Jul 25 17:55:33 2011
DIA0 started with pid=10, OS id=15257 
Mon Jul 25 17:55:33 2011
LMON started with pid=11, OS id=15259 
Mon Jul 25 17:55:36 2011
LMD0 started with pid=12, OS id=15261 
Mon Jul 25 17:55:36 2011
LMS0 started with pid=13, OS id=15263 
Mon Jul 25 17:55:36 2011
LMS1 started with pid=14, OS id=15267 
Mon Jul 25 17:55:36 2011
LMS2 started with pid=15, OS id=15271 
Mon Jul 25 17:55:36 2011
LMS3 started with pid=16, OS id=15275 
Mon Jul 25 17:55:36 2011
RMS0 started with pid=17, OS id=15279 
Mon Jul 25 17:55:36 2011
LMHB started with pid=18, OS id=15281 
Mon Jul 25 17:55:36 2011
MMAN started with pid=19, OS id=15283 
Mon Jul 25 17:55:36 2011
DBW0 started with pid=20, OS id=15285 
Mon Jul 25 17:55:36 2011
DBW1 started with pid=21, OS id=15287 
Mon Jul 25 17:55:36 2011
DBW2 started with pid=22, OS id=15289 
Mon Jul 25 17:55:36 2011
DBW3 started with pid=23, OS id=15291 
Mon Jul 25 17:55:36 2011
DBW4 started with pid=24, OS id=15293 
Mon Jul 25 17:55:36 2011
DBW5 started with pid=25, OS id=15295 
Mon Jul 25 17:55:36 2011
DBW6 started with pid=26, OS id=15297 
Mon Jul 25 17:55:37 2011
DBW7 started with pid=27, OS id=15299 
Mon Jul 25 17:55:37 2011
LGWR started with pid=28, OS id=15301 
Mon Jul 25 17:55:37 2011
CKPT started with pid=29, OS id=15303 
Mon Jul 25 17:55:37 2011
SMON started with pid=30, OS id=15305 
Mon Jul 25 17:55:37 2011
RECO started with pid=31, OS id=15307 
Mon Jul 25 17:55:37 2011
RBAL started with pid=32, OS id=15309 
Mon Jul 25 17:55:37 2011
ASMB started with pid=33, OS id=15311 
NOTE: initiating MARK startup 
Starting background process MARK
Mon Jul 25 17:55:37 2011
MMON started with pid=34, OS id=15313 
Mon Jul 25 17:55:37 2011
MARK started with pid=35, OS id=15317 
NOTE: MARK has subscribed 
Mon Jul 25 17:55:37 2011
MMNL started with pid=36, OS id=15319 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 2)
List of instances:
 1 (myinst: 1) 
 Global Resource Directory frozen
* allocate domain 0, invalid = TRUE 
 Communication channels reestablished
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Post SMON to start 1st pass IR
 Submitted all GCS remote-cache requests
 Post SMON to start 1st pass IR
 Fix write in gcs resources
Reconfiguration complete
Mon Jul 25 17:55:38 2011
LCK0 started with pid=39, OS id=15332 
Starting background process RSMN
Mon Jul 25 17:55:38 2011
RSMN started with pid=40, OS id=15334 
ORACLE_BASE from environment = /oracle/app/oracle
Mon Jul 25 17:55:40 2011
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle1-vip)(PORT=1521))))' SCOPE=MEMORY SID='ELSSB1';
Mon Jul 25 17:55:56 2011
alter database mount
This instance was first to mount
Mon Jul 25 17:55:56 2011
NOTE: Loaded library: System 
Mon Jul 25 17:55:56 2011
SUCCESS: diskgroup CLUS was mounted
SUCCESS: diskgroup FBDATA was mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+FBDATA/elssb/controlfile/current.259.757429557'
ORA-17503: ksfdopn:2 Failed to open file +FBDATA/elssb/controlfile/current.259.757429557
ORA-15012: ASM file '+FBDATA/elssb/controlfile/current.259.757429557' does not exist
ORA-205 signalled during: alter database mount...
Mon Jul 25 17:55:57 2011
NOTE: dependency between database ELSSB and diskgroup resource ora.CLUS.dg is established
How to solve this problem?

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2011
Added on Jul 25 2011
4 comments
1,382 views