oracle00313 ora27037,ORA-00313: open failed for members

描述:

Oracle 11g 删除备库所有standby redo log ,查看日志报错,处理方法如下。

报错信息如下:

Additional information: 3

Errors in file /fantlam/oracle/app/oracle/diag/rdbms/mmptdg/mmptdg/trace/mmptdg_rfs_4012.trc:

ORA-00313: open failed for members of log group 4 of thread 1

ORA-00312: online log 4 thread 1: '/fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo01.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Errors in file /fantlam/oracle/app/oracle/diag/rdbms/mmptdg/mmptdg/trace/mmptdg_rfs_4012.trc:

ORA-00313: open failed for members of log group 4 of thread 1

ORA-00312: online log 4 thread 1: '/fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo01.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

RFS[2]: Selected log 5 for thread 1 sequence 180 dbid 850194755 branch 974451523

Recovery of Online Redo Log: Thread 1 Group 5 Seq 180 Reading mem 0

Mem# 0: /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo02.log

解决方法:

SQL> select group#,status from v$standby_log;

GROUP# STATUS

---------- ----------

4 ACTIVE

5 ACTIVE

6 UNASSIGNED

7 UNASSIGNED

SQL>

SQL> col member for a60

SQL> select group#,STATUS,MEMBER from v$logfile;

GROUP# STATUS  MEMBER

---------- ------- ------------------------------------------------------------

1         /fantlam/oracle/app/oracle/oradata/mmptdg/redo01.log

2         /fantlam/oracle/app/oracle/oradata/mmptdg/redo02.log

3         /fantlam/oracle/app/oracle/oradata/mmptdg/redo03.log

4         /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo01.log

5         /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo02.log

6         /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo03.log

7         /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo04.log

7 rows selected.

SQL> alter database clear logfile group 4;

alter database clear logfile group 4

*

ERROR at line 1:

ORA-01156: recovery or flashback in progress may need access to files

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database clear logfile group 4;

Database altered.

SQL> alter database clear logfile group 5;

Database altered.

SQL> alter database clear logfile group 6;

Database altered.

SQL> alter database clear logfile group 7;

Database altered.

SQL>

查看告警日志

主库切换日志,备库日志无告警。

Media Recovery Log /archivelog/1_209_974451523.dbf

Media Recovery Waiting for thread 1 sequence 210 (in transit)

Recovery of Online Redo Log: Thread 1 Group 5 Seq 210 Reading mem 0

Mem# 0: /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo02.log

Media Recovery Waiting for thread 1 sequence 211 (in transit)

RFS[9]: Selected log 4 for thread 1 sequence 211 dbid 850194755 branch 974451523

Thu May 10 09:41:37 2018

Archived Log entry 164 added for thread 1 sequence 210 ID 0x32ae65b9 dest 1:

Thu May 10 09:41:37 2018

Archived Log entry 165 added for thread 1 sequence 211 ID 0x32ae65b9 dest 1:

RFS[9]: Selected log 4 for thread 1 sequence 213 dbid 850194755 branch 974451523

Thu May 10 09:41:37 2018

RFS[7]: Selected log 5 for thread 1 sequence 212 dbid 850194755 branch 974451523

RFS[9]: Selected log 6 for thread 1 sequence 214 dbid 850194755 branch 974451523

Archived Log entry 166 added for thread 1 sequence 212 ID 0x32ae65b9 dest 1:

Archived Log entry 167 added for thread 1 sequence 213 ID 0x32ae65b9 dest 1:

Media Recovery Log /archivelog/1_211_974451523.dbf

Media Recovery Log /archivelog/1_212_974451523.dbf

Media Recovery Log /archivelog/1_213_974451523.dbf

Media Recovery Waiting for thread 1 sequence 214 (in transit)

Recovery of Online Redo Log: Thread 1 Group 6 Seq 214 Reading mem 0

Mem# 0: /fantlam/oracle/app/oracle/oradata/mmptdg/stdby_redo03.log

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值