Active - Active or 2-way replication is very similar to 1-way replication. This is used when changes can be made to both databases and they both must be kept in sync.
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| /MINE IS running. Currently at plog 12 (redo sequence 1391 [1] 1796 [2]) and SCN 46709633 (04/12/2012 18:50:45).
APPLY IS running. Currently at plog 12 and SCN 46708889 (04/12/2012 18:50:34).
APPLY1 IS running. Currently at plog 349 and SCN 17550807 (04/12/2012 18:56:31).
MINE1 IS running. Currently at plog 349 and SCN 17550829 (04/12/2012 18:56:35).
Progress of replication orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------
0 tables listed.
Progress of replication orcl:MINE1->APPLY1: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------
0 tables listed. |
|
|
With 2-way replication the table listing in the console can so long that the prompt cannot be seen. By default, 30 tables are listed for each replication, thus for a 2-way replication, it takes up to 70 screen lines.
To change this, edit the *-MINE.ddc file and add line "set STATUS_BAR_ACTIVE_TABLES 5". Or enter this command at the console prompt. Restart the console for this change to take affect.