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.