SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: 'D:\ORACLE\ORADATA\SCHOOL\SCHOOL.ORA'查询了一下datafile11的状态是Recover,我尝试了recover操作:
SQL> recover datafile 11
ORA-00279: change 205613 generated at 08/18/2005 09:47:55 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00001.001
ORA-00280: change 205613 for thread 1 is in sequence #1Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'D:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00001.001'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。恢复不了了,因为我之前误把归档日志ARC00001.001给删掉了,抓狂~~!
现在数据库无法启动了,不知道现在要如何把datafile 11的状态改为online,启动数据库,请高手帮帮忙!
这些归档日志可以不要了,只要能让数据库正常启动起来,非常感谢!!
alter database open
*
ERROR at line 1:
ORA-01113: file 11 needs media recovery
ORA-01110: data file 11: 'D:\ORACLE\ORADATA\SCHOOL\SCHOOL.ORA'查询了一下datafile11的状态是Recover,我尝试了recover操作:
SQL> recover datafile 11
ORA-00279: change 205613 generated at 08/18/2005 09:47:55 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00001.001
ORA-00280: change 205613 for thread 1 is in sequence #1Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log 'D:\ORACLE\ORA92\DATABASE\ARCHIVE\ARC00001.001'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。恢复不了了,因为我之前误把归档日志ARC00001.001给删掉了,抓狂~~!
现在数据库无法启动了,不知道现在要如何把datafile 11的状态改为online,启动数据库,请高手帮帮忙!
这些归档日志可以不要了,只要能让数据库正常启动起来,非常感谢!!
你试着指定current redo logfile 看看行不行,
不行的话
alter database datafile 'D:\ORACLE\ORADATA\SCHOOL\SCHOOL.ORA' offline;
alter database open;
2.如果想把数据库启动起来.可以把11号文件暂时丢弃.用sysdba权限执行:
alter database datafile 11 offline drop;
alter database open;
mount 状态下 offline 相应表空间,然后 open 试一下