HP StoreServ Application Suite for Oracle Media manual Vcdbarestore

Recovery Manager for Oracle User’s Guide

COMMAND

vcdba_restore

SYNOPSIS

vcdba_restore -s <oracle_sid> -p <primary_host> [-t <timestamp>] [-T <tablespaces>-D <datafiles>] [-h hostname] [-m alt_mountpoint] [-c] [-v]

DESCRIPTION

Restores database files from a virtual copy backup image.

The vcdba_restore command restores databases, tablespaces, data files, and/or archive logs from a virtual copy backup image. The virtual copy must have a status of Y in order to be restored. The virtual copy’s backup status can be retrieved using the vcdba_display command.

The command can also be used to restore a virtual copy’s backup image to an alternate backup host. For NBU (user-managed) restoration, the command can also be used to restore an alternate location. Oracle RMAN always restores to the primary host.

If a virtual copy’s name is not specified, the vcdba_restore command restores from the most recent full back up.

Restore is not supported on Remote Copy Configuration.

Restore is not supported on Remote Copy configuration.

The following restrictions apply when restoring from a virtual copy’s backup image:

■When restoring the database control file (using the -coption) using Oracle RMAN, the database must be in STARTED mode (startup nomount). In addition, restoring the database control file along with an individual data file 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.

■Restoring controlfiles along with datafiles and/or tablespaces is not allowed.

6.30

Command