brrestore commands

Different BRRESTORE Commands (log in as ora<SID>) 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

Upload: bdesarkar

Post on 27-Apr-2015

1.218 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

DESCRIPTION

Brrestore Commands

TRANSCRIPT

Different BRRESTORE Commands (log in as ora<SID>)

1. brrestore -b last -m allRestore all tablespaces without the control file and online redo log files, starting from the last successful backup.

2. brrestore -b bcnmhluz.aft -m fullRestore 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/profileRestore the SAP profiles.

4. brrestore -m /usr/sap/C11/SYS/exe/run:sapdbaRestore the SAPDBA executable.

5. brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5Restore 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,0Restore 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 0Restore the control file. Restore the mirror copies of the control file.

8. brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5Restore a database data file starting from the last successful backup.

9. brrestore -a 200-220Restore 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/sapreorgRestore 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/sapbackupRestore 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 .For Example to restore a the log file PRCarch1_72816_662779038.dbfUse : brrestore -a 72816 -p initPRC.sap (where initPRC.sap=/oracle/PRC/sapbackup

http://basisfaqs.blogspot.com/2009/04/different-brrestore-commands.html