大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
一、描述
11.2.0.4单实例主备库,主库system01.dbf误删除,导致数据库启动失败。
创新互联公司-专业网站定制、快速模板网站建设、高性价比湟源网站开发、企业建站全套包干低至880元,成熟完善的模板库,直接使用。一站式湟源网站制作公司更省心,省钱,快速模板网站建设找我们,业务覆盖湟源地区。费用合理售后完善,10多年实体公司更值得信赖。
二、现象
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'
三、处理过程
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.