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
- Set Up the Oracle Standby Database.
- To create a standby database and use a configured instance, on the destination host add an instance on the CommCell Console.
- From the CommCell Browser, go to Client Computers > client > Oracle.
- Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
- Select Latest Backup, and then click the View Content button.
- Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
- Click RMAN Duplicate DB, and then click Next.
The Oracle RMAN Duplicate DB Options dialog box appears.
- Select the standby database host from the Destination Client list.
- Select Duplicate For Standby.
- Select the Recover check box to recover the standby database.
- 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).
- 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.
- On the Stream tab, click Refresh All to verify that the status of the standby database is STARTED.
- 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.
- Click OK to start the restore.
Last modified: 6/7/2019 3:12:55 AM