当前日志损坏(ACTIVE,CURRENT),数据库正常关闭
来源:互联网 发布:无间道刘建明知乎 编辑:程序博客网 时间:2024/05/23 07:23
1.查看日志文件 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ --------- 1 1 100 52428800 512 1 NO CURRENT 3277175 19-FEB-16 2.8147E+14 2 1 98 52428800 512 1 YES INACTIVE 3219784 19-FEB-16 3247884 19-FEB-16 3 1 99 52428800 512 1 YES INACTIVE 3247884 19-FEB-16 3277175 19-FEB-162.正常关闭数据库SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.3.处理redolog[oracle@single2 single2]$ mv redo01.log redo01.log.bak[oracle@single2 single2]$ rm -rf redo01.log4.启动SQL> startupORACLE instance started.Total System Global Area 413372416 bytesFixed Size 2253784 bytesVariable Size 318770216 bytesDatabase Buffers 88080384 bytesRedo Buffers 4268032 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 2560Session ID: 1 Serial number: 5alert日志ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/single2/redo01.log'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 35.恢复SQL> startup mount;ORACLE instance started.Total System Global Area 413372416 bytesFixed Size 2253784 bytesVariable Size 318770216 bytesDatabase Buffers 88080384 bytesRedo Buffers 4268032 bytesDatabase mounted.SQL> recover database until cancel;Media recovery complete.SQL> alter database open resetlogs;Database altered.6.自己生成了redolog文件[oracle@single2 single2]$ ll redo01.log-rw-r----- 1 oracle oinstall 52429312 Mar 5 21:55 redo01.log
0 0
- 当前日志损坏(ACTIVE,CURRENT),数据库正常关闭
- 日志组状态:inactive/active/current
- ACTIVE日志损坏(有归档)
- 模拟当前redo日志损坏
- 当前联机日志损坏恢复
- 当前在线日志损坏,无所有数据文件备份。异常关闭(实验系列)
- 控制文件resetlogs方式创建,有活动在线日志,当前在线日志损坏,并异常关闭(实验系列)
- RevitAPI: 关闭当前文档Close Active Document
- [Oracle] Active或Current联机日志文件丢失如何恢复?
- Oracle日志文件的状态current/active/inactive/unused
- Oracle日志文件的状态current/active/inactive/unused
- 没有备份的current状态的redo日志损坏
- 用友-数据库日志文件损坏
- 当前日志损坏的案例(一)
- 当前日志损坏的案例(二)
- 当前REDO日志损坏的解决
- ora-00600 [2622] 当前日志组损坏
- Oracle 当前日志丢失损坏的恢复
- Python发送邮件小析
- 我理解的 JavaScript 作用域
- 在共享DLL中使用MFC与在静态库中使用MFC的区别
- QML中ROW组件的使用方法及示例
- C-C++字符输出时遇到字符'\n','\0'区别
- 当前日志损坏(ACTIVE,CURRENT),数据库正常关闭
- 内存优化
- Linux系统下的软件安装方式
- Shell基础(五):条件判断与流程控制
- QML中Column的使用及示例
- hdu4121 Xiangqi && uva1589 Xiangqi (模拟)
- 斐波那契数列V(原创题)
- librtmp 时间戳超过 0xffffff时,FMS掉连接
- Android Material Design(4) CoordinatorLayout,AppBarLayout,Toolbar以及TabLayout的使用