Performing a SAP Oracle IntelliSnap Selective Online Full Backup Operation

You can use the selective copy of a full backup to make copies of the backup using an auxiliary copy operation. The selective copy advantages include:

The data and log backups use the same storage policy and reside on the same media.
The data and log backups use the same selective online full backup data aging rules. For more information on selective copies, see Secondary Copy (Selective Copy).

Selective online full backup jobs include complete and up-to-date data because of the following built-in job management features.

Currently running SAP for Oracle backup jobs must complete before the selective online full backup job begins.
During the data backup phase of a selective online full backup job, the only other Oracle data backup jobs that are allowed to run on the same instance are archive log backups. The log backup jobs are forced to use the selective online full backup storage policy.
During the log backup phase of a selective online full backup, no other Oracle data or log backup jobs can run on the same instance. New jobs started on the instance are queued in the Job Controller until the selective online full backup job is completed.
If a selective online full backup is restarted during a currently running selective online full backup, the current job restarts from the beginning of the phase. For example, if a selective online full backup job goes to the pending state during the data phase, when restarted, the job starts from the beginning of the data phase.

For information on special data aging rules for selective online full backups, see Data Aging - SAP for Oracle Agent.

Before You Begin

Create a Subclient for Selective Online Full Backups.

Procedure

Traditional

UTIL_FILE

Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.utl file and set the parameter value to 1.

Example
```
SAPOracle11gr2124@saporavm2>vi initCER.utl
 numstreams
 1
 SelectiveOnlineFull
 1
```
On the command line, type the following command to run the data backup.
```
brbackup -t online -d util_file -m all -c force -u /
```
On the command line, type the following command to run the log backup.
```
brarchive –d util_file–s –c force u /
```

RMAN_UTIL

Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.sap file and set the parameter value to 1.

Example
```
RMAN_PARMS="SBT_LIBRARY= /Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName= ,CvInstanceName= ,SelectiveOnlineFull=1)
```
On the command line, type the following command to run the data backup.
```
brbackup -t online -d rman_util -m full -c force -u /
```
On the command line, type the following command to run the log backup.
```
brbackup -t online -d rman_util -s -c force
```

IntelliSnap

UTIL_FILE

Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.utl file and set the parameter value to 1.

Example
```
SAPOracle11gr2124@saporavm2>vi initCER.utl
 numstreams
 1
 SelectiveOnlineFull
 1
```
On the command line, type the following command to run the data backup.
```
brbackup -t online -d util_file -m all -c force -u /
```
On the command line, type the following command to run the log backup.
```
brarchive –d util_file–s –c force u /
```

SAP Oracle IntelliSnapThird Party Command Line Backups

In addition to using the CommCell Console, you can also perform full and incremental backups from the Command Line Interface. However, ensure that the IntelliSnap check box is selected in the CommCell Console, both at the client level and the instance level. For step-by-step instructions, see IntelliSnap - Getting Started - Configuration.

For information on how to perform third part command line backups, see SAP on Oracle Backup Examples Using the BR*Tools Command Line Interface.