一个control file 损坏
login as: oracle
Using keyboard-interactive authentication.
Password:
Last login: Thu Aug 16 09:05:22 2012 from 10.16.11.123
oracle@linux-156y:~> export ORACLE_SID=mos5200
oracle@linux-156y:~> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Aug 16 09:11:50 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameters control;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /opt/oracle/oradata/mos5200/co
ntrol01.ctl, /opt/oracle/orada
ta/mos5200/control02.ctl, /opt
/oracle/oradata/mos5200/contro
l03.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> host
oracle@linux-156y:~> cd /opt/oracle/oradata/mos5200/
oracle@linux-156y:/opt/oracle/oradata/mos5200> ls
control01.ctl control03.ctlbak redo03.log temp01.dbf
control02.ctl redo01.log sysaux01.dbf undotbs01.dbf
control03.ctl redo02.log system01.dbf users01.dbf
oracle@linux-156y:/opt/oracle/oradata/mos5200> mv control03.ctl control03.ctlbak
oracle@linux-156y:/opt/oracle/oradata/mos5200> exit
exit
SQL> shutdown immediate;
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/opt/oracle/oradata/mos5200/control03.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size 2143864 bytes
Variable Size 318769544 bytes
Database Buffers 872415232 bytes
Redo Buffers 9228288 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> host
oracle@linux-156y:~> cd /opt/oracle/oradata/mos5200/
oracle@linux-156y:/opt/oracle/oradata/mos5200> ls
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
control02.ctl redo02.log system01.dbf users01.dbf
control03.ctlbak redo03.log temp01.dbf
oracle@linux-156y:/opt/oracle/oradata/mos5200> cp control01.ctl control03.ctl
oracle@linux-156y:/opt/oracle/oradata/mos5200> exit
exit
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size 2143864 bytes
Variable Size 318769544 bytes
Database Buffers 872415232 bytes
Redo Buffers 9228288 bytes
Database mounted.
Database opened.
SQL> select count(*) from dba_objects;
COUNT(*)
----------
68294
SQL>