Show TOC

-n|-numberLocate this document in the navigation structure

Use

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