Re: Monthly RMAN Long Term Backup

Yes but they can just retain this data in the database.

On Tue, Mar 9, 2021 at 5:19 PM Mladen Gogala <gogala.mladen_at_gmail.com> 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.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l