BR*Tools Example: Performing a SAP on Oracle Archive Log Backup

Perform an archive log backup by using the BRARCHIVE command.

You can use archive log backups to recover database transactions that have been lost due to an operating system or disk failure. Apply the archive logs to an online backup to recover a database.

By default, full backups include both data and archive logs, but you can also perform separate archive log backups.

Best Practice: Schedule an Oracle archive log backup every 20 minutes on busy databases.

For information on the BRBACKUP command options, go to the SAP Help website, Command Options for BRARCHIVE.

Before You Begin

Add the CvInstanceName and CvClientName parameters to one of the following files:

For UNIX configurations, the init<SID>.utl file is under the $ORACLE_HOME/dbs directory.

For Windows configurations, the init<SID>.utl file is under the $ORACLE_HOME\database directory.
On Windows configurations, run the BRBACKUP command with the –r option.
If you use the util_file (BACKINT) interface, modify the init<SID>.utl file. For details on the parameters, see Supported SAP for Oracle Util File Parameters.
Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

UTIL_FILE

On the command line, type one of the following commands.

Backup Logs, Save and then Delete the Logs
```
brarchive -d util_file -sd
    
```
Archive Offline Redo Logs
```
brarchive -d util_file -s
    
```
Create a Secondary Copy of the Archived Offline Redo logs
```
brarchive -d util_file -sc
    
```
Delete the Archive Offline Redo After the Archive
```
brarchive -d util_file -sd
    
```
Create a Second Copy of the Archived Offline Redo Log Files and then Delete the Files
```
brarchive -d util_file -scd
    
```
Delete Archived Offline Redo Logs
```
brarchive -d util_file -ds
    
```
Create a Second Copy of the Archived Offline Redo Logs and then Archive the New Offline Redo Logs
```
brarchive -d util_file -cs
    
```
Create a Second Copy of the Archived Offline Redo Logs, Delete and then Archive the New Offline Redo Logs
```
brarchive -d util_file -cds
    
```
Delete Offline Redo Logs that Have Been Copied Twice
```
brarchive -d util_file -dc
    
```

RMAN_UTIL

On the command line, type the following command:
```
brarchive -d rman_util -s
    
```