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