Integrating SAP R/3 and Data Protector

Examples of SAP R/3 Database Restore

SAPSID refers to the name of the SAP R/3 system, while the DBSID refers to the name of the database instance. When a single instance is installed, SAPSID and DBSID are the same.

•ORACLE_HOME: home directory of the Oracle software is by default <Oracle_home>\<DBSID> (Windows systems) or /opt/oracle/<DBSID> (UNIX systems).

•SAPDATA_HOME: home directory of the database files is by default <Oracle_home>\<DBSID> (Windows systems) or

/opt/oracle/<DBSID> (UNIX systems).

IMPORTANTThe environment variables ORACLE_SID, ORACLE_HOME and SAPDATA_HOME must always be set.

The following environment variables must only be set if the corresponding paths are different from the default locations:

•SAPARCH: directory for the BRARCHIVE logs is by default <SAPDATA_HOME>/saparch (UNIX systems) or <SAPDATA_HOME>\saparch (Windows systems).

•SAPBACKUP: directory for the BRBACKUP logs is by default <SAPDATA_HOME>/sapbackup (UNIX systems) or <SAPDATA_HOME>\sapbackup (Windows systems).

•SAPCHECK: directory for the sapdba -check/analyze logs is by default <SAPDATA_HOME>/sapcheck (UNIX systems) or <SAPDATA_HOME>\sapcheck (Windows systems).

•SAPREORG: directory for all other SAPDBA logs, as well as shell and SQL scripts is by default <SAPDATA_HOME>/sappreorg (UNIX systems) or <SAPDATA_HOME>\sappreorg (Windows systems).

It is also the standard directory for export and unload dump files, if the parameter exireo_dumpdir in the profile init<DBSID>.dba is not set.

•SAPTRACE: directory for Oracle trace files and the alert file is <SAPDATA_HOME>/saptrace (UNIX systems) or <SAPDATA_HOME>\saptrace (Windows systems).

•SAPDATA1: directory of the database data files is by default <SAPDATA_HOME>/sapdata1 (UNIX systems) or <SAPDATA_HOME>\sapdata1 (Windows systems).

240

Chapter 2