SQL Apply Best Practicies: Data Guard in Oracle Database 10g Release 2

claim, and system statistics. See the Oracle Database Performance Tuning Guide [14] Oracle Database 10g Release 2 for more information about Oracle Database Performance Tuning Guide 10g Release 2 ….

More PDF Content

SQL Apply Best Practices: Oracle Data Guard 10g Release 2, Contents:

  • Executive Overview… 4
  • Benefits of SQL Apply… 4
  • Efficient Use of Standby Hardware Resources… 4
  • Reduction in Primary Database Workload… 4
  • Introduction … 5
  • SQL Apply Enhancements … 5
  • Oracle Database 10g Release 1 Enhancements … 5
  • Standby Redo Log Files… 5
  • Real-Time Apply… 5
  • Support for Maximum Protection Mode… 5
  • Zero Downtime Instantiation … 6
  • Improved SQL Apply Performance… 6
  • Faster SQL Apply Switchover and Failover… 6
  • Identification of Unnecessary Log Files … 6
  • Integration with Flashback Database to Resolve Logical Failures… 6
  • Support for More Data Types… 7
  • Ability to Upgrade the Oracle Database Using SQL Apply … 7
  • Improved Redo Data Transmission Security … 7
  • Oracle Database 10g Release 2 Enhancements … 7
  • Improved SQL Apply Performance… 7
  • Support for Fast-Start Failover … 7
  • Enhanced Data Guard Statistics … 7
  • Log Writer Process Asynchronous Transport Enhancements… 7
  • Modified SQL Apply Parameters for Improved Manageability … 8
  • Simpler Logical Standby Configuration with Less Tuning … 8
  • Support for More Data Types… 8
  • SQL Apply Best Practices … 8
  • Confirm Data Type Support … 9
  • Use Standby Redo Log Files … 10
  • Use Real-Time Apply … 10
  • Consider Using a No Data Loss Protection Mode… 10
  • Tune SQL Apply… 11
  • Adjust How Transactions Are Applied on the Logical Standby
  • Database … 11
  • Use the Standard Oracle Tuning Methodology … 13
  • Additional Tuning Guidelines Specific to Logical Standby
  • Databases… 14
  • Benefit From Improved SQL Apply Performance… 14
  • Performance Improvement: Increasing MAX_SERVERS… 16
  • Performance Improvement: Changing COMMIT_ORDER… 16
  • Implement Faster SQL Apply Switchover and Failover… 17
  • Flash Recovery Area and Standby Archived Log Files … 17
  • Manage Logical Standby Archived Log Files … 18
  • Use Fast-Start Failover… 18
  • Use Enhanced Data Guard Management Statistics… 19
  • Use the Asynchronous Redo Transport Enhancements… 19
  • Conclusion… 20
  • Appendix A … 21
  • Quick Reference – Upgrading from Oracle9i Database to Oracle
  • Database 10g… 21
  • References … 21

 

Download SQL Apply Best Practicies: Data Guard in Oracle Database 10g Release 2 pdf from www.oracle.com, 23 pages, 271.66KB.
Related Books

Leave a Reply