Show TOC

restore_modeLocate this document in the navigation structure

This parameter specifies the scope of restore activity for BRRESTORE.

restore_mode = all|all_data|full|incr|incr_only|incr_full|
incr_all|<tablespace>|<file_ID>|
<file_ID1>-<file_ID2>|<generic_path>|
(<object_list>)]|partial|non_db

Default: value: all

Possible values:

  • all

    Restores all tablespaces (without control files and redo log files)

  • all_data

    Restores all tablespaces that are not pure index tablespaces or empty

    This option value is deprecated - see SAP Note 1429581 Information published on SAP site.

  • full

    Restores a complete backup (that is, all backup files)

  • incr

    Restores an incremental backup with RMAN.

  • incr_only

    Restores changes to all files that were in the database since the time of the last full backup. See Restoring Incremental Backups with Structural Changes in RMAN-Relevant Profile Parameters.

  • incr_full

    Restores files that have been added to database since the last full backup. See Restoring Incremental Backups with Structural Changes in RMAN-Relevant Profile Parameters.

  • incr_all

    Restores an incremental backup with RMAN and also restore all redo log, control, and non-database files and directories, if any

  • <tablespace>

    All files of the specified tablespaces are processed by the appropriate SAP utility

  • <file_ID>

    Restores 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 restore all existing online redo log files. Temporary files are identified by negative numbers.

  • <file_ID1>-<file-ID2>

    Restores the files in this interval

  • <generic_path>

    By entering a full path, you can restore 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.

  • <object_list>

    Restores the specified list of objects. This list can also include the keyword all. However, we recommend processing database files and non-database files separately.

  • partial

    Restores all files from a partial backup without specifying them explicitly

  • non_db

    Restores all non-database files and directories from a backup without specifying them explicitly