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

简介: 把下面两个隐含参数加入到pfile中
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.


相关文章
|
存储
rman备份失败:ORA-00245: control file backup failed; target is likely on a local file system
rman备份失败:ORA-00245: control file backup failed; target is likely on a local file system
152 0
|
Oracle 关系型数据库 数据库