-m|-mode (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

-m|-mode

This BRBACKUP command option defines the file to be backed up.

Default: all

You can perform a full database backup or back up specific tablespaces or files (whether part of the database or not). You can create object lists.

You can specify what you want to back up:

all : Back up the complete database

In a Structure Retaining Database Copy ( backup_dev_type = disk_copy or disk_standby ) you can retain the distribution of the sapdata directories to different drives (only for Windows NT).

Example

The files of the drive d are copied to drive k , the files of the drive e are copied to the drive l and the files of the drive f are copied to the drive m .

brbackup -d disk_copy -m all,d:=k:,e:=l:,f:=m:

If you do not specify a target drive, all files are copied to the directory defined in the parameter new_db_home.

all_data : Back up the files of all tablespaces, except for pure index tablespaces.

full : Full database backup at level 0. See Complete Backups.

incr: Incremental backup with RMAN. See full database backup (level 0) in Incremental Backup.

<tablespace> : Back up the files of one tablespace.

<file_ID> : Back up a data file with the specified ORACLE file ID as 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. To address all the online redo log files, use file ID 00.

<file_ID1>-<file_ID2> : Back up the files specified in the file ID interval. The specified file IDs must be known in the database.

<generic_path> : Enter a complete path to back up the required database file, non-database file, or directory. Specify a generic path to back up all the 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.

Note

When you specify a directory to be backed up its contents and the names of the subdirectories are backed up. However the directory structure and the content of the subdirectories are not backed up.

<object list> : You can specify a list of tablespaces or files, or combine the key word all with an object list. The individual objects are separated by commas (commas only, no blanks).

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> and /usr/sap/trans . If possible, these directories should be backed separately. You can only use this option when saving to tape without verifying 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 are saved in <ORACLE_HOME> (except for the sapdata<n> and saplog- or origlog/mirrlog directories). If possible, save these directories in a separate backup run. You can only use this option when saving to tape without verifying the backup.

Note

For UNIX systems: Start BRBACKUP to save the SAP/Oracle environment ( brbackup -m 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.

Parameters in init<DBSID>.sap : backup_mode.

If you want to repeatedly back up several tablespaces and/or files, it may be more effective to configure parameter backup_mode of the initialization profile accordingly.