Show TOC

Examples of BRRESTORE RunsLocate this document in the navigation structure

Use
  • brrestore -b last -m all

    Restore all tablespaces without the control file and online redo log files from the last successful backup

  • brrestore -b last -m all -f last

    Restores all the database data files that have been not restored in the previous BRRESTORE run (for example, if aborted)

  • brrestore -b behmhluz.aft -m full

    Restores all the files from backup behmhluz.aft, including the control file and the online redo log files

    Restores the mirror copies of the control file and the online redo log files

  • brrestore -m /usr/sap/C11/SYS/profile

    Restores the SAP profiles

  • brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5

    Restores all the database data files that were originally stored in the subdirectories of /oracle/C11/sapdata1 in directory /oracle/C11/sapdata5

  • brrestore -b last -m 1-10,01-04,0

    Restores all the database data files with Oracle file IDs from 1 through 10, the four online redo log files, and the control file starting from the last successful backup

    Restores the mirror copies of the control file and the online redo log files

  • brrestore -m 0

    Restores the control file. Restore the mirror copies of the control file

  • brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5

    Restores a database data file starting from the last successful backup

  • brrestore -a 200-220

    Restores the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory

  • brrestore -a 40-70=/oracle/C11/sapbackup 71-90=/oracle/C11/sapreorg

    Restores the archived redo log files with the log sequence numbers from 40 through 70 in directory sapbackup and those with the log sequence numbers from 71 through 90 in directory /oracle/C11/sapreorg

  • brrestore -a 40-69,70-100=/oracle/C11/sapbackup

    Restores the archived redo log files with the log sequence numbers from 40 through 69 in the archiving directory, and those with the log sequence numbers from 70 through 100 in directory sapbackup

  • brrestore -n det_log

    Restores a detail log to the local working directory