brbackup -t offline sap database cannot be shutdown

Hi Infracom,

I believe  the SAP admin in your organization can help you more for that, you can ask him if you can do the following:

1- try running the backup with brbackup with adm

2- Changing backup mode to offline by setting "offline_force" .

3- Set the profile parameters pre_shut_cmd = "stopsap r3" and post_shut_cmd = "startsap r3". This would not work if ora cannot restart SAP instance.

4- try running the following script at OS level

stopsap r3

brtools command line

startsap r3

But please consult the SAP admin firstly before implementing those solutions as he is for sure more knowledgable than me for your environment and what is the best for it.

Thanks,

Ahmed Bahaa

With NMSAP module you can run offline backup and it will stop database for you (and start it once it is done).

Hi,  I have the same point.. 

for offline backup I agree the database is shutdown and restarted after backup completes.  But my customer wants to  have also SAP application to be sutdown before backup starts and restarted after backup completes .

This is to reset buffers and stats from SAP .  I suggested to run windows scheduler jobs just before NetWorker group starts to stop then start SAP but he does not want this.  He is Using Time Navigator today that runs a .cmd file on the client thats stops SAP, backup DB and the starts SAP.  but from NMSAP 4.2 admin guide page 13 we can read ..

Removed the following from the requirements for testing a scheduled backup because NMSAP 4.2 does not support pre- and post-processing scripts .. so do  not have lots of options here .. could someone confirm  ?

cheers

philippe

If you use NMSAP, you can use offline backup mode and that will do it automatically for you - no need for pre and post scripts.

Hi

Not for SAP instance just for Oracle DB.. if you use offline_force it will force to  disconnect connected user but SAP instance will  not be shutdown event if the DB it self will  be shutdown.   Backup will be successful but wat I need is : stop SAP instance ==> ofline backup ==> restart SAP instance . (SAP instance is SAP application)

Ah ok, I see, but if you wish to stop whole SAP instance then you are talking about something as pure file system backup and then instead of NMSAP you should use savepnpc where you call pre script which will do all necessary step form you, then backup sapdata, *log or whatever you want and then in post script start all together. Obviously, this way, you loose brtools intergration (but to be honest, with sap instance down I'm not sure if brtools would work anyway).