Profile Parameters and BRBACKUP Command Options (SAP Library - Database Administration (Oracle) with SAPDBA)

Profile Parameters and BRBACKUP Command Options

SAVESET Grouping and Preparation Run

To define the size of the savesets by the number of files they contain, make the following entry in the initialization file init<DBSID>.sap :

saveset_members = 1|2|3|4|tsp|all ( default: 1)

The corresponding command option is: brbackup -s | -savesets

You can start the preparation run for determining the optimum distribution of files across the savesets as follows:

brbackup –d rman_prep

SAPDBA menu: Backup database ® Backup function

RMAN Backup with the SAP Backup Library

For backups with the SAP backup library you need to make the following special entries in the initialization file init<DBSID>.sap or set the corresponding command options:

to local tape devices

backup_dev_type = tape|tape_auto|tape_box

tape_copy_cmd = rman

to remote tape devices

backup_dev_type = pipe|pipe_auto|pipe_box

tape_copy_cmd = rman

to remote disk (incremental)

backup_mode = incr

backup_dev_type = stage|stage_copy|stage_standby

remote_user = "<user name> [<password>]" (requirement for SAPFTP)

remote_host = <host name> (requirement for SAPFTP)

RMAN Backup with an External Backup Library

For backups with external backup libraries, you need to make the following entries in the initialization profile init<DBSID>.sap or the corresponding command options:

backup_dev_type = rman_util

You can set other parameters as well, which BRBACKUP sends directly to the Oracle RMAN (without the prefix rman_ ). These parameters affect how the savesets are formed and the parallel backup to different media.

rman_channels

Number of channels allocated to the parallel processes

rman_filesperset

controls the number of files in each saveset; default: 0 (one files in each saveset for normal backups; all files in one saveset for incremental backups)

rman_kbytes

rman_readrate

rman_maxopenfile

For more information on these parameters, see the Oracle8 Server – Release 8.0 Backup and Recovery Guide.

RMAN Backups Without Backup Library

For normal backups to disk with RMAN, you need to make the following entries in the initialization file init<DBSID>.sap or the corresponding command options:

backup_dev_type = disk

disk_copy_cmd = rman

The individual steps of the incremental backup strategy without backup library have the following command options:

Full backup (level 0) without RMAN:

brbackup –m full –d tape|pipe|util_file

tape_copy_cmd = cpio|dd

Incremental backup (level 1)to disk with RMAN:

brbackup –m incr –d disk

Backup of the incremental backup to tape without RMAN (two-phase backup):

brbackup –b last –m incr –d tape|pipe|util_file

Restoring Incremental Backups

To make the database consistent again, for example after a media error, you can use the following BRRESTORE command (RMAN adjusts the changes in the files that have been affected):

If necessary: Restoration of the control file and the online redo log files from the last incremental backup:

brrestore -b last –m 0[,00]

Restoration of a full backup (level 0):

brrestore -b <brb_log_name> –m all|<object list>|..

Restoration of the last incremental backup (level 1):

brrestore -b last –m incr

Import of the offline redo log files with the Oracle Server Manager.

Restoring Incremental Backups with Structural Changes

In an incremental backup with structural changes, the new files are backed up in full to a second saveset in subsequent incremental backups. The following savesets are created if the SAP backup library is used:

<coded timestamp>.INCR (changes to the 'old' files)

< coded timestamp >.FULL (newly added files)

The backup of the new files to a separate saveset allows a precise specification of which files are to be restored.

Restoration of changes to all files that were in the database at the time of the last full backup (level 0) (first saveset of the last incremental backup):

brrestore -b last -m incr_only

Restoration of the files that have been added since the last full (level 0) (second saveset of the last incremental backup):

brrestore -b last -m incr_full

Restoration of the whole incremental backup (both savesets, if they exist):

brrestore -b last -m incr

More information:

Oracle8 Server – Release 8.0 Backup and Recovery Guide