Fast-Start Failover: Overview Fast-start failover enables the Data Guard broker to rapidly and automatically failover to a previously chosen standby database without requiring manual intervention. This feature increases the availability of your database in the event of a disaster by reducing the need for you to perform a failover operation manually. Fast-start failover can only […]
Data Guard
How to Create or Remove Restore Point on Oracle Standby database
This post is to provide steps to create or remove restore point on standby database. Create restore point on standby database It is required to stop the managed recovery on the standby, otherwise the following error will happen: ORA-38784: Cannot create restore point ‘[name]’. ORA-01153: an incompatible media recovery is active sqlplus / as sysdba […]
How to Create and Drop Guaranteed restore point in Oracle Data Guard
This post describes the steps necessary to create, use and drop a Guaranteed restore point in a Data Guard configuration. For the purposes of this post, the following fictitious environment is used as an example to describe the procedure: Primary database: chicago Standby database: boston Create Guaranteed Restore Point 1. Stop redo transport and redo […]
How to use Flashback Database in Oracle Data Guard Configuration
Flashback Database provides the following advantages in a Data Guard configuration: Provides an alternative to delaying the application of redo to protect against user errors or logical corruptions. By using Flashback Database in this context, standby databases are more closely synchronized with the primary database, thereby reducing failover and switchover times. Eliminates the need to […]
How to switch roles in Oracle Data Guard
Role Management Services In a Data Guard configuration, a database operates in one of two mutually exclusive roles: 1. Primary role 2. Standby role(physical, Logical, Snapshot subtype) You can use role management services to change the primary and standby roles dynamically as a planned transition called a switchover operation, or as a result of a […]
How to Create and Manage Snapshot Standby Database
Snapshot Standby Databases: Overview A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database to a snapshot standby database. A snapshot standby database receives and archives—but does not apply—redo data from a primary database. Redo data received from the primary database is applied when a snapshot […]
How to Use real-time query to access data on a physical standby database
Oracle Active Data Guard Oracle Active Data Guard increases performance, availability, data protection, and return on investment wherever Data Guard is used for real-time data protection and availability. An Oracle Active Data Guard standby database can be used to offload a primary database of reporting, ad hoc queries, data extracts, and backups, making it a […]
How to Create a Physical Standby Database by Using SQL and RMAN Commands
You perform the steps listed below when using SQL and RMAN commands to create a physical standby database. These are high level steps and are explained in detail later in the blog. Prepare the primary database. Set parameters on the physical standby database. Configure Oracle Net Services. Start the standby database instance. Execute the DUPLICATE […]
How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments
It’s important to transfer and apply redo as fast as possible in a Data Guard environment. To achieve this we have to calculate the required network bandwidth based on the redo generation rate on the primary database. The formula used (assuming a conservative TCP/IP network overhead of 25%) for calculating the network bandwidth is: Required […]
What are Oracle Data Guard Protection Modes (redo transport rules) and how to configure them
A Data Guard configuration always runs in one of three data protection modes (also called as redo transport rules): Maximum Protection Maximum Availability Maximum Performance (default mode of operation) All three modes provide a high degree of data protection, but they differ in terms of the effect that each has on the availability and performance […]