Show TOC

Syntax documentationrestore_mode Locate this document in the navigation structure

This parameter specifies the scope of restore activity for BRRESTORE.

Syntax Syntax

  1. restore_mode = all|all_data|full|incr|incr_only|incr_full|
  2. incr_all|<tablespace>|<file_ID>|
  3. <file_ID1>-<file_ID2>|(<object_list>]|partial|non_db
End of the code.

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

  • 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 at the time of the last full backup. See Restoring Incremental Backups with Structural Changes in Profile Parameters and BRBACKUP Command Options.

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

    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

  • <object_list>

    Restores the specified objects. You can enter an object list, as described in Initialization Profile init<DBSID>.sap. 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