ADG 誤刪除system01.dbf故障處理

一、描述
11.2.0.4單實例主備庫，主庫system01.dbf誤刪除，導致數據庫啟動失敗。

二、現象
SQL> startup
ORACLE instance started.

Total System Global Area 3089920000 bytes
Fixed Size 2257232 bytes
Variable Size 654315184 bytes
Database Buffers 2415919104 bytes
Redo Buffers 17428480 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oradata/devdb/system01.dbf'

三、處理過程

1. 停備庫，傳輸數據文件
   scp system01.dbf 1xx.55.3.xx:/oradata/devdb/
2. 啟動主庫、恢復數據文件
   SQL> startup
   ORACLE instance started.

Total System Global Area 3089920000 bytes
Fixed Size 2257232 bytes
Variable Size 654315184 bytes
Database Buffers 2415919104 bytes
Redo Buffers 17428480 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/devdb/system01.dbf'

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

3.啟動備庫、啟用恢復進程
SQL> startup
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select process,status from v$managed_standby;

PROCESS STATUS

ARCH CLOSING
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG

8 rows selected.