|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | [gislist] backup strategy |
| Date: |
09/23/2003 03:40:00 PM |
| From: |
Brandon L. League |
|
|
I'm looking for advice on backup strategies. I would appreciate both general
advice and specific responses. I may follow up responses with more specific
information and questions.
I'm referring to the database backups, not filesystem backups. Also, I should
mention that I work with a team of Oracle DBA's that don't have experience
with the requirements of a GIS. They are looking for the standard procedure
for handling backups for databases that may end up being 95% more-or-less
"static" raster datasets.
We currently have about 70 gb in an Oracle Database. Currently, this is all
GIS data, and about 60 gb are raster datasets. Also, this data doesn't change
except when I load more data--it's not being edited. In the next few months,
this will grow to about 250 gb, most of that the raster datasets.
Our DBA's like to do full Oracle backups every day, because then it's easier
to restore from a full backup. That's problematic when the backups (to tape)
run for 7-10 hours and the database isn't very big yet, so we've agreed to do
backups-on-demand. I'll request a backup after I've loaded data or made some
changes.
That's fine for the next few months, but when we've got data in
production that requires daily backups, we'll need a more complex system of
partial and/or incremental backups. In the coming months, as we move projects
into the production database, the database will incude relatively small
non-GIS datasets that will be edited daily, and it's possible certain GIS
layers will require this as well.
We use Solaris, Oracle 9i, ArcSDE 8.2. I'm specifically wondering if it's
common to simply create an archive copy of the raster datasets with something
like the arcsde -o export utility.
Thanks,
Brandon L. League
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
