Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-1
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3
Also the cached pages are at my network at the following location:
\\192.168.0.61\lsi_shared_files\Build_10g_RAC_(Jeff_Hunter_Oracle_Document)
--Moid
Monday, February 28, 2011
Sunday, February 27, 2011
Saturday, February 26, 2011
How to build an Oracle VMware machine and install 10g R2 (Part-2)?
Click on the following link:
Part-II Prepare Linux for Oracle (all prerequisites) v1.3
--Moid Muhammad
Part-II Prepare Linux for Oracle (all prerequisites) v1.3
--Moid Muhammad
Thursday, February 24, 2011
Tuesday, February 22, 2011
Friday, February 11, 2011
Friday, February 4, 2011
Thursday, February 3, 2011
Wednesday, February 2, 2011
How to change the protection mode from "maximum performance" to "maximum availability" in a 10g Data Guard environment?
Let's see how many different kind of protection modes Oracle offers in a Data Guard Environment.
Maximum Protection—This mode offers the highest level of data protection. Data is synchronously transmitted to the standby database from the primary database and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database. This mode ensures no-data-loss.
Maximum Availability—This mode is similar to the maximum protection mode, including zero data loss. However, if a standby database becomes unavailable (for example, because of network connectivity problems), processing continues on the primary database. When the fault is corrected, the standby database is automatically resynchronized with the primary database.
Maximum Performance—This mode offers slightly less data protection on the primary database, but higher performance than maximum availability mode. In this mode, as the primary database processes transactions, redo data is asynchronously shipped to the standby database. The commit operation of the primary database does not wait for the standby database to acknowledge receipt of redo data before completing write operations on the primary database. If any standby destination becomes unavailable, processing continues on the primary database and there is little effect on primary database performance.
How to change from "maximum performance" to "maximum availability"? Click here for the instructions.
--Moid
Keywords:
Data Guard Protection Mode.
Maximum Protection—This mode offers the highest level of data protection. Data is synchronously transmitted to the standby database from the primary database and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database. This mode ensures no-data-loss.
Maximum Availability—This mode is similar to the maximum protection mode, including zero data loss. However, if a standby database becomes unavailable (for example, because of network connectivity problems), processing continues on the primary database. When the fault is corrected, the standby database is automatically resynchronized with the primary database.
Maximum Performance—This mode offers slightly less data protection on the primary database, but higher performance than maximum availability mode. In this mode, as the primary database processes transactions, redo data is asynchronously shipped to the standby database. The commit operation of the primary database does not wait for the standby database to acknowledge receipt of redo data before completing write operations on the primary database. If any standby destination becomes unavailable, processing continues on the primary database and there is little effect on primary database performance.
How to change from "maximum performance" to "maximum availability"? Click here for the instructions.
--Moid
Keywords:
Data Guard Protection Mode.
Subscribe to:
Posts (Atom)