Software Suite for Oracle Instruction Manual

2.4
Interacting with Oracle
Recovery Manager for Oracle User’s Guide
2.3 Interacting with Oracle
3PAR Recovery Manager interacts with Oracle database through the SQL Plus utility to perform
the following:
■ Retrieve database structure information in order to create virtual copy for the database.
■ Interact with the Oracle database (put tablespaces (or the whole database) in and out of
backup mode, switch logfiles) as necessary to create a consistent virtual copy.
In order to create a consistent virtual copy of an Oracle database, the database structure must
satisfy the following requirements:
■ The database must be running in archive log mode and automatic archiving must be
enabled in order to create an online virtual copy, datafile only virtual copy, or archive log
only virtual copy.
■ Datafiles and archive logs must reside on separate 3PAR virtual volumes.
■ The online redo logs and control files should not reside on the virtual volumes used by the
datafiles and archive logs to avoid being rolled back along with datafiles and archive logs
virtual volumes. However, the online redo logs and control files can share the same 3PAR
virtual volumes.
■ If the database files reside on Veritas VxVM volumes, datafiles and archive logs must reside
on separate VxVM disk groups. The online redo logs and control files should reside on
separate VxVM volumes used by the datafiles and archive logs.
■ If the Oracle database is an ASM managed database, the datafiles and archive logs must
reside on separate ASM disk groups. The online redo logs and control files should not
reside on the same ASM disk groups used by the datafiles and archive logs to avoid being
restored when using the Recovery Manager Rollback feature.
■ ASM disk groups should not be shared between different databases.
■ If the database is an RAC database, all RAC instances must share the same archive log
destinations (same cluster file systems or same ASM disk groups).