Offline Backup in DB13? or UNIX?

[Former Member]

Hi Everyone,

I will be running BRBACKUP offline the first time. I wish to get opinions from experts that have perform this before.

1. If I run this in DB13, is there any potential problem? BR*Tools is 6.40(42) on R/3 46C.

2. If I run this in DB13, will SAP be started automatically, be it failure or success? This is a single SAP system, does RECONNECT work automatically? Or I have to do some settings?

3. Is this BRBACKUP command good enough? My database is in NOARCHIVELOG mode

>> brbackup -u / -c force -t offline_force -m all -p initPRD.sap.tsm -v T

4. Where can I find more information on RECONNECT?

My preference is performing it thru DB13, however I am not too sure how good this method is.

[Former Member · Accepted solution]

Hi Anne,

1. If I run this in DB13, is there any potential problem? BR*Tools is 6.40(42) on R/3 46C.

DB13 drives brbackup at the kernel level, there is no problem running your backups using DB13. SAP has provided you the interface to manage the backups.

2. If I run this in DB13, will SAP be started automatically, be it failure or success? This is a single SAP system, does RECONNECT work automatically? Or I have to do some settings?

If you are running offline backups from DB13, then the database will shutdown, you will be disconnected from SAPGui after the backup starts running and the SAP work processes will be in reconnect status, waiting for database to be open.

It will work automatically, once the backup is complete, the SAP will come up.

3. Is this BRBACKUP command good enough? My database is in NOARCHIVELOG mode

>> brbackup -u / -c force -t offline_force -m all -p initPRD.sap.tsm -v T

The command is:

brbackup -u / -c force -t offline_force -m all -p init<SID>.sap

Where init<SID>.sap is your SAP profile used to drive the brbackup.

4. Where can I find more information on RECONNECT?

You can monitor your backup logs in the backup directory:

/oracle/<SID>/sapbackup

and the work process status in SAP Work directory:

/usr/sap/<SID>/DVEBMGSNN/work

Once the application comes up, you can look at SM21 to check the status that the work processes were when the backup was running.

Hope this helps,

Regards,

Nisch

[Former Member · Accepted solution]

Thanks Nisch for the valuable reply.

[Former Member]

Hi Annie,

SAP recommends to use BR tools to backup the R/3 DB.

Please check the compatibility matrix for BR tools with 46C in service portal.

Please check the below link for further study on using BR tools for backup.

http://help.sap.com/saphelp_46c/helpdata/en/0d/d3053f4a0c11d182b80000e829fbfe/frameset.htm

It is SAP recommended and best practice to use BR tools for backup.

regards,

Vinodh.