Examples of BRRESTORE Runs
brrestore -b last -m
all
Restore all tablespaces
without the control file and online redo log files from the last successful
backup.
brrestore -b
bcnmhluz.aft -m full
Restore all the files from
backup bcnmhluz.aft, including the control file and the online
redo log files. Restore the mirror
copies of the control file and the online redo log files.
brrestore -m
/usr/sap/C11/SYS/profile
Restore the SAP
profiles.
brrestore -m
/oracle/C11/sapdata1=/oracle/C11/sapdata5
Restore 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
Restore 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. Restore the mirror copies of the
control file and the online redo log files.
brrestore -m 0
Restore the control
file. Restore the mirror copies of
the control file.
brrestore -b last -m
/oracle/C11/sapdata2/ddicd_5/ddicd.data5
Restore a database data
file starting from the last successful backup.
brrestore -a 200-220
Restore 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
Restore 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
Restore 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
Restore a detail log to
the local working directory.