HP 3PAR Application Software Suite for Oracle User Manual

Page 9

Advertising
background image

To ensure that the database is running in automatic archive log mode, use SQL*Plus utility to ensure
the Database log mode is Archive Mode and that Automatic archival is Enabled, as
in the following example:

$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Nov 14 13:59:13 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0 - Production

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /rac9i_db/rac9i_arch2

Oldest online log sequence 764

Next log sequence to archive 764

Current log sequence 765

Oracle standby databases are supported. An Oracle standby database is a synchronized copy
of the production database. The following are required for standby database support:

Only Oracle 10g and 11g are supported.

A standby database must be a physical database. Logical or snapshot standby databases
are not supported.

If using RMAN backup, the primary database (not standby) must be registered with Oracle
Recovery Catalog.

A snapshot of a standby database can be used to promote standby database volumes, but
cannot be used to promote primary database volumes (even though a backup of the snapshot
can be used to restore the primary database).

Oracle parameter and control files are not compatible between the standby and primary
databases. They cannot be used to restore the primary database unless Oracle RMAN (11g)
is used. The Oracle parameter and control files of the primary database must be backed up
manually outside of Recovery Manager for Oracle.

Interacting with Symantec NetBackup, HP Data Protector and Oracle RMAN

HP 3PAR Recovery Manager for Oracle integrates HP 3PAR Virtual Copy with Symantec NetBackup
(NBU) or HP Data Protector and Oracle RMAN to dramatically reduce the performance impact on
the database server, as well as to minimize database down time during backup. Instead of a
traditional backup where the database is backed up directly on the production server, Recovery
Manager for Oracle creates a Virtual Copy (snapshot) of the database, imports it to a secondary
host (backup server), and then performs the backup of the Virtual Copy on the backup server.

Recovery Manager for Oracle provides four ways to perform backup and restoration: Symantec
NetBackup (NBU), Oracle RMAN (to local disk), Oracle RMAN With Symantec NetBackup, and
Oracle RMAN with HP Data Protector.

NOTE:

For an ASM managed database, Oracle RMAN with or without Symantec NetBackup

or HP Data Protector are supported backup methods.

NOTE:

Recovery Manager for Oracle supports only Symantec NetBackup master server on UNIX

(or linux) platforms. Recovery Manager for Oracle does not support the master server on Windows
platforms.

Interacting with Symantec NetBackup, HP Data Protector and Oracle RMAN

9

Advertising
This manual is related to the following products: