Loading...

SnapProtect – Configuration – Oracle

Configuration

The following sections provide the necessary steps required to create and configure the components for a first SnapProtect backup of an Oracle database.

Configuring an Instance

  1. From the CommCell Browser,

    • Navigate to Client Computers | <Client>
    • Right-click Oracle and then click Properties.

  2. From the Agent Properties dialog box,

    • Select the Enable Instance Discovery checkbox.
    • Click OK.

  3. From the CommCell Browser,

    • Navigate to Client Computers | <Client>
    • Right-click Oracle, point to All Tasks and then click Discover Instance.

  4. Click Yes.

    If your Oracle database uses an ASM instance and the instance is in a different Oracle Home, you may have to manually configure the ASM instance as the discovery operation may not find it. When configuring the instance, verify the database status shows as STARTED.

  5. From the CommCell Browser,

    • Navigate to Client Computers | <Client>|Oracle.
    • Right-click the <Instance> and then click Properties.

  6. On Windows clients:

    • Click Change.
    • In the User Account box, enter the user name to access the Oracle application.
    • In the Password box, enter the password for the user account.
    • In the Confirm Password box, re-confirm the password.
    • Click OK.

  7. On the Details tab, enter the Oracle connection information:
    • To use the Oracle Wallet feature (Secure External Password Store), select the Oracle Wallet Auto Login check box and just provide the TNS service name in the third Connect String box.

      Note: If you provide the user name and password, the software ignores the Oracle Wallet feature.

    • To use the Oracle Connect String, select the Use Connect String check box and in the Connect String box provide the user name, the user password and the TNS service name.

      Note: If you want to use an account that is other than 'sys', you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege to the user account.

    Enter the Connect String to connect to the Oracle database as follows:

    1. In the first box enter the Database user ID.
    2. In the second box enter the Password.
    3. In the Confirm Password dialog box, re-enter the password, and click OK.
    4. In the third box enter the Oracle Service name.

    For example, in the following:

    sysdba/<password>@orcl

    sysdba is the Database User ID

    <password> is the Database User ID password

    orcl is the Oracle service name

    • Click the Storage Device tab.
    • In the Storage Policy used for user command backup of data box, select a storage policy name.

    • Click the Logs Backup tab.
    • In the Storage Policy used for all Archive Log backups box, select a storage policy name.
    • Click OK.

  8. From the CommCell Browser,

    • Navigate to Client Computers | <Client> | Oracle | <Instance>. 
    • Right-click the default subclient and then click Properties.

    • Click the Storage Device tab.
    • In the Data Storage Policy list, select a Storage Policy name.
    • Click OK to convert the next backup as a full backup.
    • Click OK.

Skip this section if not using Solaris.

Enable SnapProtect Backups on Solaris Zone

Follow the steps given below to enable SnapProtect backups on each of the non-global zone clients containing the application data.

  1. From the CommCell Console, navigate to Client Computers | <Client>
    • Right-click the client and select Properties.
    • Click Advanced.
  2. In the Advanced Client Properties (General) tab
    • Select the Global zone host name from the drop-down list.
    • Click OK.

      • We support disks on a global zone mounted using loopback File System on a non global zone.
      • This option need not be enabled if you are using a NFS share. This is because when using NFS mount paths, the operations are limited to the non-global zone and does not use the global zone.

  3. Click OK and repeat the above steps on all the non-global zone clients containing the application data.

Create a Snapshot Copy

  1. From the CommCell Browser, expand Policies > Storage Policies.
  2. Right-click the storage_policy and click All Tasks > Create New Snapshot Copy.
  3. In the Copy Name box, enter a name.
  4. From the Library list, MediaAgent list, Drive Pool list, Scratch Pool list, select the appropriate library, MediaAgent, drive pool and scratch pool.

    Note: Drive pool and scratch pool are applicable only for tape libraries.

  5. Click OK.

Configuring a Backup Copy

A backup copy operation provides the capability to copy snapshots of the data to any media. It is useful for creating additional standby copies of data and can be performed during the SnapProtect backup (inline) or at a later time (offline).

Follow the steps given below to configure Backup Copy for moving snapshots to media.

  1. From the CommCell Browser, expand Policies | Storage Policies | <Storage Policy>.
  2. Right-click the appropriate <Storage Policy> and click Properties.
  3. In the Storage Policy Properties dialog box, click the Snapshot tab.
  4. Select Enable Backup Copy checkbox to enable movement of snapshots to media.

  5. Click OK.