ORA-01113: file 1 needs media recovery ORA-01110: data file 1:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/guangxi/system01.dbf'

把下面两个隐含参数加入到pfile中

*._allow_terminal_recovery_corruption=true
*._allow_resetlogs_corruption= TRUE

重新启动数据库

SQL> startup force pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initguangxi.ora';
ORACLE instance started.

Total System Global Area 1235959808 bytes
Fixed Size		    2252784 bytes
Variable Size		  956301328 bytes
Database Buffers	  268435456 bytes
Redo Buffers		    8970240 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/guangxi/system01.dbf'


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

Database altered.
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页