Specify the objects you want to restore with BRRESTORE:
all
: The files in all tablespaces, but not the control files and online redo log files.
all_data
: The files in all tablespaces which are not pure index tablespaces.
full
: A complete backup, including any non-database files, directories, control files, online redo log files (complete offline backup) and offline redo log files (consistent online backup). The corresponding mirror copies of the control files and online redo log files are restored.
<tablespace_name>
: The files of this tablespace.
<file_ID>
: Data file with the specified ORACLE file ID. Control files have the file ID 0. Online redo log files have 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>
: The files specified by the file ID interval.
<generic_path>
: Enter a complete path to restore the required database file, non-database file, or directory. Specify a generic path to restore all the 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 (e.g.
sapdata<n>
) in the path.
If the generic path is a directory, you can also restore one or more file(s) from this directory by additionally specifying one or more file names: <directory_name>:<file_name1>[:<file_name2>...
]
<rest_dir>
: The restore directory to which the requested files will be restored. If no directory is specified, the original directory from the backup log is selected. See also
new_db_home
<object list>
: You can specify a list of tablespaces or files, or combine the key words
all
and
full
with an object list. When possible, always restore database files and non-database files in separate runs. The individual objects are separated by commas (commas only, no blanks!).
archive_logs
: The offline redo log files of a consistent BRBACKUP online backup (
backup_type=online_cons
).
