在搭建完从库后，在alert中出现下面的提示
Errors in file /home/oracle/app/diagxxxxrc:
ORA-00313: open failed for members of log group 10 of thread 1
ORA-00312: online log 10 thread 1: ‘xxxstdby02a.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 1: ‘xxxstdby02b.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
提示standby的日志文件丢失
处理：
1停止同步
alter database recover managed standby database cancel;
2
SQL> select group#, dbid, sequence#, archived, status from v$standby_log;
GROUP# DBID SEQUENCE# ARCHIV STATUS
---------- -------------------------------------------------------------------------------- ---------- ------ --------------------
9 UNASSIGNED 0 NO UNASSIGNED
10 2959964006 6323 YES ACTIVE
11 2959964006 6588 YES ACTIVE
12 UNASSIGNED 0 NO UNASSIGNED
13 UNASSIGNED 0 NO UNASSIGNED
14 UNASSIGNED 0 NO UNASSIGNED
15 UNASSIGNED 0 NO UNASSIGNED
16 UNASSIGNED 0 NO UNASSIGNED
17 UNASSIGNED 0 NO UNASSIGNED
查看确定对应的组 select group#,member from v$logfile;
alter database clear logfile group 10;
alter database drop standby logfile group 10;
这个时候在操作系统上又出现了对应的standby log,不知道这个是怎么个情况
重新添加standby log
alter database add standby logfile group 10 ('stadby1.log','standby2.log') size 524288000;
