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