HP P6000 Replication Solutions Manager Administrator Guide (T3680-96069, June 2012)

A Using the replication manager with Oracle tools
Starting with HP Replication Solutions Manager 5.1, Oracle integration is not supported. Customers
with an Oracle application integration license wanting to upgrade to HP Replication Solutions
Manager 5.1 must migrate their Oracle jobs using the replication manager. For instructions, see
“Migrating Oracle jobs” (page 62).
This appendix contains procedures for using HP Replication Solutions Manager with Oracle
products, including sample SQL scripts. It also provides detailed descriptions of the Oracle database
architecture and the replication manager to help you develop customized scripts that maximize
the features of the replication manager for use with your Oracle database.
IMPORTANT: This appendix describes methods supported with Oracle version 10g and HP
Replication Solutions Manager 5.0 or earlier. HP Replication Solutions Manager 5.1 or later does
not support Oracle integration. See the HP P6000 Enterprise Virtual Array Compatibility Reference
for details on host agent support.
Many of the commands and functions described in this appendix require database administrator
(DBA) privileges and can be disruptive to database operations if used incorrectly. For information
on using these commands and functions, see your Oracle documentation.
Migrating Oracle jobs
If you are using HP Replication Solutions Manager 5.0 or earlier with an Oracle Application
Integration license, you must migrate your existing Oracle integration jobs before upgrading to
HP Replication Solutions Manager 5.1 or later. You can migrate your jobs after upgrading to HP
Replication Solutions Manager 5.1, but if you do, the Oracle integration jobs will not work. This
sections provides examples of the tasks required to migrate and Oracle job.
Before upgrading to HP Replication Solutions Manager 5.1 or later
The following example migrates Replicate Oracle tablespace(s) template job from HP
Replication Solutions Manager 5.0 or earlier to HP Replication Solutions Manager 5.1 using the
Replicate host volume(s) template. In this example:
• A job was created using the Replicate Oracle tablespace(s) job template.
• A user configuration will take a snapshot of tablespace SYSTEM of database
ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM.
• Oracle is running on a machine with an IP address of 15.146.153.141.
• The Oracle repository name is Catalog 20091106.030426.
// Replicate Oracle tablespace(s).
//
// Assign some variables that will be used in this job.
$source_database_unc = SetVariable ( "\\15.146.153.141\ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM" )
//
// Create a repository of the desired components.
$repository = CreateOracleRepository ( $source_database_unc ) onerror pauseat E1:
// Add the desired tablespaces.
AddOracleTablespacesToRepository ( "\\ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM \Catalog
20091106.030426", ("\\15.146.153.141\ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM \SYSTEM") )
onerror pauseat E2:
//
// Put the database in 'hot backup' mode.
SetOracleModeUsingRepository ( $repository, TSBACKUP ) onerror pauseat E2:
//
DO {
// Replicate the items in the repository.
SnapshotOracleUsingRepository ( $repository, FULLY_ALLOCATED, SAME, ORACLE_TABLESPACE,
NOWAIT ) onerror pauseat E2:
//
} ALWAYS {
// Put the database back into normal mode.
SetOracleModeUsingRepository ( $repository, TSONLINE )
}
//
62 Using the replication manager with Oracle tools