查看日志信息：
SQL> select * from v$Log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------ ------------ ------------ 1 1 69 52428800 512 2 YES CURRENT 2450934 03-MAR-17 2.8147E+14 2 1 0 52428800 512 2 YES UNUSED 2440706 03-MAR-17 2450934 03-MAR-17 3 2 0 52428800 512 2 YES UNUSED 2440817 03-MAR-17 2450939 03-MAR-17 4 2 36 52428800 512 2 YES CURRENT 2450939 03-MAR-17 2.8147E+14 SQL> col member for a70 SQL> select group#, type, member from v$logfile; GROUP# TYPE MEMBER ---------- ------- ---------------------------------------------------------------------- 2 ONLINE +DATA/jyzhaodg/onlinelog/group_2.298.937648563 2 ONLINE +FRA/jyzhaodg/onlinelog/group_2.278.937648565 1 ONLINE +DATA/jyzhaodg/onlinelog/group_1.297.937648559 1 ONLINE +FRA/jyzhaodg/onlinelog/group_1.279.937648561 3 ONLINE +DATA/jyzhaodg/onlinelog/group_3.299.937648567 3 ONLINE +FRA/jyzhaodg/onlinelog/group_3.389.937648569 4 ONLINE +DATA/jyzhaodg/onlinelog/group_4.300.937648573 4 ONLINE +FRA/jyzhaodg/onlinelog/group_4.390.937648573 8 rows selected.根据检查结果，合理为数据库添加standby logfile：
alter database add standby logfile thread 1 group 11 ('+DATA','+FRA') size 52428800; alter database add standby logfile thread 1 group 12 ('+DATA','+FRA') size 52428800; alter database add standby logfile thread 1 group 13 ('+DATA','+FRA') size 52428800; alter database add standby logfile thread 2 group 21 ('+DATA','+FRA') size 52428800; alter database add standby logfile thread 2 group 22 ('+DATA','+FRA') size 52428800; alter database add standby logfile thread 2 group 23 ('+DATA','+FRA') size 52428800;添加完再次查看：
SQL> select group#, type, member from v$logfile; GROUP# TYPE MEMBER ---------- ------- ---------------------------------------------------------------------- 2 ONLINE +DATA/jyzhaodg/onlinelog/group_2.298.937648563 2 ONLINE +FRA/jyzhaodg/onlinelog/group_2.278.937648565 1 ONLINE +DATA/jyzhaodg/onlinelog/group_1.297.937648559 1 ONLINE +FRA/jyzhaodg/onlinelog/group_1.279.937648561 3 ONLINE +DATA/jyzhaodg/onlinelog/group_3.299.937648567 3 ONLINE +FRA/jyzhaodg/onlinelog/group_3.389.937648569 4 ONLINE +DATA/jyzhaodg/onlinelog/group_4.300.937648573 4 ONLINE +FRA/jyzhaodg/onlinelog/group_4.390.937648573 11 STANDBY +DATA/jyzhaodg/onlinelog/group_11.301.937648773 11 STANDBY +FRA/jyzhaodg/onlinelog/group_11.391.937648775 12 STANDBY +DATA/jyzhaodg/onlinelog/group_12.302.937648777 GROUP# TYPE MEMBER ---------- ------- ---------------------------------------------------------------------- 12 STANDBY +FRA/jyzhaodg/onlinelog/group_12.392.937648779 13 STANDBY +DATA/jyzhaodg/onlinelog/group_13.303.937648779 13 STANDBY +FRA/jyzhaodg/onlinelog/group_13.393.937648781 21 STANDBY +DATA/jyzhaodg/onlinelog/group_21.304.937648783 21 STANDBY +FRA/jyzhaodg/onlinelog/group_21.394.937648783 22 STANDBY +DATA/jyzhaodg/onlinelog/group_22.305.937648785 22 STANDBY +FRA/jyzhaodg/onlinelog/group_22.395.937648787 23 STANDBY +DATA/jyzhaodg/onlinelog/group_23.306.937648787 23 STANDBY +FRA/jyzhaodg/onlinelog/group_23.396.937648789 20 rows selected.