Monthly Archives: January 2017

Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations

Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations

The recommended Oracle® Data Guard configuration is in Maximum Availability mode, when using Oracle Far Sync, which is located near the primary site: Primary Database > Far Sync Instance – Network input/output (I/O) is synchronous (Sync). Far Sync Instance > Standby Database – Network I/O is asynchronous (Async). Primary Database > Standby Database  – As an alternate (when Far Sync is not reachable), network I/O is asynchronous (Async).

read more »
Oracle 12c Release 2 New Features for Active Data Guard

Oracle 12c Release 2 New Features for Active Data Guard

At Oracle Open World 2016 I collected the main improvements and changes are going to be implemented in Oracle Database 12 Release 2: Data Guard Creation with dbca, supports automatic creation of Standby database and Far Sync instance not for RAC (at this point) with the command: dbca -silent -createDuplicateDB     -PrimartDBConnectionString myprymary.domin:1523/chicago.domain     -gdbName chicago.domain -sid boston     -initParams instance_name=boston -createAsStandby     -customScripts /tmp/test.sql Multi-Instance Redo Apply, Parallel, multi-instance recovery – when standby is RAC, all its instances will use the MRP0 process for applying Supports Diagnostic Pack on Active Data Guard AWR+ADDM Reports for Standby are kept in the Primary Supports Tuning Pack and SQL Plan Analyzer Fast Failover – Data Guard take over session draining (switchover to dallas_dr wait;) Read-only sessions connected to Active Data Guard Remain connected during the failover / switchover Become Read/Write after Active Data Guard becomes the primary Password file is managed and transported via the Redo mechanism Alternate prioritization – you will be able to group some destinations and give them a priority over some other destinations. This enables you to decide what will happen when the main destination is back (failback) Support In-Memory Column Store – redo data contains all the information needed for the standby to benefit from the In-Memory Column Store feature. Yossi Nixon Chief Database Architect  

read more »