Sparse files, Disaster recovery, Restoring the control file – HP A.06.11 User Manual

Page 203: 203 disaster recovery

Advertising
background image

Otherwise, the output of some commands is not displayed correctly (for example,
backup objects returned by omnidb) and cannot be used as input for other commands
(for example omnir).

Sparse files

You can improve performance of a sparse file restore by setting the sparse option.
Set the option in any of the following ways:

Using the Data Protector GUI: Select the Restore sparse files option in the Options
page.

Using the Data Protector CLI: Add the -sparse option when running the omnir
command.

Using the SAP commands: Before running the BRRESTORE command, set the Data
Protector OB2SPARSE variable:

Windows:

set OB2SPARSE=sparse

UNIX:

export OB2SPARSE=sparse

Disaster recovery

For general information, see the HP Data Protector disaster recovery guide.

Restoring the control file

The control file contains all the information about the database structure. If the control
file is lost, restore the control file before you restore any other part of the database:

1.

Restore the control file using the standard Data Protector restore procedure.

The control files (ctrlORACLE_SID.dbf) are restored to the directory defined
by the SAPBACKUP variable. If the variable is not set, the control files are restored
to:

HP-UX, Solaris, and Linux:

/var/opt/omni/tmp

Other UNIX:

/usr/opt/omni/tmp

Windows:

Oracle_home\tmp

Integration guide for Oracle and SAP

203

Advertising