这个参数只是在当前日志损坏时才加的. 你直接 alter database recover automatic datafile 1;再open
按照你说的将那个参数去了.然后执行alter database recover automatic datafile 1.提示如下: ORA-00283: recover session canceled due to errors; ORA-01610: recover using the BACKUP CONTROLFILE option must be done; 还是不行呀...
有备份控制文件吗?有 在mount下执行该语句: recover database using backup controlfile; alter database open resetlogs;
忘了说了,如果你是正式库,最好先shutdown做个备份.
ORA-00279: change 104773881 generated at 02/24/2006 13:33:06 needed for thread 1 ORA-00289: suggestion : /oracle/product/9.2.0.4/dbs/arch1_2.dbf ORA-00280: change 104773881 for thread 1 is in sequence #2 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 选什么呢?
auto,当系统找不到时指定redolog就可以了.
ORA-00308: cannot open archived log '/oracle/product/9.2.0.4/dbs/arch1_2.dbf' 这是选择AUTO后的结果.接着该怎么弄呀?不好意思,我是一点都不会 ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-00308: cannot open archived log '/oracle/product/9.2.0.4/dbs/arch1_2.dbf' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
找不到归档日志,那就recover database using backup controlfile; 在选的时候指定当前的日志来恢复
用alter database open noresetlogs;
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
你直接
alter database recover automatic datafile 1;再open
ORA-00283: recover session canceled due to errors;
ORA-01610: recover using the BACKUP CONTROLFILE option must be done;
还是不行呀...
在mount下执行该语句:
recover database using backup controlfile;
alter database open resetlogs;
1
ORA-00289: suggestion : /oracle/product/9.2.0.4/dbs/arch1_2.dbf
ORA-00280: change 104773881 for thread 1 is in sequence #2
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
选什么呢?
这是选择AUTO后的结果.接着该怎么弄呀?不好意思,我是一点都不会
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log '/oracle/product/9.2.0.4/dbs/arch1_2.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
在选的时候指定当前的日志来恢复