oracle dg standbylog丢失案例

在搭建完从库后，在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 logalter database add standby logfile group 10 ('stadby1.log','standby2.log') size 524288000;