Oracle DB 12.1.0.2
source: rac 2 nodes
downstream DB: RAC 2 nodes (A).
target DB (standby) : single node.
Hello Team,
There is goldengate replication downstream from source Oracle 12.1.0.2 to A. Standby redo logs have been created on A. I would like to know whether I will need to create additional standby redo logs on A for dataguard configuration.
On A:
SELECT * FROM V$LOG;
1 ONLINE +DATA/DWARE1/ONLINELOG/group_1.339.1018688715 NO 0
2 ONLINE +DATA/DWARE1/ONLINELOG/group_2.340.1018688733 NO 0
3 ONLINE +DATA/DWARE1/ONLINELOG/group_3.347.1018688743 NO 0
4 ONLINE +DATA/DWARE1/ONLINELOG/group_4.348.1018688759 NO 0
16 ONLINE +DATA/DWARE1/ONLINELOG/group_16.542.1018688805 NO 0
17 ONLINE +DATA/DWARE1/ONLINELOG/group_17.543.1018688819 NO 0
18 ONLINE +DATA/DWARE1/ONLINELOG/group_18.544.1018688833 NO 0
19 ONLINE +DATA/DWARE1/ONLINELOG/group_19.545.1018688847 NO 0
21 STANDBY +DATA/DWARE1/ONLINELOG/group_21.334.1018650713 NO 0
22 STANDBY +DATA/DWARE1/ONLINELOG/group_22.333.1018650717 NO 0
23 STANDBY +DATA/DWARE1/ONLINELOG/group_23.352.1018650719 NO 0
24 STANDBY +DATA/DWARE1/ONLINELOG/group_24.332.1018650723 NO 0
25 STANDBY +DATA/DWARE1/ONLINELOG/group_25.331.1018650727 NO 0
26 STANDBY +DATA/DWARE1/ONLINELOG/group_26.330.1018650731 NO 0
27 STANDBY +DATA/DWARE1/ONLINELOG/group_27.329.1018650733 NO 0
28 STANDBY +DATA/DWARE1/ONLINELOG/group_28.328.1018650737 NO 0
29 STANDBY +DATA/DWARE1/ONLINELOG/group_29.327.1018650741 NO 0
30 STANDBY +DATA/DWARE1/ONLINELOG/group_30.326.1018650745 NO 0
31 STANDBY +DATA/DWARE1/ONLINELOG/group_31.325.1018650749 NO 0
32 STANDBY +DATA/DWARE1/ONLINELOG/group_32.324.1018650751 NO 0
33 STANDBY +DATA/DWARE1/ONLINELOG/group_33.323.1018650755 NO 0
34 STANDBY +DATA/DWARE1/ONLINELOG/group_34.322.1018650759 NO 0
35 STANDBY +DATA/DWARE1/ONLINELOG/group_35.321.1018650763 NO 0
36 STANDBY +DATA/DWARE1/ONLINELOG/group_36.320.1018650767 NO 0
37 STANDBY +DATA/DWARE1/ONLINELOG/group_37.319.1018650769 NO 0
38 STANDBY +DATA/DWARE1/ONLINELOG/group_38.318.1018650773 NO 0
39 STANDBY +DATA/DWARE1/ONLINELOG/group_39.317.1018650777 NO 0
40 STANDBY +DATA/DWARE1/ONLINELOG/group_40.316.1018650781 NO 0
41 STANDBY +DATA/DWARE1/ONLINELOG/group_41.315.1018650783 NO 0
42 STANDBY +DATA/DWARE1/ONLINELOG/group_42.312.1018650787 NO 0
5 ONLINE +DATA/DWARE1/ONLINELOG/group_5.512.1018688105 NO 0
6 ONLINE +DATA/DWARE1/ONLINELOG/group_6.511.1018688121 NO 0
7 ONLINE +DATA/DWARE1/ONLINELOG/group_7.534.1018688135 NO 0
8 ONLINE +DATA/DWARE1/ONLINELOG/group_8.533.1018688149 NO 0
9 ONLINE +DATA/DWARE1/ONLINELOG/group_9.535.1018688171 NO 0
10 ONLINE +DATA/DWARE1/ONLINELOG/group_10.536.1018688189 NO 0
11 ONLINE +DATA/DWARE1/ONLINELOG/group_11.537.1018688207 NO 0
12 ONLINE +DATA/DWARE1/ONLINELOG/group_12.538.1018688223 NO 0
13 ONLINE +DATA/DWARE1/ONLINELOG/group_13.539.1018688235 NO 0
14 ONLINE +DATA/DWARE1/ONLINELOG/group_14.540.1018688249 NO 0
15 ONLINE +DATA/DWARE1/ONLINELOG/group_15.541.1018688259 NO 0
20 ONLINE +DATA/DWARE1/ONLINELOG/group_20.546.1018688857 NO 0
How many standby redo logs should I create on B?
Thanks,
Joe