HP 3PAR Application Software Suite for Oracle - Manual (Page 22)

The Database Restoration Utility
The database restoration utility of HP 3PAR Recovery Manager Software for Oracle restores
databases, tablespaces, datafiles, or archive logs from a backup image of a Virtual Copy. The
Virtual Copy must be previously backed up using the rmora_backup command. The Virtual Copy
must have a backup status of Y in order to be restored. The backup status of a Virtual Copy can
be retrieved using the Recovery Manager display utility (see
“The Virtual Copy Display Utility”
(page 12) ).
For an NetBackup (user-managed) restoration, the database restoration utility can be used to restore
a backup image of a Virtual Copy to the backup server, and it can also be used to restore to an
alternate server on an alternate mount point. For an Oracle RMAN restoration, the backup image
is always restored to the database server.
The following restrictions apply when restoring from a backup image of a Virtual Copy:
•
When restoring the database control file (using the -c option) using Oracle RMAN, the
database must be in STARTED mode (startup nomount). In addition, restoring the database
control file along with the individual datafile or tablespace is not supported as it is not possible
to perform media recovery.
•
When restoring a database, the database must be in CLOSED or MOUNTED mode for NBU
restore or Oracle RMAN restore, respectively. For an RAC database, all RAC instances must
be in CLOSED or MOUNTED mode, respectively.
•
When restoring individual tablespaces or datafiles, the database can be OPEN, but the
corresponding tablespaces must be offline.
•
If the database is an ASM managed database, all ASM disk groups must be mounted prior
to running the restore utility.
•
For an NBU (user-managed) restoration, the
/usr/openv/netbackup/db/altnames/<database_hostname|virtual
_hostname> file must be created on the NBU master server prior to running the restore utility,
where <database_hostname|virtual_hostname> is the host name of the database
server.
Depending on the type (online, offline, datafile, or archive log) of backup image of the Virtual
Copy, corresponding database files are restored appropriately.
For an NBU (user-managed) restoration:
•
Control files are not restored by default.
•
For an online Virtual Copy, both datafiles and archive logs are restored unless individual
tablespaces or datafiles are being specified. In this case, only the corresponding datafiles are
restored.
•
Only datafiles are restored for an offline or datafile Virtual Copy.
•
Only archive logs are restored for an archive log Virtual Copy.
For an Oracle RMAN restoration:
•
Control files are not restored by default.
•
For an online Virtual Copy, only datafiles are restored. Archive logs are not restored to minimize
restore time as Oracle RMAN can restore only necessary archive logs during recovery.
•
Only datafiles are restored for an offline or datafile Virtual Copy.
•
Restoring from an archive log Virtual Copy backup image is not supported as Oracle RMAN
can restore necessary archive logs during recovery.
22 Overview of Recovery Manager Operations