住,所有业务都暂停,alert日志报错如下:
Mon Jul 13 17:03:28 2015
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_m000_23367.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/TEST/redo01.log‘
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_m000_23367.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/TEST/redo02.log‘
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/test/TEST/trace/TEST_m000_23367.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/oradata/TEST/redo03.log‘
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
暂时关闭监听,防止新业务占满session,此时新连接可以正常连入数据库。
这时候不要停库,因为数据库已经无法正常关闭,一旦数据库down掉,必然会丢失数据。
此时使用sysdba连入数据库,直接clear日志组,数据库即可恢复正常运行。
SYS@TEST>alter database clear unarchived logfile group 1;
Database altered.
SYS@TEST>alter database clear unarchived logfile group 2;
Database altered.
SYS@TEST>alter database clear unarchived logfile group 3;
Database altered.
数据库运行恢复正常。
版权声明:本文为博主原创文章,未经博主允许不得转载。
【Oracle】数据库运行状态下物理删除所有redo日志恢复方法
标签:redo删除
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:http://blog.csdn.net/badly9/article/details/46865065
TAG标签: redo删除