Importanat database command : BRTOOL and BRBACKUP

Tuesday, June 10, 200812comments

Querying tape Required :
brbackup -q
brarchive -q

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

brarchive -c -i force -v / SCRATCH

Backup:
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 + 12 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.
www.thecreatingexperts.com
SAP MM
SAP SD

June 29, 2017 at 6:45 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact +91-08122241286

July 2, 2017 at 10:43 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 12, 2017 at 12:04 AM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info

July 14, 2017 at 6:04 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Contact 8122241286

July 21, 2017 at 2:01 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

July 22, 2017 at 2:04 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 24, 2017 at 2:31 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 27, 2017 at 7:27 AM

SAP basis training by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

July 30, 2017 at 2:05 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

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