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, expand Client Computers > client > Oracle.
- Right-click the instance, point to All Tasks and then click Browse and Restore.
- In the Browse and Restore Options dialog box, select Latest Backup and click View Content.
- Select the database and click Recover All Selected.
- On the Oracle Restore Options dialog box, click RMAN Duplicate DB, then click Next.
The Oracle RMAN Duplicate DB Options window 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