Of course, the flip side of this (which I had the opportunity to observe 1st
hand) is that if you happen to retain data (think email) LONGER than legally
required, it becomes "discoverable" in legal action, and the judge isn't going
to care how difficult it is to read that ½" tape backup from the mainframe that
was "junked" 10 years ago.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Steve Harville
Sent: Tuesday, March 9, 2021 3:18 PM
To: gogala.mladen@xxxxxxxxx
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Monthly RMAN Long Term Backup
CAUTION: This email originated from outside of the organization. Do not follow
guidance, click links, or open attachments unless you recognize the sender and
know the content is safe.
Yes but they can just retain this data in the database.
On Tue, Mar 9, 2021 at 5:19 PM Mladen Gogala
<gogala.mladen@xxxxxxxxx<mailto:gogala.mladen@xxxxxxxxx>> wrote:
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.