oracle 控制文件恢复,Oracle控制文件的恢复（一）

1、单个文件丢失

场景模拟：[oracle@oracle dbs]$ rm /disk2/lx02/oradata/control03.ctl

[oracle@oracle dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 1 06:14:54 2011

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

Connected to an idle instance.

06:14:54 SQL> startup

ORACLE instance started.

Total System Global Area  176160768 bytes

Fixed Size                  1218364 bytes

Variable Size              88082628 bytes

Database Buffers           83886080 bytes

Redo Buffers                2973696 bytes

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

通过告警日志获得信息：

ALTER DATABASE   MOUNT

Mon Aug  1 06:14:57 2011

ORA-00202: control file: '/disk2/lx02/oradata/control03.ctl'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

恢复步骤：06:14:57 SQL> shutdown

ORA-01507: database not mounted

ORACLE instance shut down.

06:15:14 SQL> !

[oracle@oracle dbs]$ cp /disk1/lx02/oradata/control02.ctl /disk2/lx02/oradata/control03.ctl

[oracle@oracle dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 1 06:15:36 2011

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

Connected to an idle instance.

06:15:37 SQL> startup

ORACLE instance started.

Total System Global Area  176160768 bytes

Fixed Size                  1218364 bytes

Variable Size              88082628 bytes

Database Buffers           83886080 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

06:15:47 SQL> select name from v$controlfile;

NAME

-----------------------------------------------

/u01/app/oracle/oradata/lx02/control01.ctl

/disk1/lx02/oradata/control02.ctl

/disk2/lx02/oradata/control03.ctl