Loading...

Creating an Oracle Standby Database

You can create a standby database to use as the primary failover database, or as a reporting database by opening the database in read-only mode.

Create the standby database with a configured instance.

Apply the archived redo logs from the primary database to update the standby database.

Note: The standby database does not have a unique database identifier (DBID).

Before You Begin

  1. Set Up the Oracle Standby Database.
  2. To create a standby database and use a configured instance, on the destination host add an instance on the CommCell Console.

Procedure

  1. From the CommCell Browser, go to Client Computers > client > Oracle.
  2. Right-click the instance, then go to All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box appears.

  3. Select Latest Backup, and then click the View Content button.
  4. Select the database, and then click the Recover All Selected button.

    The Oracle Restore Options dialog box appears.

  5. Click RMAN Duplicate DB, and then click Next.

    The Oracle RMAN Duplicate DB Options dialog box appears.

  6. Select the standby database host from the Destination Client list.
  7. Select Duplicate For Standby.
  8. Select the Recover check box to recover the standby database.
  9. If you want the system to refer to the target database's control files rather than the Recovery Catalog database select NO CATALOG (already selected by default).
  10. If you want the system to refer to the Recovery Catalog database, unselect NO CATALOG. In the Catalog Connect box enter the Oracle catalog connect string credentials.
    • Enter the catalog user name.
    • Enter the catalog user password.
    • Enter the Oracle service name.
  11. On the Stream tab, click Refresh All to verify that the status of the standby database is STARTED.
  12. Optional: View or customize the RMAN script that is generated from the selected options. For more information, see Viewing Oracle Restore RMAN Scripts and Customizing Oracle Restore RMAN Scripts.
  13. Click OK to start the restore.

Last modified: 6/7/2019 3:12:55 AM