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

小鱼儿 2022-09-25 07:23 3阅读 0赞

操作：在没有创建pfile的情况下，直接执行了以下命令

1 SQL>create pfile from spfile;
    2 SQL>shutdown immediate
    3 SQL>startup
    4 ORA-00205: error in identifying control file, check alert log for more info

查看alter\_TEST.log文件

Tue Jul 03 13:37:49 CST 2012  
Starting ORACLE instance (normal)  
Tue Jul 03 13:37:49 CST 2012  
System parameter db\_block\_buffers enabled without VLM on.  
LICENSE\_MAX\_SESSION = 0  
LICENSE\_SESSIONS\_WARNING = 0  
Picked latch-free SCN scheme 3  
Using LOG\_ARCHIVE\_DEST\_1 parameter default value as /oradb/oracle/102/dbs/arch  
Autotune of undo retention is turned off.   
LICENSE\_MAX\_USERS = 0  
SYS auditing is disabled  
ksdpec: called for event 13740 prior to event group initialization  
Starting up ORACLE RDBMS Version: 10.2.0.5.0.  
System parameters with non-default values:  
  processes                = 50  
  shared\_pool\_size         = 117440512  
  control\_files            = /oradb/oracle/102/dbs/control1, /oradb/oracle/102/dbs/control2  
  db\_block\_buffers         = 1024  
  log\_buffer               = 2032640  
  log\_checkpoint\_interval  = 10000  
  db\_files                 = 80  
  db\_file\_multiblock\_read\_count= 8  
  global\_names             = TRUE  
  parallel\_max\_servers     = 5  
  max\_dump\_file\_size       = 10240  
  db\_name                  = TEST  
PMON started with pid=2, OS id=1406  
PSP0 started with pid=3, OS id=1408  
MMAN started with pid=4, OS id=1410  
DBW0 started with pid=5, OS id=1412  
LGWR started with pid=6, OS id=1414  
CKPT started with pid=7, OS id=1416  
SMON started with pid=8, OS id=1418  
RECO started with pid=9, OS id=1420  
MMON started with pid=10, OS id=1422  
MMNL started with pid=11, OS id=1424  
Tue Jul 03 13:37:52 CST 2012  
ALTER DATABASE   MOUNT  
Tue Jul 03 13:37:52 CST 2012 ORA-00210: cannot open the specified control file  
ORA-00202: control file: '/oradb/oracle/102/dbs/control1'  
ORA-27037: unable to obtain file status  
Solaris-AMD64 Error: 2: No such file or directory  
Additional information: 3  
Tue Jul 03 13:37:55 CST 2012  
ORA-205 signalled during: ALTER DATABASE   MOUNT...

原因是因为启动数据库时未找到spfile则调用了数据库默认的init.ora，但是其默认值与现有数据库信息不匹配导致数据库不能启动。

解决方案：

![复制代码][copycode.gif]

1 bash#vi /oradb/oracle/102/dbs/initTEST.ora
     2 *.audit_file_dest='/oradb/oracle/admin/TEST/adump'
     3 *.background_dump_dest='/oradb/oracle/admin/TEST/bdump'
     4 *.compatible='10.2.0.5.0'
     5 *.control_files='/oradb/oracle/oradata/TEST/control01.ctl','/oradb/oracle/oradata/TEST/control02.ctl','/oradb/oracle/oradata/TEST/control03.ctl'
     6 *.core_dump_dest='/oradb/oracle/admin/TEST/cdump'
     7 *.db_block_buffers=100# SMALL  
     8 *.db_block_size=8192
     9 *.db_file_multiblock_read_count=16
    10 *.db_files=80# SMALL  
    11 *.db_name='TEST'
    12 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
    13 *.global_names=TRUE
    14 *.log_archive_dest_1='location=/oradb/oracle/arch'
    15 *.log_archive_dest_state_2='DEFER'
    16 *.log_buffer=32768# SMALL
    17 *.log_checkpoint_interval=10000
    18 *.max_dump_file_size='10240'# limit trace file size to 5 Meg each
    19 *.open_cursors=300
    20 *.parallel_max_servers=5# SMALL 
    21 *.pga_aggregate_target=81788928
    22 *.processes=150
    23 *.shared_pool_size=113500000# SMALL
    24 
    25 :wq
    26 bash#sqlplus / as sysdba

![复制代码][copycode.gif]

1 SQL> create spfile from pfile;
     2 
     3 File created.
     4 
     5 SQL> startup
     6 ORACLE instance started.
     7 
     8 Total System Global Area  155189248 bytes
     9 Fixed Size                  2094672 bytes
    10 Variable Size             142608816 bytes
    11 Database Buffers            8388608 bytes
    12 Redo Buffers                2097152 bytes
    13 Database mounted.
    14 Database opened.

![复制代码][copycode.gif]

注：再做数据库应用pfile启动数据库时要注意是否已经通过spfile生成pfile。

[copycode.gif]: /images/20220718/c557ba43af3c42b1a88c53f731174834.png