資料庫運行中發現回滾段表空間資料檔遺失/損壞,**切勿直接 SHUTDOWN**,開機狀態下修復成功率更高。
ALTER DATABASE DATAFILE 'path/rollback01.dbf' OFFLINE;
ALTER DATABASE RENAME FILE)。SELECT V1.GROUP#, MEMBER, SEQUENCE#, FIRST_CHANGE#
FROM V$LOG V1, V$LOGFILE V2
WHERE V1.GROUP# = V2.GROUP#;
RECOVER DATAFILE 'path/rollback01.dbf';直至顯示
Media recovery complete。ALTER DATABASE DATAFILE 'path/rollback01.dbf' ONLINE;
ALTER ROLLBACK SEGMENT rbs_name OFFLINE;(可能需殺掉使用該段的 Session:
ALTER SYSTEM KILL SESSION 'sid,serial#')。
DROP TABLESPACE rbs_ts INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE rbs_ts DATAFILE 'path/rbs01.dbf' SIZE 500M AUTOEXTEND ON; CREATE PUBLIC ROLLBACK SEGMENT rbs1 TABLESPACE rbs_ts; ALTER ROLLBACK SEGMENT rbs1 ONLINE;
ROLLBACK_SEGMENTS 參數或 UNDO_MANAGEMENT=AUTO 讓實例自動管理。