Re: Archiving ORACLE database

From: Someone <answers_at_erols.com.tyfns>
Date: 1997/10/03
Message-ID: <3435AC5F.BEBEE948@erols.com.tyfns>#1/1

This is a multi-part message in MIME format.

--------------20E7B61FA9BA6EA63AF89846
Content-Type: text/plain; charset=us-ascii
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Why not get an optical juke box and use CD-WORM? It is much more cost effective than tape and more compact and durable (longer life). I would not want to rely on a tape more than 3 years old. CD-WORM has extremely long life.

MarkP28665 wrote:

> <cai_at_chevron.com> >>
> This one might go to the "BIG IRON" folks who have archive data for
> 20 years
> or more. OK what types of suggestions do you have. Not just running
> an
> export or a cold backup but preserving data that may be used as input
> to a
> future database twenty years down the road should the data ever be
> needed. <<
>
> There is no need to get fancy to create a reliable archieve process.
> Just
> dump the data using sqlplus or write a Pro*C program to use as a
> skeleton for
> other archieve programs. As long as you store the data in a simple
> text
> (character format) file then you have all kinds of options for
> looking at it
> later. If you only need to see certain records you may be able to
> use nawk,
> sed, a plain c (or c++) program to report the data without having to
> re-insert
> it into Oracle. It is pretty easy to use sqlplus to create sqlldr
> files for
> re-inserting.
>
> Copy the text file to tape for long tern storage. Be sure to include
> a file
> layout on the tape either at the top of the archive file or as a
> separate
> file. If the tape drive does not support hardware compression you
> may want to
> store the uncompress utility on the tape also if you are not using
> the
> standard Unix compress program. I would also suggest createing a
> file to
> record the archive tapes if you do not have a tape management system
> ( and
> reliable backups of its catalog ).
>
> Also, always use a new or nearly new tape for archives. Older tapes
> can often
> be written sucessfully, but read back successfully.
> A good tape management system keeps track of how many times a tape is
> used.
>
>
>
> Write Pro*C or use sqlplus select * to dump the data to a text file.
> It is
> pretty easy to use sqlplus to extract the data into a form sqlldr can
> easily
> re-insert. As long as the output is simple text you have a full
> range of
> options on processing the data. Copy the text file to tape. Either
> include a
> filelayout at the top of the file or as the first file on the tape.
> Mark Powell -- The only advise that counts is the advise that you
> follow
> so follow your own advise

--------------20E7B61FA9BA6EA63AF89846
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Someone
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Someone
n:              ;Someone
email;internet: answers_at_erols.com.tyfns
title:          Important
note:           Remove tyfns from my email address to reply.  TYFNS stands for "Thank you for not spamming."

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard

--------------20E7B61FA9BA6EA63AF89846-- Received on Fri Oct 03 1997 - 00:00:00 CDT