Searching...
SmallMediumLarge
Home Print Show Topic URL Previous Next

Ingesting an Oracle database with NetBackup CoPilot

Velocity Help

If your environment includes Veritas NetBackup CoPilot, you can use it to ingest an Oracle database into Velocity. The Velocity or database administrator coordinates with the NetBackup administrator to enable copies of a database to be made available to users.

Before you begin this process, ensure that your NetBackup and Velocity environments meet the requirements for using NetBackup to ingest an Oracle database to Velocity. The process will not work if your environments are not configured correctly.

See How to set up NetBackup CoPilot to ingest Oracle databases into Velocity

Table: How to ingest an Oracle database with NetBackup CoPilot

Step

Instructions

Details

Step 1

In Velocity, add a database source.

This operation is usually performed by the Velocity administrator or database administrator.

See Adding an Oracle database to ingest into Velocity

When you are prompted to choose a method to ingest the database source on the Choose Method panel, select the Use NetBackup option. On the Add a Database Source panel, select the From NetBackup CoPilot option.

After the database source is added, click Details next to the new database source. On the Details dialog, note the NFS export path. The NetBackup administrator must have this information to complete the ingest process.

Step 2

In NetBackup, ensure that the database instance is registered.

This operation is usually performed by the NetBackup administrator.

For information about registering a database instance, see the NetBackup for Oracle Administrator's Guide.

Only registered database instances can be used in an Oracle policy.

Step 3

In NetBackup, create two storage lifecycle policies.

This operation is usually performed by the NetBackup administrator.

For information about storage lifecycle policies, see the NetBackup Copilot Configuration Guide.

The following storage lifecycle policies are required:

  • Stream

    For the stream storage lifecycle policy, create a Backup operation, and then select a storage unit.

  • Snapshot

    For the snapshot storage lifecycle policy, create a Snapshot operation and a Backup From Snapshot operation. Be sure to use the same storage unit that you used in the stream storage lifecycle policy.

Step 4

In NetBackup, create an Oracle Intelligent Policy.

This operation is usually performed by the NetBackup administrator.

For information about Oracle Intelligent Policies, see the NetBackup Copilot Configuration Guide.

Be sure to select the following options in this NetBackup policy:

  • On the Attributes tab, select Oracle as the policy type.

  • On the Attributes tab, in the Policy storage field, select the stream SLP.

  • On the Instances and Databases tab, select the Oracle instance.

  • On the Backup Selections tab, select Whole Database - Datafile Copy Share. Then, click Browse, select the instance name from the left pane, and then select the checkbox next to the Velocity NFS export path that the Velocity administrator provided. In Velocity, the NFS export path can be located on the Database Sources dialog by clicking the Details button next to the database source that was added in step 1 above.

  • On the Schedule tab, create a Full schedule. Then, under Destinations, select Override policy storage selection, and then select the snapshot SLP.

Step 5

In NetBackup, run a manual backup for the policy that you configured.

This operation is usually performed by the NetBackup administrator.

For information about manual backups, see the NetBackup for Oracle Administrator's Guide.

This process may take several hours. When the manual backup is completed, the newly ingested database source appears on the Database Sources dialog in Velocity. This database source can then be used to create sandboxes.

Step 6

In Velocity, verify that the database source was ingested.

This operation is usually performed by the Velocity administrator or database administrator.

From the Velocity Console, in the left pane, select Database Sources. On the row for the database source that was ingested with NetBackup, the Ingest button should be replaced with Veritas NetBackup to indicate that NetBackup was used to ingest that database source. The Ingest button will not be available for the database sources that were ingested with NetBackup. All additional ingests must be initiated in NetBackup.