RE: Monthly RMAN Long Term Backup

At least in the US, for companies holding things like mortgages, as long as the mortgage is "active", ALL of the data (including things like images of original loan documents) has to be "available", and there are now 50 year mortgages.

Consider what "storage technologies" were available in 1972and "fast-forward" that to 2072 😊 - and what 'database' vendors from 1972 are still even companies today (Oracle was founded in 1977 - will they still be here in 2077)?

"Your backup is only as good as your last restore test"

Clay Jackson

-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of dimensional.dba_at_comcast.net Sent: Tuesday, March 9, 2021 2:22 PM
To: gogala.mladen_at_gmail.com; oracle-l_at_freelists.org 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.

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_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Tuesday, March 9, 2021 2:19 PM
To: oracle-l_at_freelists.org
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.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdbwhisperer.wordpress.com%2F&amp;data=04%7C01%7Cclay.jackson%40quest.com%7C7c2d8b32b65d4fa8995808d8e349dc96%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637509253654225806%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=1XEn%2BofcSLQi3s6pe2QHBoWpD2%2Bri%2BMtJmAQ80M0nnE%3D&amp;reserved=0

--
https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&amp;data=04%7C01%7Cclay.jackson%40quest.com%7C7c2d8b32b65d4fa8995808d8e349dc96%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637509253654225806%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=75DHhXjibeNf0A37%2B%2Bq9OqQCEXUZwOGgKhntTIZGqLY%3D&amp;reserved=0

--
https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&amp;data=04%7C01%7Cclay.jackson%40quest.com%7C7c2d8b32b65d4fa8995808d8e349dc96%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637509253654225806%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=75DHhXjibeNf0A37%2B%2Bq9OqQCEXUZwOGgKhntTIZGqLY%3D&amp;reserved=0

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Mar 09 2021 - 23:51:26 CET