RE: Monthly RMAN Long Term Backup

Some slight correction.

You can keep data in a data warehouse with much more than a 1 PB. Amazon crossed 1PB in 2011 for their DW.  

Yes I agree with you that disk are more expensive than tape. For many of the scenarios related to Regulatory compliance you must maintain the data in the original format it was stored in, so the backup copy of the database meets that requirement whereas a DW transformed data does not.  

For the financial example I was speaking the restore of the Finapps database included the restore of the app which the auditors are used to dealing with for searches and reporting on verification of data.  

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Tuesday, March 9, 2021 5:53 PM
To: Steve Harville <steve.harville_at_gmail.com> Cc: oracle-l <oracle-l_at_freelists.org> Subject: Re: Monthly RMAN Long Term Backup  

Hmmm, that may be a problem. The larger the database is, the bigger box it needs to operate. Backup is a price/performance decision: how much would it cost to lose the data and how much am I willing to spend to prevent that from happening. LTO-9 cartridges are much cheaper than disks. If there is a little probability that the data will be needed again anytime soon, I can just show the regulators a bunch of LTO-9 cartridges and I'm done. LTO-9 has approximately $1 per TB cost. Backup strategy is made according to the needs. If a large bank which has tens of millions of customers needs the old data to be available instantaneously, then the only answer at the current state of technology is a humongous data warehouse which would need many TB of memory and hundreds of processors to operate. Even that is currently limited to approximately 1PB There is no way that something like Amazon, Citibank or Mastercard can keep years of data online, in the database, even with the current state of technology. Maybe in 10 years, but not today. And yes. I am aware of data archive in the database. However, disks are still more expensive than the tape.

On 3/9/21 6:18 PM, Steve Harville wrote:

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

--

Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 10 2021 - 03:33:43 CET