significance of SAP offline DB backup

[Former Member]

Dear SAP Gurus,

Our SAP sites are running 24 x 7. We are regularly taking the online backup and the oracle offline redo log files backup.

We would like to know, is it required to take the full offline backup of DB? What SAP reccomends about offline backup in Production environment.

Regards,

[Former Member · Accepted solution]

Vijay,

check following link

[http://help.sap.com/saphelp_nwmobile71/helpdata/en/47/09e812cc995bebe10000000a1553f7/content.htm]

Hope this helps.

Manoj

[JPReyes]

Theres more info here,

http://help.sap.com/saphelp_nw70/helpdata/EN/40/f2b0ffefdc35419e7751ad8aa869a4/frameset.htm

Regards

Juan

[Former Member]

Offlie backup is asked to take because you have to just restore the system you can do it with the help of an offlien backup only.

Online backup ca only help you to restore if you have archive logs also.So if you miss a sequence of archive logs you shall not able to restore the system back.

When you have offline backup youhave the backup of the database in all comitted state.

So if you have offlien backup the risk reduces.

Thanks

Rishi Abrol

[Former Member]

I appreciate the answer by Rishi Abrol.

[Former Member]

Dear Rishi Abrol,

If i am sure, my oracle offline redo log files are absolutely file, so there is no need to take offline backup.?

We are taking the DB backup of online with redolog files.?

[Former Member]

It all depends on the backup startegy you are using.Online backup + archibe logs is fine but try to test on some Demosystem.

Please try to have some offline backup when you have Down time.

Thanks

Rishi abrol