Different Options in BRRESTORE
1. brrestore -b last -m all
Restore all tablespaces without the control file and online redo log files, starting from the last successful backup.
2. 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.
3. brrestore -m /usr/sap/C11/SYS/profile
Restore the SAP profiles.
4. brrestore -m /usr/sap/C11/SYS/exe/run:sapdba
Restore the SAPDBA executable.
5. 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 .
6. 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.
7. brrestore -m 0
Restore the control file. Restore the mirror copies of the control file.
8. brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5
Restore a database data file starting from the last successful backup.
9. brrestore -a 200-220
Restore the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory.
10. 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 .
11. 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 .
12. brrestore -n det_log
Restore a detail log to the local working directory.
# Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.
Thursday, April 23, 2009
Subscribe to:
Post Comments (Atom)
2 comments:
great!
Hi
Thanks for the great tip, I get the following error:
brrestore -a 61972-61973=/oracle/SP1/saptemp1/restore
BR0401I BRRESTORE 7.00 (46)
BR0405I Start of file restore: reemicjm.rsa 2010-11-04 07.02.06
BR0484I BRRESTORE log file: /oracle/SP1/sapbackup/reemicjm.rsa
BR0464W Line 255533 in /oracle/SP1/saparch/archSP1.log rejected for /oracle/SP1/ oraarch/SP1arch1_61972_714826095.dbf because of different backup device types
BR0464W Line 255538 in /oracle/SP1/saparch/archSP1.log rejected for /oracle/SP1/ oraarch/SP1arch1_61973_714826095.dbf because of different backup device types
BR0465E Wrong value of backup_dev_type for the first offline redo log file found
BR0439E No offline redo log files found in /oracle/SP1/saparch/archSP1.log for processing for device type TAPE/BACKINT/RMAN in recovery interval of 30 days
BR0406I End of file restore: reemicjm.rsa 2010-11-04 07.02.07
BR0280I BRRESTORE time stamp: 2010-11-04 07.02.07
BR0404I BRRESTORE terminated with errors
pkgdbs:orasp1 11% tail -200 /oracle/SP1/saparch/archSP1.log
Post a Comment