Creating STANDBY REDO Logs
edited Feb 14, 2018 3:11AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 8 commentsAnswered
Hello everyone
We have a 11g R2 RAC (2 node) database in production and are currently in the process of configuring
a standby database
Here are the REDO LOGS details of production database
MEMBER TYPE GROUP#
------------------------------------------------------- ------- ----------
+FRA/prod/onlinelog/group_1.267.732374951 ONLINE 1
+DATA/prod/onlinelog/group_1.294.732374951 ONLINE 1
+DATA/prod/onlinelog/group_2.297.732375699 ONLINE 2
+FRA/prod/onlinelog/group_2.264.732375699 ONLINE 2
+DATA/prod/onlinelog/group_3.296.732375587 ONLINE 3
+FRA/prod/onlinelog/group_3.265.732375587 ONLINE 3
+DATA/prod/onlinelog/group_4.295.732375259 ONLINE 4
+FRA/prod/onlinelog/group_4.266.732375259 ONLINE 4
+FRA/prod/onlinelog/group_5.271.732374481 ONLINE 5
+DATA/prod/onlinelog/group_5.290.732374481 ONLINE 5
+FRA/prod/onlinelog/group_6.270.732374641 ONLINE 6
+DATA/prod/onlinelog/group_6.291.732374641 ONLINE 6
+DATA/prod/onlinelog/group_7.292.732374699 ONLINE 7
We have a 11g R2 RAC (2 node) database in production and are currently in the process of configuring
a standby database
Here are the REDO LOGS details of production database
MEMBER TYPE GROUP#
------------------------------------------------------- ------- ----------
+FRA/prod/onlinelog/group_1.267.732374951 ONLINE 1
+DATA/prod/onlinelog/group_1.294.732374951 ONLINE 1
+DATA/prod/onlinelog/group_2.297.732375699 ONLINE 2
+FRA/prod/onlinelog/group_2.264.732375699 ONLINE 2
+DATA/prod/onlinelog/group_3.296.732375587 ONLINE 3
+FRA/prod/onlinelog/group_3.265.732375587 ONLINE 3
+DATA/prod/onlinelog/group_4.295.732375259 ONLINE 4
+FRA/prod/onlinelog/group_4.266.732375259 ONLINE 4
+FRA/prod/onlinelog/group_5.271.732374481 ONLINE 5
+DATA/prod/onlinelog/group_5.290.732374481 ONLINE 5
+FRA/prod/onlinelog/group_6.270.732374641 ONLINE 6
+DATA/prod/onlinelog/group_6.291.732374641 ONLINE 6
+DATA/prod/onlinelog/group_7.292.732374699 ONLINE 7
1