V11 SP8
Loading...

Performing an Oracle Live Sync Operation to a Standby Database

Perform a Live Sync replication to a standby database.

Live Sync uses the default subclient for the database that you want to replicate, so the default subclient content must contain the entire database, the log files and the control file.

The Live Sync feature performs the following procedures:

  • Initiates the replication automatically after a backup is completed on the source database.
  • Minimizes the impact on production systems CPU and I/O by using the backup data for replications. This method avoids the need to read the source database again for replication.
  • Copies the backup data to remote disaster recovery (DR) sites with deduplication to minimize the wide area network (WAN) traffic. Live Sync then runs at the DR site.
  • Supports the destination database sync in standby mode so that users can schedule workloads on the destination server.
  • Initiates replication after the auxiliary copy completes, when you use a copy precedence for Live Sync.

After you configure Live Sync, the Commvault software runs a full backup, or uses the most recent backup to automatically copy the data from the source database to the destination so that the databases are synchronized.

You can schedule archive log backups, or create an automatic log schedule (see Creating an Automatic Schedule for Database Log Backups). The  software uses the log backups to keep the destination database in sync with the source database.

If no new backups have been run since the last Live Sync, then the scheduled Live Sync does not run.

Best Practice: Have both the source and destination databases in ARCHIVELOG mode.

Before You Begin

  1. Install the Oracle RAC Agent on Windows or UNIX on the auxiliary instance database host. See Getting Started for Oracle RAC.
  2. Add an Oracle RAC instance on the destination client.
  3. Create an auxiliary Instance for the Live Sync destination standby database. For additional information, see Setting Up Instances for Oracle RAC Standby Databases.
  4. Verify that the default subclient content contains the entire database, the log files and the control file.
  5. If you plan to use a storage policy copy, or secondary media, make sure that the copy precedence exists for both the data and log files, and that there is a scheduled auxiliary copy job.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle RAC.
  2. Right-click the instance, point to All Tasks, Live Sync and then Configuration.

    The Live Sync Options dialog box appears.

  3. On the General tab, select the replication options:
    1. From the Destination Client list, select the client where the software replicates the data.
    2. From the Destination Instance list, select the instance where the software replicates the data.

      Note: The software only displays the Oracle instances that support Live Sync, for example, the software does not list +ASM instances.

    3. In the Baseline for Sync area, select the backup to use:
      • To use the latest full backup, select Use most recent full backup.
      • To run a new backup for the Live Sync operation, select Run a new full backup.
    4. Select the Restore Destination in Standby Mode check box.
    5. In the Number of Streams box, type the number of streams that the software will use for the replication.
  4. On the Job Initiation tab, click Configure to modify the Live Sync Schedule.

    For information about the schedule options, see Schedule Pattern or Schedule Details.

    If you choose a schedule that is periodic, for example Daily, and no new backups have ran since the last Live Sync, then the scheduled Live Sync does not run.

  5. Optional: Restore from a storage policy copy, or secondary media.

    Note: When you specify a copy precedence, the software only replicates changes when the source database backup is available on the secondary media or the secondary copy. The backup is available on the media after the auxiliary job completes, so that is when the software attempts the replication.

    1. Click Advanced.

      The Oracle Live Sync Advanced Options dialog box appears.

    2. On the Copy Precedence tab, select the following options:
      1. Select the Restore from copy precedence check box.
      2. In the Copy Precedence box, select the number of the backup copy.
    3. Click OK.
  6. If the destination database directory structure is different from the source, set the redirect path:
    1. Click Advanced.

      The Live Sync Advanced Options dialog box appears.

    2. On the Redirect tab, choose one of the following options:
      • To redirect all of the displayed tablespaces, select the Redirect All Table Spaces/Database To check box and then type the full path in the box.
      • To redirect a set of tablespaces, select the Redirect check box and the choose one of the following options.
        • To select individual tablespaces, click the New Path column associated with the tablespace, and then in the  New Path box, type the path.
        • To redirect multiple tablespaces, click Find & Replace, and then enter the new path in the New Path box.
    3. Click OK.
  7. Click OK.

Results

After the job completes, the software opens the Live Sync destination database in read-only mode.

The first Live Sync job is marked as Completed with Errors (CWE).

For Live Sync jobs, the Job Controller tab shows Replication as the Operation Type.

The software creates a new schedule every time you replicate to a new destination. For example, if you restore to client1 and then client2, the software creates a schedule for each client.

Note: If the destination database is opened in the read write mode, or with the resetlogs option, then you must reconfigure the replication options (Live Sync Options dialog box, General tab) that are specified in the procedure.