OS Backup of SAP data + DB parameters for Oracle

[Former Member]

Hello!

I have installed two SAP ECC 6.0 systems landscape with Oracle 10 on windows.

Now I would like to set up the backup strategy for the whole relevant data, including

Oracle and OS, such as \usr\sap\..

For the DB I implement Online backup weekly, and redo logs 3 times a day.

Now I would like define the backup strategy for the OS data, such as \usr\sap\... and have the following questions:

1) How often should I backup the SAP-Binaries-partition \usr\sap\...?

(daily, weekly, 1 times month)

2) Should the DB, SAP R/3 or some Services be stopped for this issue?

Do exist some file-locks avoiding offline backup of \usr\sap\... ?

3) What should be backuped from \usr\sap\...?

(trans, profiles)

And the last question regarding the setting for the two DB-parameters, because I get warnings from DB-check:

db_block_checksum

statistics_level

Thank you very much indeed!

regards

Thom

[Former Member · Accepted solution]

Hello Thom,

1. I have seen implementations with daily binary backups and others with weekly. It is really entirely up to you. As what is under /usr/sap is only a few GBusually, it doesn't make much difference. Note that these backups are done also do daily for the job log files, STAT file etc . You can get the binaries installed easily again from the SAP CDs if needed

2. DB can definetely stay up and so can SAP (I am sure for Unix). For Windows, I wouldn't expect that downtime is needed but I haven't work much with SAP on Windows so I will let somebody else confirm this or disagree!

3. Just backup everything under /usr/sap, this is the simpler and the safer option

For db_block_checksum, the recommendation for Oracle 10g is to be set to "TYPICAL" I think.

What warning are you getting for statistics_level? The value for that should be "TYPICAL" as well

Regards

Andreas

[markus_doehr2 · Accepted solution]

You can backup \usr\sap but you wonu00B4t be able to backup the operating system and the registry consistently on a running system.

The only way without using a 3rd party backup system is to install a second instance of windows in a different windows directory (not using c:\windows but something different) and backup the other partition from there. In worst case you will be able to do a disaster recovery without reinstalling the full operating system and the complete SAP system again.

--

Markus

[Former Member · Accepted solution]

hi Thom,

I guess u would have designed a backup stategy by now.

Regarding setting DB parametes please refer

<b>Note 830576 - Parameter recommendations for Oracle 10g</b>

Hope it helps u

Regards

Bharathwaj V

[former_member204746]

1) How often should I backup the SAP-Binaries-partition \usr\sap\...?

(daily, weekly, 1 times month)

<b>\usr\sap also houses logs and trans directory, I backup this filesystem once a day</b>

2) Should the DB, SAP R/3 or some Services be stopped for this issue?

<b>no need to shutdown anything</b>

3) What should be backuped from \usr\sap\...?

(trans, profiles)

<b>I usually backup everything, if you have a crash, your functional might still want to get access to their job logs.</b>