> Essential > Databases > Oracle > Replication of Databases

Configuring Replication for an Oracle Database

You can configure replication to a non-standby database. Replication uses the default subclient for the database that you want to replicate, so the default subclient must include the entire database, the log files, and the control file.

If no new backups have run since the last replication operation, then the scheduled replication operation does not run.

Note

For the best results, put the source database and the destination database in ARCHIVELOG mode.

Before You Begin

  • Install the Oracle agent on the Windows or the UNIX destination database host.

    For more information, see Getting Started with Oracle.

  • Add an Oracle instance on the destination client.

    For more information, see Managing Oracle Database Instances.

  • Set up an Oracle instance for the replication destination database.

    For more information, see Setting Up an Oracle Instance for Replication.

  • Verify that the default subclient includes the entire database, the log files, and the control file.

  • If you plan to use a storage policy copy, or secondary media, verify that copy precedence exists for both the data and the log files, and that a scheduled auxiliary copy job exists.

  • Data backup for the replication destination database should already have been disabled when the destination instance was configured. For more information, see Setting Up an Instance for Replication.

Procedure

  1. From the navigation pane, go to Disaster recovery > Replication.

    The Replication groups page appears.

    Note

    You can also access the Replication groups page from the instance level.

  2. Click Configure replication group, and then select Oracle.

    The Configure replication group - Oracle page appears.

  3. On the Source tab, enter the following information for the source computer:

    1. In the Name box, type a name for the replication schedule that you are creating.

    2. From the Servers list, select the server where the source Oracle instance is running.

    3. From the Instances list, select the source Oracle instance.

    4. Click Next.

  4. On the Target tab, enter the following information for the destination computer:

    1. From the Servers list, select the server where the destination Oracle instance is running.

    2. From the Instances list, select the instance on which you want to replicate the data from the source computer.

    3. Click Next.

      Note

      • The operating system of the source server and the destination server must be the same.

      • The software does not list Automatic Storage Management (ASM) instances.

  5. On the Override options tab, complete the following tasks:

    1. If the destination database directory structure is different from the source database, then, to set the redirect path, click Redirect options, and then select one of the following options:

      1. To redirect all the tablespaces, select the Redirect all tablespaces option, and then type the full path in the box.

      2. To redirect a subset of tablespaces or individual tablespaces to different paths, select the Redirect individual tablespaces option, and then specify the redirect path for each datafile.

    2. Click Advanced options.

    3. Optional: To specify which backup operation the software will run after you complete this procedure, select one of the following options:

      1. To use the most recent full backup operation, select the Use most recent full backup option.

        Selecting this option causes the software to run an incremental backup operation using the most recent full backup operation.

      2. To run a full backup operation, select the Run a new full backup option.

    4. Optional: In the Number of streams box, specify the number of streams to use for the replication operation.

    5. Optional: If you want to restore from a storage policy copy or use a secondary media for replication, then from the Copy Precedence list, select a storage policy copy.

      Note

      If you select a storage policy copy from the Copy Precedence list, then the software replicates changes only when the source database backup is available on the storage policy copy or the secondary media. The backup is available on the media after the auxiliary job completes, so that is when the software attempts the replication.

  6. Click Submit.

Results

  • After the job completes, the software opens the replication destination database in read-only mode.

    If you want to perform a backup operation on the destination database after the replication operation completes, then you must open the database in read-write mode because Oracle does not allow a control file backup when the database is in read-only mode.

  • The Replication Monitor appears at the bottom of the instance page that you configured replication for.

What to Do Next

  • To view existing replication groups, go to Monitoring > Replication monitor.

  • You can view the global Replication Monitor table, which contains information about the status of replication groups, replication clients, and replication jobs.

Loading...