Show TOC

Syntax documentationbackup_mode Locate this document in the navigation structure

This parameter is used by BRBACKUP to determine the scope of the backup activity.

Syntax Syntax

  1. backup_mode = all|all_data|full|incr|<tablespace>|
  2. <file_ID>|<file_ID1>-<file_ID2>|<generic_path>|
  3. sap_dir|ora_dir|all_dir|<object_list>
End of the code.

Default value: all

Possible values:

  • all: performs whole database backup using BRBACKUP

  • all_data: saves the files of all tablespaces that are not pure index tablespaces or empty

  • full: full database backup (level 0). See Incremental Backup.

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

  • <tablespace>: BRBACKUP backs up the file of the specified tablespaces.

  • <file_ID>: backups up the file with this file ID. 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 back up all existing online redo log files. Temporary files are identified by negative numbers.

  • <file_ID1>-<file_ID2>: backs up the files in this interval

  • <generic_path>: by entering a full path, you can save database files, non-database files, or the specified directory. By entering a generic path, you can save database data files whose name starts with that path. In this case, the path must contain at least the SAPDATA_HOME directory and an additional generic specification (for example, sapdata<n>) in the path.

  • 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 tools.

    Note Note

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

    End of the note.
  • 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 tools.

    Note Note

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

    End of the note.
  • all_dir: combines sap_dir and ora_dir. It means the same as -m sap_dir,ora_dir.

  • <object list>: specifies an object list, as described in Initialization Profile init<DBSID>.sap. This list can also include the key word all. However, we recommend processing database files and non-database files separately.

    Note Note

    For UNIX systems: Start BRBACKUP to save the SAP or 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.

    End of the note.

    Note Note

    The root user must have the environment of the corresponding ora<sid> user for BRBACKUP to start successfully

    End of the note.