Setting Parameters for SAPDBA Backup of Offline Redo Logs
Use
This section tells you how to set parameters when you are
backing up the offline redo logs of the Oracle database with SAPDBA.Procedure
Set the required parameters for the chosen function (the parameters are listed in alphabetical order):
Sets the device type used. Choose from the following options:
|
Option |
Meaning |
Corresponds to backup_dev_type setting |
|
local tape (default) |
Backup to local tape device |
tape |
|
local tape auto changer |
Backup to tape when using a local device with automatic tape changer. Messages telling you to change the tape are suppressed. |
tape_auto |
|
local tape juke box |
Backup to local jukeboxes or autoloaders, in which tapes that can be addressed directly |
tape_box |
|
remote tape |
Backup to tape device in a remote system, using the command specified in the initialization profile |
pipe |
|
remote tape auto changer |
Backup to device with automatic tape changer using a remote system Messages telling you to change the tape are suppressed. |
pipe_auto |
|
remote tape juke box |
Backup to remote jukeboxes or autoloaders, in which tapes can be addressed remotely |
pipe_box |
|
external backup tool (backint) |
Backup using an external backup program addressed by BACKINT interface program |
util_file |
|
external backup tool (backint) online |
File-by-file online backup using an external backup program addressed by BACKINT |
util_file_online |
|
external backup tool with rman (backint) |
Backup with an external backup library and RMAN, using BACKINT to save control file, profiles, and log files For more information, see RMAN Backup with an External Backup Library. |
rman_util |
|
external backup tool with rman (local disk) |
Backup with an external backup library and RMAN, where control file, profiles, and log files are saved |
rman_disk |
|
external backup tool with rman (remote disk) |
Backup to remote disk with an external backup library and RMAN, where control file, profiles, and log files are saved |
rman_stage |
|
local disk |
Backup to a local disk |
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. |
stage |
Specifies the IDs of the tape volumes for the backup. If you specify more than one volume name, separate the names using commas.
To disable tape management, enter scratch.
Copies a disk backup to tape as part of a two-phase backup. The default is No.
Checks the volume label for function Initialize BRARCHIVE tape. Choose from the following:
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.
The label of the volume is not checked. You can use this to initialize new non-SAP volumes or create a new label for previously initialized volumes.
The expiration period is not checked when you choose No.
Specifies whether the offline redo log files are permanently archived, either individually or in groups. Choose from the following:
An offline redo log file is archived individually as soon as it is created. This process is not stopped until the volume is full or the number of redo log files specified by number of redo logs has been backed up.
Number of offline redo log files that you want to archive together as a group; BRARCHIVE stops archiving until this number of offline redo log files is reached.
This option is useful if you are using BACKINT with an external backup program.
For more information, see Grouping Offline Redo Log Files and -f|-fill.
Enter the number of offline redo log files that you want to process. The default is 10000.
If set to 2, BRARCHIVE processes the two oldest offline redo log files in the archiving directory that have not yet been backed up to tape.
If set to 10000, BRARCHIVE normally processes all offline redo log files in the archiving directory.
Specifies the number of tapes for functions Initialize BRARCHIVE tape and Show BRARCHIVE tape header information.
Specifies the parameter file for the backup. The default is init<DBSID>.sap. The values specified in the parameter file are used when you first choose the Backup Offline Redo Logs menu. Thereafter, you can change some parameters, but not all. Changes are only valid until you leave the menu.
To use a different initialization profile for BRARCHIVE, specify the name of the profile you want to use.
Tells you which tapes are required. Choose from the following:
Backup starts with no query
SAPDBA tells you which tapes to mount for the backup and checks whether you have actually mounted these tapes. There is no backup.
SAPDBA tells you which tapes to mount for the backup but does not check whether you have actually mounted these tapes. There is no backup.
For more information, see -q|-query.
For more information, see Setting Special Options for SAPDBA Backup of Offline Redo Logs.
Specifies whether a standard backup occurs.
A standard backup means that you have not specified Backup from disk backup.
This means that you have specified Backup from disk backup.