Re: Database Retention Question

It may not be easy, or even possible, to do that in any sort of legible manner.

On Thu, Apr 27, 2017 at 1:54 PM, Thomas Roach <troach_at_gmail.com> wrote:

> Bingo. Then you're data isn't dependent on any piece of technology being
> available at that time.
>
> Sent from my iPhone
>
> On Apr 27, 2017, at 2:20 PM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:
>
> Depending on the RDBMS is very risky. Your quote says that the "data" must
> be available. Flatten the data and export it into an open standard format.
> Then, you don't have to worry about how to access the data, RDBMS support,
> etc.
>
>
> Seth
>
> On Thu, Apr 27, 2017 at 11:04 AM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> Interesting you should ask that. The best method, as others noted, is
>> probably just to copy the whole running database to a VM and back up the
>> VM. Start the VM annually to make sure it will still run. I have a small
>> Oracle 7.3.4 database on Windows NT that I burned to DVD a few years ago, I
>> still start it up occasionally just for nostalgia.
>>
>> On Thu, Apr 27, 2017 at 12:23 PM, Ruel, Chris <Chris.Ruel_at_lfg.com> wrote:
>>
>>> How about create VM with a copy of that database and an FRA with all 28
>>> backups available? You can shut it down, export it, zip it up, whatever
>>> you need to do.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _____________________________________________________________________
>>>
>>> Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
>>>
>>> cruel_at_lfg.com * Desk:317.759.2172 <(317)%20759-2172> * Cell 317.523.8482
>>> <(317)%20523-8482>
>>>
>>>
>>>
>>> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freeli
>>> sts.org] *On Behalf Of *Scott Canaan
>>> *Sent:* Thursday, April 27, 2017 1:16 PM
>>> *To:* oracle-l_at_freelists.org
>>> *Subject:* Database Retention Question
>>>
>>>
>>>
>>> We are trying to find a workable solution to a rather large problem.
>>> One system has an Oracle database in Red Hat 6 and Oracle 11.2.0.4. Last
>>> August, there was a legal request to freeze 28 different backups of this
>>> database. That was done by the systems team, via CommVault (using RMAN).
>>> By asking more questions, it has come to light that any and / or all of
>>> those backups need to be quickly accessible as Oracle databases until Aug.
>>> 31, 2023. When I mentioned to our legal department that there’s no way
>>> that I can guarantee that whatever version of Oracle we’ll be using in 5,
>>> 6, 7 years will be able to even open the database files, the response was
>>> “you have to guarantee that the data is available if required in a
>>> lawsuit. No excuses are accepted by the courts.”.
>>>
>>>
>>>
>>> We’ve toyed with a couple of possible options. One is to keep a Red Hat
>>> 6 / Oracle 11.2.0.4 environment running until Sept. 1, 2023, which the SAs
>>> hate (not to mention the Security Office). Another is to restore from
>>> backup and upgrade along with other database upgrades and take a new frozen
>>> backup, which we aren’t keen on doing 28 times.
>>>
>>>
>>>
>>> Does anyone have any other ideas on how to save these backups and
>>> guarantee that they are usable through Aug. 31, 2023? I’d appreciate any
>>> thoughts.
>>>
>>>
>>>
>>> Thank you,
>>>
>>>
>>>
>>> Scott Canaan ’88 (srcdco_at_rit.edu)
>>>
>>> (585) 475-7886 – work (585) 339-8659 – cell
>>>
>>> “Life is like a sewer, what you get out of it depends on what you put
>>> into it.” – Tom Lehrer
>>>
>>>
>>>
>>> Notice of Confidentiality: **This E-mail and any of its attachments may
>>> contain
>>> Lincoln National Corporation proprietary information, which is
>>> privileged, confidential,
>>> or subject to copyright belonging to the Lincoln National Corporation
>>> family of
>>> companies. This E-mail is intended solely for the use of the individual
>>> or entity to
>>> which it is addressed. If you are not the intended recipient of this
>>> E-mail, you are
>>> hereby notified that any dissemination, distribution, copying, or action
>>> taken in
>>> relation to the contents of and attachments to this E-mail is strictly
>>> prohibited
>>> and may be unlawful. If you have received this E-mail in error, please
>>> notify the
>>> sender immediately and permanently delete the original and any copy of
>>> this E-mail
>>> and any printout. Thank You.**
>>>
>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l