一、故障现象：
1.$sudo rm -rf REG01 --表空间数据文件不正确，在OS下rm；


2.11:56:16 SYS@PROD>startup
ORACLE instance started.


Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             104859024 bytes
Database Buffers          205520896 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: '/u01/app/oracle/oradata/PROD/disk1/REG01'
数据库不能正常启动！


二、故障解决：
12:05:09 SYS@PROD>startup mount;
ORACLE instance started.


Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             104859024 bytes
Database Buffers          205520896 bytes
Redo Buffers                2973696 bytes
Database mounted.
12:05:23 SYS@PROD>alter database datafile'/u01/app/oracle/oradata/PROD/disk1/REG01' offline drop


12:06:52 SYS@PROD>startup force;
ORACLE instance started.


Total System Global Area  314572800 bytes
Fixed Size                  1219184 bytes
Variable Size             104859024 bytes
Database Buffers          205520896 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.


故障解决！！！

Johnson
13-12-23