SAPDBA: Backup Database (SAP Library - Database Administration (Oracle) with SAPDBA)

SAPDBA: Backup Database

a

- Backup function

Normal backup

b

- Parameter file

initC11.sap

c

- Backup device type

tape

d

- Objects for backup

all

e

- Backup type

offline

f

- Backup volume(s)

g

- Query only

no

h

- Special options

i

- Standard backup

yes

j

- Backup from disk backup

k

- Restart backup

l

- Make partial backup complete

s

- Start BRBACKUP

q

- Return

Choose the settings you want from the sub-menu. Use Return to leave the sub-menu in order to set any other parameters necessary for your chosen operation and to start the operation.

Backup function

Normal backup: The volume (tape) is not initialized (default). You can start the backup.

Initialize BRBACKUP tape: Use this option to initialize a volume .

Check label before initialization no
The label of the volume is not checked. You can initialize new non-SAP volumes or make a new label for previously initialized volumes.
The expiration period is not checked.

Check label before initialization yes
The label of the volume is checked. You can only re-initialize SAP volumes that have expired. (This option is often used to rename volumes.)

Number of tapes 1
Specify the number of volumes that you want to initialize.

Show BRBACKUP tape header information: The information in the volume label is displayed.

Determine compression rates: The compression rates of all data files specified with Objects for backup are determined. Note that you need to allow a certain amount of time for this procedure. SAP recommends that you use this option about once a month, if you want to perform backups on tape devices with hardware compression. This is so that the current compression rate of the files can be determined (see compress).

RMAN preparation run: Preparation run for a backup using RMAN (see Saveset Grouping and Tape Layout).

Verify BRBACKUP tape: Check backup to tape. Use the menu option Select verification type to determine the extent of the check.

Reading tape(s): Only the readability of the tapes is checked, and not the contents (with BRRESTORE -w|-verify). The files are only read, not restored.

Restore to stage and DB VERIFY: The backup is restored to the directory compress_dir; the block structure is checked with the Oracle tool DB_VERIFY ( brrestore -w use_dbv ).

See Backup Verifications and Verification of RMAN Backups.

Parameter file: Default: init<DBSID>.sap
To use a different initialization profile for BRBACKUP, specify the name of the profile you want to use.

Backup device type:

- local tape: Backup to a local tape device (default: corresponds to backup_dev_type = tape ).

- local tape auto changer: Backup to tape when using a device with automatic tape changer; any messages telling you to change the tape are suppressed. (corresponds to backup_dev_type = tape_auto)

- local tape juke box: Backup to jukeboxes or autoloaders that can be addressed locally (corresponds to backup_dev_type = tape_box ).

- remote tape: Backup to a tape device in a remote system, using the command specified in the initialization profile (corresponds to backup_dev_type = pipe ).

- remote tape auto changer: Backup to a device with automatic tape changer using a remote system; any messages telling you to change the tape are suppressed. (corresponds to backup_dev_type = pipe_auto)

- remote tape juke box: Backup to jukeboxes or autoloaders that can be addressed remotely (corresponds to backup_dev_type = pipe_box ).

- external backup tool (backint): Backup using a backup program addressed by the interface program BACKINT (corresponds to backup_dev_type = util_file ), see Using External Backup Programs.

If you want to perform the backup using an external backup program, then you may have to specify the necessary parameters in a parameter file. Enter this file name under Backup utility parameter file.

- external backup tool (backint) online: File-by-file backup using a backup program addressed by the interface program BACKINT; in an online backup, the BACKUP status is set and completed dynamically for the tablespaces being backed up. This significantly reduces the volume of offline redo log files during an online backup (corresponds to backup_dev_type = util_file_online ).

- external backup tool (backint) with recovery manager:
( corresponds to backup_dev_type = rman_util)
See Backups with External Backup Libraries).

- local disk: Backup to a locally installed or mounted disk (corresponds to backup_dev_type = disk ).

- remote disk: Backup to a remote disk; this option is recommended if no disk is installed locally, since the transfer protocol is secure (ftp or rcp), and no verification is required, unlike an NSF mount (corresponds to backup_dev_type = stage ).

- database copy to disk: Use this option to make a copy of the database files, including the directory structure, for example when setting up a test system (corresponds to backup_dev_type = disk_copy ).
See Structure-Retaining Database Copy

Objects for backup: The following entries are possible (See m|-mode):

all: Backs up the whole database (default).

sap_dir/ ora_dir: Backs up the SAP directories and the Oracle non-database directories.

tablespace name: Backs up the specified tablespace.

File ID or File ID1 - File ID2: Backs up one or more files, which are specified using an Oracle File ID or a File ID area.

Generic path: You can specify an arbitrary file by using its full path name or several data files by specifying a generic path.

Object list: You can specify a combination of objects by separating the individual objects with commas.

Backup type:

online: (ARCHIVELOG mode must be activated). The backup is made with the database still running.

offline: If the R/3 System is shut down, the database is also shut down for the backup. Otherwise, the database is not shut down and BRBACKUP terminates with an error message (default).

online consistent: As well as the database files, the offline redo log files generated during this online backup are also copied to the same volume. This makes the data logically consistent.

offline (force): The database is shut down and an offline backup is made. The system does not check whether R/3 System users are active.

offline (standby): The standby database is shut down during the backup.
See Standby Database: Backup with BRBACKUP

online (split): The mirror disks are split and backed up while the database is running. The tablespaces to be backed up are only placed in BACKUP status during the split.
See Mirror Disk Backup

offline (split): The split mirror disks are backed up. The database is only shut down for a short time for the mirror disks split.
See Mirror Disk Backup and the parameter backup_dev_type

Backup volume(s): The IDs of the volumes (tapes), which you want to use for the backup. If you specify more than one volume name, then you must separate the names using commas.

Query only: (See -q|-query)

- no: Backup is started (default).

- with tape check: No backup; you are told which tapes you have to mount for the backup, and a check is made on whether you have actually mounted these tapes.

- without tape check: No backup; you are told which tapes you have to mount for the backup.

Special options: Choose this menu option to go to a sub-menu where you can choose other special functions for backing up the database.
See Backup Database: Special Options

Standard backup: Default: yes
The display tells you whether you are making a normal backup, or whether you are using a special BRBACKUP function. If you are making a two-phase backup (backup from disk backup) the display switches to no.

Backup from disk backup: Choose this option if you want to back up a disk backup to tape ( two-phase backup). The display Standard backup is set to no automatically.

Restart backup: Use this function to complete a cancelled backup. Choose one of the backups on offer. The default is the latest backup.
See: -f|-fillup

Make partial backups complete: Use this function to complete partial backups. Specify the number of previous days for which you want to complete partial backups (default: 0).
See -f|-fillup.

a	- Backup function	Normal backup
b	- Parameter file	initC11.sap
c	- Backup device type	tape
d	- Objects for backup	all
e	- Backup type	offline
f	- Backup volume(s)
g	- Query only	no
h	- Special options
i	- Standard backup	yes
j	- Backup from disk backup
k	- Restart backup
l	- Make partial backup complete
s	- Start BRBACKUP
q	- Return