Importanat database command : BRTOOL and BRBACKUP

Tuesday, June 10, 20082comments

Querying tape Required :
brbackup -q
brarchive -q

Initialising tape:
brbackup -c -i force -v / SCRATCH

brarchive -c -i force -v / SCRATCH

Database Backup
brbackup -c -m all -t online -a -c -cds For Online Database

brbackup -c -m all -t online_cons -a -c -cds For Online consistent backup (Database + Archive Logs)

brbackup -c -m all -t offline -a -c -cds For Offline backup

Archive Log Backup
brarchive -c -cds Archive Log Backup with Copy ,delete & Save
brarchive -c -sd Archive Log backup with Save & Delete

Queryng Tape No. present inside Tape Drive
brbackup -i show
Restoring Offline Backup from Tape brrestore –c –m all –b <.aft file>

*.aft file for that particular backup will be at path : oracle\SID\sapbackup\<.aft>
Forcefully Ending the backup
1 Execute DB02 TCode
2 Go to Current Sizes
3 Read the Tablespace name whose backup status is 'ACTIVE'
4 Telnet of the Server / Take Dameware of server & goto command prompt
5 sqlplus /nolog
6 conn /as sysdba
7 Fire following command
alter tablespace end backup;
Share this article :

+ comments + 2 comments

February 20, 2012 at 12:05 AM

Yes both these commands are of great use and importance in database. Each of them is described in the above article with the parameters that are used with them. Thanks a lot explaining them in detail.
sap support pack upgrade

December 5, 2016 at 3:49 AM

SAP MM,SD, real Time Training in Chennai
We provides Best SAP MM,SD Training in Chennai wih real time project assistance by our leading Materail Management Consultant.
For Free Live Demo @ Call to 8122241286.

Post a Comment
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger