一個控制檔案損壞

下是在家裡做了一個control file 損壞，併成功還原的試驗。但可能在asm的環境下不所不同，請參考.

請給出意見。

 

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>

 

但asm 下預設的控制檔案只有一個，請注意備份