Re: Oracle Backup for dummies?

> In article <cn30bb$ffc$1_at_uni00nw.unity.ncsu.edu>, tpcolson
> <tpcolson_at_unity.ncsu.edu> wrote:
>
> > I've set up an Oracle 9i (9.0.2) database to serve as a spatial repository
> > for ArcSDE GIS data (www.esri.com). Now....I am by no means a db admin...or
> > a SQL programmer. This DB is for storage of GIS data related to a PhD
> > project...and in a university setting....users are their own IT shop. The
> > challenge is...I need to figure how to configure enterprise manager console
> > to do backup/recovery. SO far, I've configure the dataspace holding the
> > spatial data to be in "Archive Log Mode" and it runs fine...etc...I can even
> > do online or offline backups. The problem is...I've been testing to see if I
> > can do a recovery from the backups I've made...using the wizard in
> > enterprise manager console. The recovery never works, and the database never
> > starts up again, due to any number of what seems like a 100 errors. Now..one
> > would think, that if you click the "recover button", it would perform a
> > recovery, right? Is there anything I'm missing here? I really can't get into
> > all that SQL stuff for performing recoveries. I'm trying to set this up so
> > even the dumbest user (myself) can click a button or two and execute a
> > recovery after they delete two weeks of project data.

Anton Dischner <nomail_at_nospam.org> wrote in message news:<151120041636562025%nomail_at_nospam.org>...
> i am quite shure all you need is a logical backup of your data.
>
> Exp store a table/user in a datafile.
>
> Imp imports this data.
>
> Please read about the exp and imp utilities.
>
> rman, archive-mode etc is for enterprise level backup.

For backing up/exporting ArcSDE layers (spatially enabled tables) you shouldn't use Oracle's imp/exp tools. You should use the ESRI supplied tools: sdeimport/sdeexport. These tools makes sure that metadata & triggers are exported/imported.

If you have a lot of static (read-only) spatial data you might want to consider using sdeexport/sdeimport as a way to backup your data. You won't have to backup the static data every day (only once, really) so it should be pretty fast. No point and click though, you'll have to write a few shell-scripts. Received on Mon Nov 15 2004 - 20:43:16 CST