一、描述 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'
三、处理过程
- 停备库，传输数据文件 scp system01.dbf 1xx.55.3.xx:/oradata/devdb/
- 启动主库、恢复数据文件
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.
