/home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf'找不到归档日志,你可能移动到别的地方了
解决方案 »
- 想问一句简单的sql(简单是指问题的描述比较简单,回答应该不简单。。)
- 大侠帮帮忙啊。oracle安装问题。
- 迷茫,迷惑,我该如何走下一步?
- 客户端网络连接数据库服务器问题,请教各位大虾.....
- Oracle 爱好者请进!
- 请教ORACLE高手,触发器的问题。
- 如果字段A='D' 那么返回B,如果字段A='C',那么返回E,在SELECT 语句中怎么写,一时忘记了,
- 在oracle中如何将一个表中的数据导入另一个表中??
- O/S-Error: (OS 1450) 滚动条范围不可大于 MAXLONG。是怎么回事?
- Oracle表中如何存储多个checkbox类的数据?
- 急:导入数据时,表间有关联且有数据怎么才能把新表数据导进去!!!!
- 帮忙看一下存储过程
alter database open RESETLOGS
看能不能打开数据库。
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'
重新来一遍:
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 332628 generated at 01/08/2004 16:16:31 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf
ORA-00280: change 332628 for thread 1 is in sequence #25
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}到了这里的时候你输入cancel,回车。
最后是alter database open resetlogs
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 332628 generated at 01/08/2004 16:16:31 needed for thread 1
ORA-00289: suggestion : /home/oracle/app/oracle/product/8.1.7/dbs/arch1_25.dbf
ORA-00280: change 332628 for thread 1 is in sequence #25
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/home/oracle/app/oracle/oradata/ora817/system01.dbf'