Hello Jay
How about building an historical DB and keeping the data there.
It will not overload the production instance, will be available online if
you need something, you will migrate it to new versions of Oracle so
compatibility will not be an issue and you can implement table changes on
the
Another poor man's solution would be to unload the tables into flat files and attach
to them as needed using Oracle's external table feature from 9i. That solution
should hold for quite a while into the future since the external table function is
very
much like SQL*Loader, which is so
Jay,
Remind the management that in the future there might also ba a change
of hardware and then the backups on tape could possible be useless and
unreadable by the new tape drives. If possible save the data to a text
delimited file and save the file. That wouls insure you that you would
always be
Ron,
Under ideal conditions, that is, controlled temperature, humidity
and atmosphere, a CD has a lifespan of 30-200 years.
In typical conditions, 5-50 years.
CD's stored in a computer room might only last 10 years. In
someone's desk, maybe only 5 years.
On the visor of your car, probably
Burnt mud? Isn't that all scotch?
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Steve McClure [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 4:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Purging Strategy
Sherry
Title: RE: Data Purging Strategy
And finding something to play that CD in 50 years, much less understand the data format, will be like finding something to play an old 78 now.
78. How's that for showing my age! I even had a 16 once. And a 4-track (pre 8-track).
Jerry Whittle
ACIFICS DBA
Hair of the dog! I wonder if that would help my sorry butt.
Might have to leave for the airport early and sit at the bar until the stupor
clears. Hope I don't miss my plane.
D
[EMAIL PROTECTED] wrote:
Burnt mud? Isn't that all scotch?
--
Please see the official ORACLE-L FAQ:
I went to one meeting where someone from another DOE lab said they needed to store
some data on media which would last 10,000 years. I suggested chisels and stone
tablets :)
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November
: RE: Data Purging Strategy
Sherry Finish? I thought you liked scotch that tasted like burnt mud?
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L
That reminds me:
Mark, your annual stipend is due
water constantly dripping on stone, will wear away the stone. And an
earthquake, with debris falling on that stone could shatter it.
I don't think even that will work
--- MacGregor, Ian A. [EMAIL PROTECTED] wrote:
I went to one meeting where someone from another DOE lab said they
needed to
Ian - I have seen some of that in the general media. One problem is that if
the information is extremely miniaturized so a lot of information can be
stored in a small area, then some who discovers one of your artifacts may
not realize something is written on it. The first clay tablets with
-Original Message-
I went to one meeting where someone from another DOE lab said
they needed to store some data on media which would last
10,000 years. I suggested chisels and stone tablets :)
That gold platter that NASA sent out into space: How long is it supposed to
last?
Stephen Lee wrote:
-Original Message-
I went to one meeting where someone from another DOE lab said
they needed to store some data on media which would last
10,000 years. I suggested chisels and stone tablets :)
That gold platter that NASA sent out into space: How long is it
Hi Tim
We just signed a contract for external storage system from EMC and the
configuration is going to be:
Regular servers - connect as Nas
Database servers - connect as San.
If I remember correctly Nas use SCSI connections while San use fiber.
Yechiel Adar
Mehish
- Original Message -
by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd
party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list
, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith
FWIW, what we just implemented (because senior management refuses to approve
additional storage on the grounds that making the database larger will
affect performance - aaargh!) is
1) Confirmed with business how long data needs to be online for various
tables (they're all partitioned so that
Jay,
just make sure you are not around when, after several Oracle upgrades, and
they want to import one of these files back that they discover that the
current release of import can no longer read the older version of the .dmp
file.
now what are these senior damagers going to do? blame the DBA,
Thomas, Jay
Here is my thought for your consideration, evisceration. A fundamental
principle of backup and recovery is that you can only consider a backup to
be good if you've tested a recovery. Why not apply this principle to data
archiving? In other words, when you upgrade to a new Oracle
Well, if worst comes to worst we can always install an earlier version on a
box and import it there.
But the reason we can't get more storage approved still has me shaking my
head...
-Original Message-
Sent: Thursday, November 07, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Prem,
I
would re-visit the requirement. Why do you feel the need to delete the
data from the database? What is the purpose for this type of
requirement? It would be far easier to modify the requirement than to do
what you are thinking of doing.
Adding
columns to database tables
This is adata-archival requirement, not a
data-purge requirement. It only resembles a purge requirement based on the
multiple-database-migration strategy you outlined. There are
alternatives...
Depending on the volume of data in your database
and your availability requirements,
the data back because of software
compatibility issues.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Data Purging Strategy
here's some
gotchas involved but some variation on that theme might
work.
Jim
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Data Purging Strategy
Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
- If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
- PrincetonSoftech has a product
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L
Prem - You are receiving some excellent advice
Hey, thanks for mentioning that, I'll have to mind my manners. I really
don't have a connection to that vendor, just attended a demo.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 06, 2002 9:56 AM
To: Multiple recipients of
Someone asked about this 3 weeks ago. Here's my take
on archiving data. I don't expect everyone to agree with this,
but nonetheless, I have an opinion. :)
Here's an email from last month. You can undoubtedly find
some other ideas on this by searching the archives of this
list at fatcity.com
LOL! Thanks John! ;)
As a matter of fact.. ;P
I do actually know of another tool that does just this, it's called
Checkmate from a company called BitByBit http://www.bitbybit.co.uk (which I
have just checked and it now seems they have been acquired by OuterBay!)..
We actually used to promote
]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd
party
products.
I am sure he bought the franchise from Jared :)
John
, Sherry finish. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only
, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 06, 2002 7:18
AM
Subject: RE: Data Purging Strategy
Tim,
my
problem with moving data to tape is as follows:
Your
one strategy involved moving read-only tablespaces to tape. what if you
and
hoping you can use it later.
Jared
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/06/2002 03:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Data Purging Strategy
Agreed
In response to a post on data purging Tim Gorman wrote some on SAN-based
disk, some on NAS-based storage.
Can someone please explain the differences between these technologies
please.
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Purging Strategy
Hey Dennis,
Mark Leith is the only person on this list allowed
to mention 3rd party
products.
I am sure he bought the franchise from Jared :)
John
-Original
38 matches
Mail list logo