Forum Stats

  • 3,770,020 Users
  • 2,253,049 Discussions
  • 7,875,269 Comments

Discussions

ORA-00205: error in identifying control file

Web
Web Member Posts: 55 Blue Ribbon
edited Jul 25, 2011 4:26PM in General Database Discussions
Hi.
I can't open database
[email protected]:~> 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.

Answers

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    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...
    curious control file name

    specify only valid control file name
  • rajeysh
    rajeysh Member Posts: 2,515
    refer the link:- this may help you
    http://surachartopun.com/2009/11/just-fun-with-rman-recovery.html

    also,
    Thread: Error on Cloning from ASM to ASM: ORA-17503 ksfdopn:2 Failed to open file
    1092447
  • 585179
    585179 Member Posts: 2,248
    edited Jul 25, 2011 4:26PM
    Web wrote:
    Hi.
    I can't open database
    control_files            = "+CLUS/elssb/controlfile/current.259.757429555"
    control_files            = "+FBDATA/elssb/controlfile/current.259.757429557"
    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
    How to solve this problem?

    Thanks in Advance.
    Hi,

    Check if FBDATA/elssb/controlfile/current.259.757429557 does exist, otherwise update the controlfile to just using CLUS/elssb/controlfile/current.259.757429555

    SQL > alter system set control_files='+CLUS/elssb/controlfile/current.259.757429555' scope=spfile;
    SQL > shutdown immediate
    SQL > startup


    Cheers
  • Prathmesh B
    Prathmesh B Member Posts: 515
    +control_files            = "+CLUS/elssb/controlfile/current.259.757429555"+
    +control_files            = "+FBDATA/elssb/controlfile/current.259.757429557"+
    Try below:

    control_files = ("+CLUS/elssb/controlfile/current.259.757429555","+FBDATA/elssb/controlfile/current.259.757429557")
This discussion has been closed.