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