Active Data Guard Demonstrations

     
New!   demo

download    

Far Sync Zero Data Loss at any Distance - Active Data Guard
The impact that synchronous zero data loss protection has on database performance can lead to undesirable compromises. Customers with large distance between sites must compromise on protection and use asynchronous transport, accepting data loss in return for acceptable performance. Active Data Guard Far Sync, a new capability for Oracle Database 12c, eliminates compromise by extending zero data loss protection to any standby database located at any distance from a primary database, and doing so at minimal expense and without additional complexity.  This demonstration shows how Active Data Guard 12c Far Sync is configured and zero data loss failovers performed.

New!   demo

download    

Global Temporary Tables and Sequences - Active Data Guard
As of Oracle Database 12c Release 1 (12.1), the new temporary undo feature allows the undo for changes to a global temporary table (GTT) to be stored in the temporary tablespace as opposed to the undo tablespace. Undo stored in the temporary tablespace does not generate redo, thus enabling redo-less changes to global temporary tables. This allows DML operations on global temporary tables on Oracle Active Data Guard standbys. In addition sequences created at the primary database can be accessed from Active Data Guard standby databases as well, both global to the entire Data Guard configuration or local only to the current session. This demonstration shows how to enable and use GTTs and both Global and Session Sequences on an Active Data Guard standby database.

  download    

Automatic Block Repair at a Primary Database - Active Data Guard
This demonstrates how Active Data Guard 11g will automatically repair physical on-disk block corruption at a primary database. Block-level data loss usually results from intermittent, random I/O errors, as well as memory corruptions that are written to disk. Normally when Oracle discovers a corruption it marks the block as media corrupt, writes it to disk, and returns an ORA-1578 error to the application. No subsequent read of the block will be successful until the block is recovered manually. However, if the corruption occurs on a primary database that has an Active Data Guard standby, block media recovery is performed automatically, transparent to the application, using a good copy of the block from the active standby database. Conversely, bad blocks on an active standby database are automatically recovered using the good version from the primary database.

 
  download

Automatic Block Repair at a Standby Database - Active Data Guard
This demonstrates how Active Data Guard 11g will automatically repair physical on-disk block corruption that occurs at a standby database completely independent of the primary. Detection and automatic repair of physical on-disk block corruption at a standby database is initiated by 1) any read-write transaction at the primary database, 2) any read-only transaction at the primary database, or 3) any block that is read by media recovery or by read-only transactions at the Active Data Guard standby. Automatic repair is transparent to both Redo Apply and to applications running at either the primary or active standby database; Oracle will signal that the repair has occurred in the database alert log. Active Data Guard uses multiple approaches to detect and automatically repair corruption at a standby database both to maintain data protection and to provide high availability for read-only workload offloaded to the standby system.

 

download 

Production Offload - Oracle Active Data Guard
This demonstrates the benefits of using a synchronized physical standby database that is open read-only to offload ad-hoc queries and reporting from your production database, thus achieving scalable performance and fast, predictable response times for read-write business transactions. Click on the demo link to download the demo and run on your desktop, use the control at the bottom of the demo screen to initiate demo. Click here for Active Data Guard MAA Best Practices.



download

Data Pump and Standby Statspack - Active Data Guard
This demonstrates how to utilize an Active Data Guard standby database as a source for Data Pump to extract data for other uses.  The demonstration also shows how to use Standby Statspack to collect statistics from an Active Standby Database to assist in query tuning. Click on the demo link to download the demo and run on your desktop, use the control at the bottom of the demo screen to initiate demo. See My Oracle Support Note 454848.1 for details on using Standby Statspack. 



download

Query Service Level Agreement - Active Data Guard
This demonstrates how to configure automatic monitoring of an Active Data Guard standby database.  Should the standby apply lag exceed designated service level agreements for any reason (e.g. a network outage or if apply stops to protect against primary data corruptions), Data Guard will automatically notify applications that the standby is not current and read-only queries can be redirected to another active standby database or the primary to insure service level objectives are met. Click on the demo link to download the demo and run on your desktop, use the control at the bottom of the demo screen to initiate demo.



download 

DML Redirection - Active Data Guard
There are many read-mostly applications that are able to use an Active Data Guard standby database to offload read-only workload from the primary database by redirecting a small number of required DML operations back to the primary database.  This demonstration shows how to configure DML redirection using Active Data Guard. Click on the demo link to download the demo and run on your desktop, use the control at the bottom of the demo screen to initiate demo. 


KScope 14 RHS Banner

Database Cloud Service Banner