小弟数据库昨天突然断电,起来的时候就报下面错了,版本是11.2.0.3.0,因为主要是数据仓库,所以没有归档,没有备份
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/ora11/oradata/ora11g/system01.dbf'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
具体的alert.log,基本也就是报ORA-01110,没有提示什么坏块之类的,奇怪的就是ORA-16433,实际上用read only也是打不开数据库的
自己尝试了用改下面参数的方法还是会遇到ORA-16433
alter system set"_allow_error_simulation"=true scope=spfile;
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
alter system set "_allow_terminal_recovery_corruption"=true scope=spfile;