what commands used for taking backup of oracle database using BR*Tools

[Former Member]

Can somebody please help me urgently to know what are the commands used for taking backup of oracle database using BR TOOLS.Also specifythe commands in detail which can be used for taking backups of oracle database ,Online Redo log files in databse using BRBACK tool,Archiving of offline, redo log files using BRARCHIVE, and Restoring a Database using BRRESTORE tool Commands(Plese specify the commands with their Syntax used).Also specify the commands with their Syntax which are used for taking backup of oracle database(online,Offline redo log files) into Tapedrives using BRTOOLS commands.

Thanking You for helping (in advance).

[madhukara_shenoy · Accepted solution]

Dear Ashish,

BRBACKUP / BRARCHIVE calls the operating system command to copy the files.

Simple approach to get the commands is as follows.

1. Set the BR_TRACE (as given in the SAP note 29321) and run the command for which you need to know the OS / SQL commands.

2. This will generate the log file with the trace information. This trace has the information of the commands used by the job you have run.

Hope this helps.

Regards,

Madhukar

[former_member204746]

step 1: adapt initSID.sap (check docs supplied by others)

to backup offline:

brbackup -u / -c -m all-t offline_force

to backup online:

brbackup -u / -c -m all-t online_cons

to backup redologs:

brarchive -u / -c -sd

to restore backup:

brrestore -u / -c -b bdvhcwjs.anf -m full

to restore redolog:

brrestore -u / -c -a bdvhcwje.cds

[Former Member]

Hi Ashish,

Please look into the below links where you will get a detail PDF docs.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/afc2af2f-0d01-0010-f0ad-dc0e92b3...

http://www.doag.org/pub/docs/sig/sap/2005/11/Maurer.pdf

Regards,

Chandra

[Former Member]

Dear Ashish,

This help can give detail of BR*TOOLS for Oracle

http://help.sap.com/erp2005_ehp_01/helpdata/en/0c/cd271365debc42bef96ac7fd907787/content.htm

Hope this can help you.

Regards,

Fendi Suyanto