ORA-01194: file 1 needs more recovery to be consistent
来源:互联网 发布:西北师大知行学院评价 编辑:程序博客网 时间:2024/06/07 04:06
今天在做循序渐进oracle第421页的实验时,按照老盖的步骤居然打不开数据库!于是网上左右百度google,终于使用下面的方法解决!
使用shutdown immediate,等了一会没有结束,于是直接结束了进程,后来又出来一个问题
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: '/u01/app/oracle/oradata/orcl/system01.dbf'
估计应该是日志的问题,又试了下:
SYS@orcl>recover database using backup controlfile until cancel;
ORA-00279: change 747999 generated at 04/09/2014 15:03:10 needed for thread 1
ORA-00289: suggestion : /opt/oracle/archive/arch_1_46_808410282.dbf
ORA-00280: change 747999 for thread 1 is in sequence #46
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/oracle/oradata/orcl/system01.dbf'
ORA-01112: media recovery not started
根据上面提示的内容,注意到 ‘change 747999’ 和 ‘sequence #46’
从网上看到一条语句,可以查出redo logs ,注意要用sys:
SQL> conn sys/oracle as sysdba
Connected.
SYS@orcl>select v1.group#, member, sequence#, first_change#
2 from v$log v1, v$logfile v2
3 where v1.group# = v2.group#;
GROUP# MEMBER SEQUENCE# FIRST_CHANGE#
---------- -------------------------------------------------- ---------- -------------
1 /opt/oracle/oradata/orcl/redo01.log 0 0
3 /opt/oracle/oradata/orcl/redo03.log 0 0
2 /opt/oracle/oradata/orcl/redo02.log 0 0;
从结果里根据 sequence# 和 first_change# 找到了要用到的log file name:
/opt/oracle/oradata/orcl/redo01.log
在 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 下面输入:
ORA-00279: change 747999 generated at 04/09/2014 15:03:10 needed for thread 1
ORA-00289: suggestion : /opt/oracle/archive/arch_1_46_808410282.dbf
ORA-00280: change 747999 for thread 1 is in sequence #46
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/oracle/oradata/orcl/redo01.log
Log applied.
Media recovery complete.
接着:
SYS@orcl>alter database open resetlogs;
Database altered.
使用shutdown immediate,等了一会没有结束,于是直接结束了进程,后来又出来一个问题
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: '/u01/app/oracle/oradata/orcl/system01.dbf'
估计应该是日志的问题,又试了下:
SYS@orcl>recover database using backup controlfile until cancel;
ORA-00279: change 747999 generated at 04/09/2014 15:03:10 needed for thread 1
ORA-00289: suggestion : /opt/oracle/archive/arch_1_46_808410282.dbf
ORA-00280: change 747999 for thread 1 is in sequence #46
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/oracle/oradata/orcl/system01.dbf'
ORA-01112: media recovery not started
根据上面提示的内容,注意到 ‘change 747999’ 和 ‘sequence #46’
从网上看到一条语句,可以查出redo logs ,注意要用sys:
SQL> conn sys/oracle as sysdba
Connected.
SYS@orcl>select v1.group#, member, sequence#, first_change#
2 from v$log v1, v$logfile v2
3 where v1.group# = v2.group#;
GROUP# MEMBER SEQUENCE# FIRST_CHANGE#
---------- -------------------------------------------------- ---------- -------------
1 /opt/oracle/oradata/orcl/redo01.log 0 0
3 /opt/oracle/oradata/orcl/redo03.log 0 0
2 /opt/oracle/oradata/orcl/redo02.log 0 0;
从结果里根据 sequence# 和 first_change# 找到了要用到的log file name:
/opt/oracle/oradata/orcl/redo01.log
在 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} 下面输入:
/u01/app/oracle/oradata/orcl/redo03.log
ORA-00279: change 747999 generated at 04/09/2014 15:03:10 needed for thread 1
ORA-00289: suggestion : /opt/oracle/archive/arch_1_46_808410282.dbf
ORA-00280: change 747999 for thread 1 is in sequence #46
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/oracle/oradata/orcl/redo01.log
Log applied.
Media recovery complete.
接着:
SYS@orcl>alter database open resetlogs;
Database altered.
- ORA-01194: file 1 needs more recovery to be consistent
- ORA-01113: file 1 needs media recovery
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- ORA-01113: file 2 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-16661: the standby database needs to be reinstated
- 【Oracle问题集2】ORA-01113: file 7 needs media recovery
- ORA-01113: file 8 needs media recovery【数据文件的OFFLINE操作造成】
- ORA-01196: file 1 is inconsistent due to a failed media recovery session
- The working copy needs to be upgraded
- Your PC needs to be repaired
- The working copy needs to be upgraded
- 'chromedriver' executable needs to be in PATH.
- ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared l
- ORA-00849: SGA_TARGET 8589934592 cannot be set to more than MEMORY_MAX_TARGET 0.
- hbase 问题之 File system needs to be upgraded. You have version null and I want ver
- Apache实现反向代理负载均衡
- http请求头状态码
- 数据库连接检查以及在c++中捕获mysql报出的错误
- DDL DCL DML
- (一)Hibernate之基础
- ORA-01194: file 1 needs more recovery to be consistent
- Compilers (Dragon Book 2nd) - 8.2
- 用C#实现的条形码和二维码编码解码器
- 什么是数据驱动编程
- InstallShield 制作静默安装包
- 解决建立低版本ios sdk报异常Unsupported compiler 'GCC 4.2'
- Android模拟翻书效果
- OpenCV中关于感兴趣的区域ROI
- Android布局查看工具