当前日志损坏(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