backup_mode (SAP Library - Database Administration (Oracle) with SAPDBA)

backup_mode

This parameter is used by BRBACKUP and BRRESTORE to determine the scope of the backup/restore activity.

Default: all

Possible values:

all : Back up the entire database using BRBACKUP or restore all tablespaces (without control files or redo log files) using BRRESTORE.

full : Restore a complete backup using BRRESTORE. See Incremental Backup

<tablespace name> : The files of the specified tablespaces will be processed by the appropriate SAP utility.

all_data : Save the files of all tablespaces which are not pure index tablespaces.

incr: Incremental backup with RMAN. See: Incremental Backup.

<file_ID> : The file with this file ID will be processed. For data files, this is the ORACLE file ID. Control files can be addressed with the file ID 0. Online redo log files can be addressed using the file ID 0<n>, <n> is the redo log group number. Specify file ID 00 to process all existing online redo log files.

<file_ID>-<file_ID2> : The files in this interval will be processed.

<generic_path> : By entering a full path, you can process database files, non-database files, or the specified directory. By entering a generic path, you can process database data files whose name starts with that path. In this case, the path must contain at least the ORACLE_HOME directory and an additional generic specification (for example, sapdata<n> ) in the path.
If the generic path is a directory you can also restore one or more files by the additional specification of one or more file names:
<directory_name>:<file_name1> :<file_name2>.. . ]

sap_dir : With this option, you can automatically determine and save all the files of the SAP environment. This means that the following directory trees are saved: /sapmnt/<SAPSID> , /usr/sap/<SAPSID> , /usr/sap/trans This option could, for example be used after an SAP upgrade. Saving with the sap_dir option should not replace regular backups of the file systems using operating system commands.

You can only use this option when saving to tape and when not carrying out a verification of the backup.

ora_dir : With this option, you can automatically determine and save all the non-database files of the ORACLE environment. This means that the directory trees under <ORACLE_HOME> (except for the directories sapdata<n> and saplog - or origlog/mirrlog ) are saved. You could, for example, use this option after an ORACLE migration. Saving with the option ora_dir should not replace regular backups of the file systems with operating system commands.

You can only use this option when saving to tape and when not carrying out a verification of the backup.

<object list> : You can enter an object list (see Parameter Format). This list can also include the key word all. However, SAP recommends processing database files and non-database files separately.

For UNIX systems: Start BRBACKUP to save the SAP/ORACLE environment ( backup_mode= sap_dir | ora_dir ) under user root , as otherwise you will not have the authorizations required for the directory to be saved.

Saving and restoring under root also has the advantage that you can be sure that the settings for the user and authorizations for the files and directories will be kept after restoring.