表空間資料檔案故障處理

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