如题 我在网上找了一些解决方案,我的方式是
先shutdown immediate
然后 startup mount
接着输入 alter system set "_allow_resetlogs_corruption"=true scope=spfile;
接着输入 shutdown immediate
再输入 startup mount
接着 输入recover database until cancel;
这时 选择 cancel
就报错误
SQL> recover database until cancel
ORA-00279: change 19002809 generated at 11/13/2017 15:00:28 needed for thread 1
ORA-00289: suggestion :
/opt/oradata/flash_recovery_area/ICDTEST/archivelog/2017_11_14/o1_mf_1_409_%u_.a
rc
ORA-00280: change 19002809 for thread 1 is in sequence #409
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:
'/opt/oradata/oradata/ICDTEST/datafile/o1_mf_system_d849qjpd_.dbf'
ORA-01112: media recovery not started
接着输入alter database open resetlogs;
这时就变成如截图中这样
先shutdown immediate
然后 startup mount
接着输入 alter system set "_allow_resetlogs_corruption"=true scope=spfile;
接着输入 shutdown immediate
再输入 startup mount
接着 输入recover database until cancel;
这时 选择 cancel
就报错误
SQL> recover database until cancel
ORA-00279: change 19002809 generated at 11/13/2017 15:00:28 needed for thread 1
ORA-00289: suggestion :
/opt/oradata/flash_recovery_area/ICDTEST/archivelog/2017_11_14/o1_mf_1_409_%u_.a
rc
ORA-00280: change 19002809 for thread 1 is in sequence #409
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:
'/opt/oradata/oradata/ICDTEST/datafile/o1_mf_system_d849qjpd_.dbf'
ORA-01112: media recovery not started
接着输入alter database open resetlogs;
这时就变成如截图中这样
解决方案 »
- oracle归档日志
- oracle 9i 上开启审计功能却遭遇 ora-00600 错误
- to_date() 函数的问题,简单!!!!!!!
- 关于DATE和触发器
- 急问!关于三个表关联,但是有一个字段需要做sum。结果不对
- 一个关于select命令的小问题?
- 用oracle写一个财务、进销存的系统应该怎样实现?
- 一个关于oracle中的函数问题
- 求助:一个难搞的需求,内详
- select * from tab;时出现的怪事
- 安装完Oracle developer tools for vs2015后,VS里还是无法连接上Oracle
- sql语句求助,查询每个月有多少笔业务,去除重复的笔数,我只写了一个
http://blog.csdn.net/liaocongyuan1314/article/details/50847529另外,你最后面open的时候少了最后的分号。