表空间数据文件故障处理

一、故障现象：
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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20985606/viewspace-1064029/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20985606/viewspace-1064029/