HP OpenView Storage B6960-96008 manual Restoring Using the SAP R/3 Commands

Integrating SAP R/3 and Data Protector

Restoring an SAP R/3 Database

UNIX:

omnir -sap computer.company.com:ABA.0 -session 2006/01/23-1 -tree /app/oracle/ABA/sapdata1/btabd_1/btabd_1.dat

The restore session can be monitored in the Data Protector Monitor window, where mount prompts for the required media are also displayed. Refer to the man pages for more information on the Data Protector omnir command.

TIP	If you have a sparse file, restore using the sparse option to perform a
	faster restore.

Use any of the following methods to set the sparse option:

•Execute the following command: export OB2SPARSE=sparse (UNIX systems) or set OB2SPARSE=sparse (Windows systems) if the restore is started using the SAP sapdba or brrestore commands.

•Set Restore Sparse Files in the Restore Options window if the restore is started using the Data Protector GUI.

•Set restore option -sparseif the restore is started using the Data Protector omnir command.

	Restoring Using the SAP R/3 Commands
The sapdba or	You can use sapdba or brrestore to restore the target database. Both
brrestore	commands use the Data Protector backint interface to restore files
Commands	backed up using Data Protector.
	Prior to restoring the target database, set the OB2APPNAME variable:
	export OB2APPNAME=<ORACLE_SID> (Unix systems)
	set OB2APPNAME=<ORACLE_SID> (Windows systems)
	If you have backups of two different Oracle Servers with the same
	ORACLE_SID but on different SAP R/3 Database Servers, set the
	OB2HOSTNAME variable before starting restore to the name of the SAP R/3
	Database Server from which you want to restore:
	export OB2HOSTNAME=<client_name> (UNIX systems) or set
	OB2HOSTNAME=<client_name> (Windows systems)

208 Chapter 2