Skip to Main Content

standby redologs

RobeenAug 12 2020 — edited Aug 12 2020

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

Comments
Post Details
Added on Aug 12 2020
2 comments
18 views