There are also financial requirements.
I had a financial client that for regulatory bank requirements, we backed up a
copy after book lose each month, kept the backups for 7yrs and had to prove
yearly to CFO that we could restore one of the 12 monthly backups.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Mladen Gogala
Sent: Tuesday, March 9, 2021 2:19 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Monthly RMAN Long Term Backup
Steve, sometimes there are legal obligations to preserve data for several years
(HIPAA, SOX). The company needs to be able to prove to the regulators that they
can restore data from 7 years back.
Regards
On 3/8/21 7:21 PM, Steve Harville wrote:
"to be run monthly to get a full backup of the database and keep that
backup for a year"
This is a bad policy. A backup is supposed to allow recovery to a
point in time with zero data loss. These monthly backups will never be
used like backups are meant to be used. They could be dangerous to
your database if someone restores them without knowing what they are
doing. If there is a justified reason to store snapshots you should
just do an export and keep that however long is needed.
