Data Security for Oracle E-Business Suite

[debrah.h48]

Recently we had a bad experience of losing live data. So with the help of Solix we started creating non-production clones of Oracle E-Business Suite for testing, development, and even training. It really helped us a lot in E-Business Suite Archiving.

[Fletcher]

Loosing Data is not new to the internet world, time and again we have new utilities and software that claim to restore the data. This hears something more reliable.

What i feel is taking regular backups will always help us all

[DavidJ]

Backups are a good way to make sure that lost live data could still be recovered.

Speaking of backups, how often should you make one? Backups eat up a lot of resources so regular backup will cost you more.

[g33k2b]

In what ways do you mean that backups eat up a lot of resources? Is it that they use up a good amount of space that will cost you as it cannot be used or are there other expenses as well?

[DavidJ]

Originally Posted by g33k2b

Is it that they use up a good amount of space that will cost you as it cannot be used

This is what I was aiming at. Do you overwrite old backups so that you can reuse the space?

So back to my question, how often do we need to make backup? Is once a month a good interval?

[g33k2b]

I do not have any experience with Oracle however most sites backup at least daily. I know there are many sites which have instant backups so that the site could be restored to most any point. Maybe someone with more experience could step in here and offer us some advice. I do think people simply overwrite old backups though.

[Thomas]

The backup policy I use for my sites:

1) If it is a static site, I just take the backup of the latest site and delete the old ones.

2) If it is a dynamic site which uses MySQL Database, then I take backups once a week and usually I keep 3 backups of the site so I can revert the site backup to the date I want, depending upon the data.

The three backups I keep for my sites are in the following manner, I take the backup and overwrite the oldest backup, Ie: when I take the 4th backup I overwrite the 1st backup, which helps me to save and re-use the diskspace on my account.

Originally Posted by DavidJ

So back to my question, how often do we need to make backup? Is once a month a good interval?

Hi DavidJ,

Usually it is advised to keep the latest backup, but many of a times it is not possible to take huge backups so I would recommend you to take backups as I take them or atleast twice a month considering your site is a dynamic, So in case if you lose your data, you wont have to restore a backup which is a month older.

Rest it depends upon your requirements.

[NCHosting]

I agree with Thomas

With my situation as I provide specialised hosting for many clients, I build the backup details into the Standard Form of Agreement for clients but modify depending on their requirements.

For a few sites with sensitive/mission critical data I backup as often as once an hour, sites with less needs, once a day possibly. It all depends on what my clients need.

Providing a blanket backup solution works for some, but not all.