Shulou(Shulou.com)06/01 Report--

I. description

11.2.0.4 single instance master / slave database, the master database system01.dbf was deleted incorrectly, resulting in database startup failure.

II. Phenomenon

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'

Third, the processing process

Stop the library, transfer data files

Scp system01.dbf 1xx.55.3.xx:/oradata/devdb/ starts the main library and recovers data files

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. Start the standby library and enable the recovery process

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.