sysaux表空間檔案損壞的處理(zt)

由於機房突然掉電，發現有一臺開發用資料庫無法正常啟動，看來是檔案損壞了，沒有備份 。

SQL> startup
ORACLE instance started.

Total System Global Area 901775360 bytes
Fixed Size 2024944 bytes
Variable Size 155191824 bytes
Database Buffers 742391808 bytes
Redo Buffers 2166784 bytes
Database mounted.
ORA-01115: IO error reading block from file 3 (block # 28760)
ORA-01110: data file 3: '/u02/oradata/devdb/sysaux01.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4
Additional information: 28758
Additional information: 8192
ORA-01115: IO error reading block from file 3 (block # 28759)
ORA-01110: data file 3: '/u02/oradata/devdb/sysaux01.dbf'
ORA-27072: File I/O error
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4
Additional information: 28758
Additional information: 8192

輔助表空間壞了，看來是硬碟了問題了，文件上說輔助表空間不可用時，oracle的核心功能是可用的，於是將破壞的檔案去掉試試。
SQL> startup mount
ORACLE instance started.

Total System Global Area 901775360 bytes
Fixed Size 2024944 bytes
Variable Size 155191824 bytes
Database Buffers 742391808 bytes
Redo Buffers 2166784 bytes
Database mounted.
SQL> alter database datafile '/u02/oradata/devdb/sysaux01.dbf' offline drop;

Database altered.

SQL> alter database open;

Database altered.

果然可以，試試一般功能是可用的，但全文索引，exp users等是不可用的，還好exp tables是可用的，可以重新裝一臺，將資料導過去。