RE: Monthly RMAN Long Term Backup

No they can’t.

If you look at Oracle EBS and many other COTS systems they simply maintain the last state of the row not the historical perspective like a Data Warehouse may maintain.

Keeping backups for long periods of time is standard industry practice. In the Insurance world the backups are kept up to 15 years.    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Steve Harville Sent: Tuesday, March 9, 2021 3:18 PM
To: gogala.mladen_at_gmail.com
Cc: oracle-l <oracle-l_at_freelists.org> Subject: 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 <mailto: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