activate standby database时无法找到standby redo的处理

原创于 2023-04-18 00:52:44 发布 · 621 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

一次在activate standby database方式打开备机时，出现报错无法找到standby redo：ORA-00313: open failed for members of log group 7 of thread 1；

处理方式为clear standby redo方式重新生产（路径要正确。）

步骤如下：

SQL> alter database activate standby database;
alter database activate standby database
*
ERROR at line 1:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/home/zjrac/oradata/stdredo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

====
SQL> alter database clear logfile group 7;
alter database clear logfile group 8;

Database altered.

SQL> 


Database altered.

SQL> SQL> SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@test211 oradata]$ ls
stdredo01.log  stdredo02.log
[oracle@test211 oradata]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 14 14:51:33 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database activate standby database;