伺服器重裝 OS 與 Oracle 後,若保有完整的資料檔、控制檔、重做日誌,可快速恢復資料庫。分兩種情境:
SQL> SHUTDOWN IMMEDIATE
SQL> HOST orapwd file=D:\oracle\database\PWDdemo.ora password=oracle entries=10
SQL> STARTUP NOMOUNT
SQL> ALTER DATABASE MOUNT
SQL> ALTER DATABASE OPEN
需重建控制檔 指向新路徑:
-- 1. 取得舊控制檔結構 (舊庫仍可掛載時)
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
-- 2. 從 trace 檔取得 CREATE CONTROLFILE 腳本,修改檔案路徑
CREATE CONTROLFILE REUSE DATABASE "DEMO" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'D:\NEW_ORADATA\redo01.log' SIZE 50M,
GROUP 2 'D:\NEW_ORADATA\redo02.log' SIZE 50M,
GROUP 3 'D:\NEW_ORADATA\redo03.log' SIZE 50M
DATAFILE
'D:\NEW_ORADATA\system01.dbf',
'D:\NEW_ORADATA\sysaux01.dbf',
...
CHARACTER SET ZHS16GBK;
-- 3. 執行腳本
SQL> STARTUP NOMOUNT
SQL> @create_controlfile.sql
SQL> ALTER DATABASE OPEN RESETLOGS;
| 階段 | 命令 | 讀取檔案 |
|---|---|---|
| NOMOUNT | STARTUP NOMOUNT | 參數檔 (spfile/pfile) |
| MOUNT | ALTER DATABASE MOUNT | 控制檔 (參數檔 control_files 指定) |
| OPEN | ALTER DATABASE OPEN | 資料檔 (控制檔記錄路徑) |
RECOVER DATABASE UNTIL TIME ... 後 OPEN RESETLOGS$ORACLE_HOME/dbs/orapw (Linux) 或 %ORACLE_HOME%\database\PWD.ora (Windows)