By Larry Carpenter, Joseph Meeks, Charles Kim, Bill Burke, Sonya Carothers, Joydip Kundu, Mike Smith, Nitin Vengurlekar
Read or Download Oracle Data Guard 11g Handbook (Osborne ORACLE Press Series) PDF
Best oracle books
This publication lias been written for the next audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. despite the fact that, that will recognize extra approximately Oracle9i Java gains, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration point of view.
There are few books out that take care of Oracle textual content and XSQL. utilizing the methodologies, practices, and so forth. i discovered little need to look for one more reference.
Oracle functionality Survival advisor a scientific method of Database Optimization the quick, whole, start-to-finish advisor to optimizing Oracle functionality Oracle functionality Survival consultant bargains a established, systematic, start-to-finish method for optimizing Oracle functionality as successfully as attainable.
This self-study examination guidance advisor for the Oracle Database 10g Database Administrator OCP certification examination comprises every little thing you must try out your self and move the examination. All examination issues are lined and insider secrets and techniques, whole factors of all Oracle Database 10g Database Administrator OCP matters, attempt methods and information, a number of hugely practical pattern questions, and routines designed to bolster knowing of Oracle Database 10g Database Administrator OCP innovations and get ready you for examination good fortune at the first test are supplied.
- Professional Oracle 8i Application Programming with Java, PL/SQL and XML
- Oracle Performance Tuning
- Oracle DBA Scripting Quick Reference
- ORACLE BUSINESS INTELLIGENCE AND ESSBASE SOLUTIONS GUIDE
- The Pocket Oracle and Art of Prudence
Extra info for Oracle Data Guard 11g Handbook (Osborne ORACLE Press Series)
Centralized management is possible by virtue of the broker maintaining a configuration file that includes profiles for all databases in the Data Guard configuration. You can connect to any database in the configuration and the broker will propagate changes to all other databases in the configuration and their server parameter files. The broker also includes commands to start an observer, the process that monitors the status of a Data Guard configuration and executes an automatic failover (Fast-Start Failover) if the primary database should fail.
While these are legitimate concerns for any automatic solution, Data Guard Fast-Start Failover has been carefully designed to avoid these problems. Data Guard has very specific, user-configurable rules to control an automatic failover for SYNC and ASYNC configurations, preventing false failovers and making it impossible for a split-brain condition to occur. It will never allow an automatic failover if the resulting data loss exceeds the previously configured recovery point threshold. 14 Data Guard Fast-Start Failover automatically reinstates the failed primary database as a standby for the new primary, assuming it is salvageable, and thus creates no extra work for the DBA compared to manual failover procedures.
While SYNC guarantees protection for every transaction that the database acknowledges as having been committed, this guarantee can also impact primary database performance. The cause of the performance impact is obvious: the LGWR must wait for confirmation that data is protected at the standby before it can proceed with the next transaction. The degree of impact this has on application response time and database throughput is a function of several factors: the redo-write size, available network bandwidth, round-trip network latency (RTT), and standby I/O performance writing to the SRL.