Setting Parameters for SAPDBA Database Backup
Use
This section tells you how to set parameters when you are
backing up 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 for the functions Normal backup, Initialize BRBACKUP tape, and Show BRBACKUP tape header information. 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 device with automatic tape changer. Messages telling you to change the tape are suppressed. |
tape_auto |
|
local tape juke box |
Backup to jukeboxes or autoloaders that can be addressed locally |
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 jukeboxes or autoloaders that 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 |
|
RMAN with external backup tool (backint) |
Backup with an external backup library and RMAN, using BACKINT For more information, see RMAN Backup with an External Backup Library. |
rman_util |
|
RMAN with local disk |
Backup to local disk with an external backup library and RMAN, but without BACKINT |
rman_disk |
|
RMAN with remote disk |
Backup to remote disk with an external backup library and RMAN, but without BACKINT |
rman_stage |
|
local disk |
Backup to a local disk |
disk |
|
local disk (create database copy) |
Backup with database copy to a local disk This option creates a copy of the database files, including the directory structure, for example when setting up a test system. See Structure-Retaining Database Copy. |
disk_copy |
|
local disk (create standby database) |
Backup with database copy to a local disk for a standby database |
disk_standby |
|
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 |
|
remote disk (create database copy) |
Backup with database copy to a remote disk |
stage_copy |
|
remote disk (create standby database) |
Backup with database copy to a remote disk for a standby database |
stage_standby |
Copies a disk backup to tape as part of a two-phase backup for function Normal backup. The default is No. Choose one of the disk backups displayed by SAPDBA.
Specifies the backup name for function Verify BRBACKUP tape.
Specifies the backup type for the functions Normal backup, Determine compression rates, and RMAN preparation run. Choose from the following options:
|
Option |
Meaning |
|
online (default) |
Backup with the database still online ARCHIVELOG mode must be on. |
|
offline |
Backup with the database offline |
|
online (consistent) |
Logically consistent online backup The offline redo log files generated during the backup are also copied to the same volume. |
|
offline (force) |
Offline backup after the database is forcibly shut down The system does not check whether SAP System users are active. |
|
offline (standby) |
Offline backup of standby database See Standby Database: BRBACKUP Backup of Database Files. |
|
online (split) |
Backup on backup host after mirrors are split The mirror disks are split and backed up without downtime for the production database. The production tablespaces to be backed up are only placed in BACKUP status during the actual split. See Split-Mirror Disk Backup. |
|
offline (split) |
Offline backup after mirrors are split The mirror disks are split and backed up with minimal downtime for the production database. The production database is only shut down for a short time for the actual split. See Split-Mirror Disk Backup. |
|
offline (stop) |
Offline backup, but without subsequent database restart |
Specifies the IDs of the tape volumes that you want to use for functions Normal backup and Initialize BRBACKUP tape. If you specify more than one volume name, separate the names using commas.
To disable tape management, enter scratch.
Checks the volume label for function Initialize BRBACKUP 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 make a new label for previously initialized volumes.
The expiration period is not checked when you choose No.
Makes partial backups complete for function Normal backup. Use this if you have performed partial backups recently and want to back up all remaining data in the database. SAPDBA prompts you for the number of days over which you want to complete the backup.
For more information, see -f|-fillup.
Your database consists of 12 tablespaces. You backed up 3 tablespaces each on Monday, Wednesday, and Friday. To back up the remaining 3 tablespaces on Saturday, set this parameter to 6.
Specifies the number of tapes for functions Initialize BRBACKUP tape and Show BRBACKUP tape header information.
Specifies the objects to be processed for functions Normal backup and Determine compression rates. Choose from the following options:
|
Option |
Meaning |
|
all (default) |
Whole database backup |
|
all_data |
Backup of all tablespaces except pure index tablespaces |
|
full |
Full database backup at level 0 |
|
incr |
Incremental database backup at level 1 |
|
sap_dir |
Backs up the SAP directories |
|
ora_dir |
Backs up the Oracle non-database directories |
|
<tablespace name> |
Backs up the specified tablespace |
|
<file ID> |
Backs up one or more files that are specified with an Oracle file ID or a range of file Ids |
|
<absolute file or directory name> |
Backs up a file or directory that is specified by the absolute name |
|
<combination> |
Backs up a combination of objects that you specify by separating the individual objects with commas |
For more information, see
m|-mode and Database Backup Types.Specifies the objects for function RMAN preparation run. For more information, see parameter Objects for Backup above.
Specifies the objects for function Verify BRBACKUP tape. For more information, see parameter Objects for Backup above.
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 database menu. Thereafter, you can change some parameters, but not all. Changes are only valid until you leave the Backup database menu.
To use a different initialization profile for BRBACKUP, specify the name of the profile you want to use and restart SAPDBA.
Tells you which tapes are required for the backup for function Normal backup. Choose from the following:
Backup starts with no query
BRBACKUP tells you which tapes to mount for the backup and checks whether you have actually mounted these tapes. There is no backup.
BRBACKUP 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.
Restarts a backup that has previously failed, but from the point of failure, for function Normal backup. That is, data that was already backed up before the failure is not backed up again after the restart. Choose one of the backups displayed. The default is the latest backup.
For more information, see -f|-fillup.
For more information, see Setting Special Options for SAPDBA Database Backup.
Specifies whether a standard backup occurs for function Normal backup.
A standard backup means that you have not specified any of the following parameters:
This means that you have specified one of the above parameters, in order to perform a non-standard backup.
Specifies the verification type for function Verify BRBACKUP tape. Choose from the following:
Only the readability of the tapes is checked, not the contents. SAPDBA calls BRRESTORE for this. It reads the files but does not restore them.
For more information, see -w|-verify.
The backup is restored to the directory compress_dir. The block structure is checked with the Oracle tool DBVERIFY using brrestore -w use_dbv.
For more information, see -w|-verify, Backup Verify and Verify of RMAN Backups.