This BRRESTORE command option enables you to restore a file directly from a tape volume without having to specify the name of the backup log or the log sequence number. This option is normally reserved for disaster recovery.
-n|-number <file_pos>|init_ora|spfile|init_sap| space_log| det_log|sum_log|init_all|all_log| control_file[=<rest_dest>]
Default value: none.
Possible values:
<file_pos>: specifies the position of the file on the tape
init_ora|spfile: restores the profiles init<DBSID>.ora and spfile are restored. These files are in position 2.
init_sap: restores the initialization profile init<DBSID>.sap. This file is in position 3.
space_log: restores the main log space<DBSID>.log, the structure log struc<DBSID>.log, and the parameter change log param<DBSID>.log. These files are in the third-to-last position.
det_log: restores the detail BRBACKUP or BRARCHIVE log. This file is in the second-to-last position.
sum_log: restores the summary BRBACKUP/BRARCHIVE log. This file is in the last position.
init_all: restores init<DBSID>.ora, spfile, and init<DBSID>.sap in one run
all_log: restores reorg<DBSID>.log, struc<DBSID>.log, param<DBSID>.log, detail and summary BRARCHIVE or BRBACKUP logs in one run.
<rest_dest>: specifies the restore directory into which the requested files are restored. If no directory is specified, the files are restored to the current directory where BRRESTORE was started.
control_file: restores the control file saved after a backup of offline redo log files with RMAN