Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Long Term Backups and Retrieval strategies
The way I can handle this is because the legislative requirements do not
specify the exact form the backup has to take. IIRC in the part of the world
I live in it is specified as something like "data must be readily available
for inspection by auditors". That is not legal language, but it is what I
distilled from the conversations and discussions with specialists in that
field. This means that a backup can consist of an export. This contains a
definition of the data of course which means the data can be read back. A
plain ascii file might work as well if you have the create table statement
included.
Of course you will have to backup the software (oracle version) that was
used to make the export. Along with the knowledge to install and run it. The
latter might prove the most difficult part ;-). And don't forget to keep one
old dog of a tape unit that can read the tape. Or transfer data to a new
tape if you change tape units.
Kind regards,
Eric.
> -----Oorspronkelijk bericht-----
> Van: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] Namens Hemant K Chitale
> Verzonden: maandag 10 oktober 2005 17:35
> Aan: Oracle-L
> Onderwerp: Long Term Backups and Retrieval strategies
>
>
> With different legislative and customer requirements, we are
> troubled by the fact that we may have to make data backups
> available for 7 to 15 years {some requirements are as long as
> 15 years}.
> The usual restrictions about the same hardware and operating
> systems not being available 10 years later come to mind first.
>
> How have other organisations devised backup strategies for
> such requirements ?
> Are your business users and applications teams able to
> identify specific data sets {rows/tables/reports} that need
> to be backed-up or are you just told to "backup the whole database"
> for 15 years ? What backup media do you use ?
>
> Hemant
>
>
> Hemant K Chitale
> http://web.singnet.com.sg/~hkchital
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 10 2005 - 10:53:19 CDT