SAP on Oracle RAC Configuration

You can back up SAP on Oracle RAC databases from the CommCell Console or BR*Tools interface.

The in-place restore operations for SAP on Oracle RAC databases support only full database instance restore. You must use command line method BRRECOVER to perform database copy to different DB_SID name.

In an Oracle RAC configuration, one instance, typically the instance that has thread number 1 in the SAP installation, is the dedicated database instance (DDB instance). You perform all database administration tasks, for example backups and tablespace extensions, from the DDB instance. For more information, see Oracle Real Application Cluster on the SAP Help Portal.

For information about BRBACKUP and RAC, go to the SAP help website, RAC with BRBACKUP.

Before You Begin

Verify that the operating system of the computer that has SAP on Oracle RAC database is Unix.
Configure the password file so that the user can stop and start all instances from the DDB instance. From an SQL session, type the following:
```
 
orapwd file=ORACLE_HOME/dbs/orapw 
 password=sys_password entries=10
    
```
Add the following entry to the Oracle profile.

Note: Restart all instances after you add this entry.
```
remote_login_passwordfile = exclusive
    
```
Grant the SYSDBA and SYSOPER permissions to the DDB SYSTEM user. From an SQL session, type the following:
```
SQL> grant sysdba to system; 
SQL> grant sysoper to system;
    
```
Modify the SYSTEM user password. From an SQL session, type the following:
```
SQL> alter user system identified by <password>;
    
```
Install the SAP for Oracle agent on the DDB.
Install the BR*Tools on the DDB.
Create a common spfile on the DDB. The file must reside in the following directory:

UNIX
```
<ORACLE_HOME>/dbs
    
```
Windows
```
<ORACLE_HOME>\database
    
```
Connect the backup devices to the DDB host.

Procedure

On the DDB host, create the init<SID>.sap file and set the parallel_instances and db_services parameters. The BRBACKUP utility uses these parameters to access all the Oracle instances.

For information on the parallel_instances parameter, go to the SAP Help website, parallel_instances.

For information on the db_services parameter, go to the SAP Help website, db_services.
Create an Instance for the DDB.
Create subclients.

What to Do Next

You can perform backups from the CommCell Console, or BR*Tools interface.