Oracle active data guard setup

Let's switch back to the original primary. If the primary database is not available the standby database can be activated as a primary database using the following statements. The original primary database can now be configured as a standby. If flashback database was enabled on the primary database, then this can be done relatively easily with the following command. If flashback database is not enabled, you would have to manually recreate cdb1 as a standby. The basic process is the reverse of what you did previously.

It was already mentioned in the previous section, but it is worth drawing your attention to Flashback Database once more. If flashback database is not enabled, the original primary must be scrapped and recreated as a standby database. An alternative is to enable flashback database on the primary and the standby if desired so in the event of a failover, the primary can be flashed back to the time before the failover and quickly converted to a standby database, as shown above.

Once a standby database is configured, it can be opened in read-only mode to allow query access. This is often used to offload reporting to the standby server, thereby freeing up resources on the primary server. Install the full Oracle Database 10 g software kit. Note: The operating system on the observer computer can be different from the operating system running on the primary computer or target standby database computer.

However, the operating system for the primary database computer and all associated standby database computers must be the same. See Also: Configuration file information in Section 1. Section 3. Replace the IP address with the publicIpAddress value for your virtual machine. The Oracle software is already installed on the Marketplace image, so the next step is to install the database.

Do not use OS authentication. Perform the following:. You've completed the Oracle Data Guard setup. The next section shows you how to test the connectivity and switch over.

Update or create the tnsnames. When you no longer need the VM, you can use the following command to remove the resource group, VM, and all related resources:.

Tutorial: Create highly available virtual machines. A database can be in one of two mutually exclusive modes primary or standby. These roles can be altered at runtime without loss of data or resetting of redo logs. This process is known as a Switchover and can be performed using the following commands.

Let's switch back to the original primary. If the primary database is not available the standby database can be activated as a primary database using the following statements. The original primary database can now be configured as a standby. If flashback database was enabled on the primary database, then this can be done relatively easily with the following command. If flashback database is not enabled, you would have to manually recreate db11g as a standby.

The basic process is the reverse of what you did previously. It was already mentioned in the previous section, but it is worth drawing your attention to Flashback Database once more. If flashback database is not enabled, the original primary must be scrapped and recreated as a standby database.

An alternative is to enable flashback database on the primary and the standby if desired so in the event of a failover, the primary can be flashed back to the time before the failover and quickly converted to a standby database, as shown above.