Integrating Streams Replication and Standby Databases

The use of Oracle Streams Replication has become more and more common, replacing the more cumbersome Multimaster Advanced Replication.  Many shops use Stream Replication to off load reporting and high impact loads from production databases.  More than half of the clients I support have the destination database in the same rack as the source database.  With both databases located in close proximity, many shops are also implementing physical standbys of one or both of the replicated databases in a remote location.  Oracle Streams and Dataguard Physical Standby database integrate easily, once you understand how the two technologies fit together.

To read more about integrating streams replication and standby databases:

http://www.dba-oracle.com/t_integrating_streams_replication_standby_databases.htm

*****************************************
Can you see your database trends?

After several years of hard work, Ion for Oracle is finally available for general release.  Ion is unlike any other Oracle tool on the market, a tool that encapsulates expert techniques to allow a DBA to quickly visualize important trends and signatures.

Predictive analytics if the key to repairing Oracle problems before they cripple your database, and I created Ion for Oracle to allow any DBA to quickly identify changing workloads and unobtrusive patterns of data access.  Follow the link to try Ion for free:

http://www.ion-dba.com 

*****************************************

Need a health Check?

Oracle is the world's most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf