In the High Availability section under Data Guard, click Setup and Manage and log in

If the primary database is not already in a broker configuration, clicking Setup and Manage in Step 5 will go to the page shown in Figure 6–1. This screenshot shows information presented on the All Targets tab, containing graphs for all targets

discovered for the cluster. From the list of managed targets, you can quickly assess the availability of the targets and click any graph to drill down for more information.

Figure 6–1 Create a Broker Configuration

If the primary database is already part of a broker configuration, clicking Setup and Manage in Step 5 will go to the Data Guard Overview page as shown in Figure 6–2.

Note: If you log in as a user with SYSDBA privileges, you will have access to all Data Guard functionality, including all monitoring and management features. If you log in as a

non-SYSDBA user, you will have access to monitoring functions only; features such as standby creation, switchover, and failover will not be available.

See Also: Section 6.2, "Scenario 2: Creating a Configuration or Adding an Additional Standby Database"

Scenario 1: Accessing the Data Guard User Interface

Figure 6–2 Data Guard Overview Page

On the Data Guard Overview page, you can:

■ Edit the protection mode—click Protection Mode in the Data Guard Overview section to view the current protection mode setting and, if necessary, change the protection mode.

■ Enable Fast-Start Failover—click Disabled to invoke the Fast-Start Failover wizard that will guide you through the process of enabling fast-start failover and the observer.

■ View a summary of standby progress—this chart shows the amount of data that each standby database has not yet received and applied.

■ Retrieve information about the primary database—click Name, Host, Status, Current Log, or Properties (Edit) to view pertinent information about the primary database.

If you click Status or Edit, you are taken to the Edit Properties page where you can view and change the current state or properties of the primary database.

■ View or change information on the standby databases:

– Add a standby database to the broker configuration—click Add Standby Database to add a physical or logical standby database.

– Change the state or properties—click Edit to go to the Edit Properties page to view and change the current state or properties of the standby database.

– Discontinue Data Guard broker control—click Remove to remove the selected standby database from Data Guard broker control.

– Switch the role from standby to primary—click Switchover to switch the database roles from standby to primary.

Scenario 2: Creating a Configuration or Adding an Additional Standby Database

– Transition the standby database to the role of primary database— click

Failover when a catastrophic failure occurs on the primary database, and there is no possibility of recovering the primary database in a timely manner. The target standby database assumes the primary role, and the failed primary database is disabled by the broker. See Section 5.4.3 for steps to reenable the failed primary database as a standby database to the new primary database.

■ View performance information for the configuration and status of online redo log files for each standby database:

– Click Performance Overview to view information about data archived and applied, a summary of standby progress, and a summary of log services.

– Click Log File Details to view the status of online redo log files that were generated on the primary database but not received by the standby, and for online redo log files that were received but not applied to the standby database

■ Perform additional administrative activities:

– Click Verify to check the protection mode and properties, confirm that standby redo log files are present, and verify log switch.

– Click Remove Data Guard Configuration to remove the broker configuration from Data Guard broker control.

■ Search for information about any Enterprise Manager topic—Click Help to display the Welcome to Oracle Data Guard help topic. Once in the online Help system, you can use the Contents page or Search page to locate help topics of interest.

6.2 Scenario 2: Creating a Configuration or Adding an Additional Standby Database

Creating a broker configuration is the first thing you must do before you can manage and monitor the databases. Enterprise Manager provides the Add Standby Database wizard to create a broker configuration that includes a primary database and one or more standby databases. This scenarios shows how to use the Add Standby Database wizard later to add a logical standby database to a broker configuration that already has one physical standby database (DR_Sales). To start the Add Standby Database wizard, click Add Standby Database on the Data Guard Overview page.

After clicking Add Standby Database, you can select one of the following options:

■ Create a new physical standby database (single-instance only)

■ Create a new logical standby database (single-instance only)

■ Manage an existing standby database with Data Guard broker..

■ Create a primary database backup only

You will need to connect to the primary database using SYSDBA credentials, if you are not yet connected.

See Also: Oracle Data Guard Concepts and Administration for the steps about how to create a RAC standby database

Scenario 2: Creating a Configuration or Adding an Additional Standby Database

Figure 6–3 show the introductory page of the create configuration process.

Figure 6–3 Add Standby Database Wizard - Introductory Page

The Add Standby Database wizard takes you through the following steps:

1. Determine the backup type.

2. Set up the backup options.

3. Select the Oracle home in which to create the standby database.

4. Set up the location for standby database files.

5. Provide standby database configuration parameters.

6. Review the information before clicking Finish.

The following steps assume a broker configuration already exist with one primary database and one physical standby database, and creates a new logical standby database. It shows how the wizard takes you through additional steps to select the Oracle home for the database and to copy datafiles to the standby database.