High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Using Maximum protection mode still can lost data

Tested DG in maximum protection mode, still can lost committed transaction for 1 or 2 million seconds.

Anyone know how oracle DG handle notification from standby site before to commit the transaction on primary ?

Here is the test case, please help to check any incorrect configuration for this test case and share your explanation for such data loss.

The tests run on ADG, both databases are 12.1.0.2 on Linux. 

1)create a table, test_1,  with 1 row.

      desc test_1;

      Name Null? Type

      ----------------------------------------- -------- ----------------------------

       TIME                                               VARCHAR2(30)

       ID                                                   NUMBER

     insert into test_1 values (' xxx ',  1);

2)Run update with below script

     spool test_ha.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center