Re: Oracle Backup for dummies?

Hi,

[Quoted] 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.

greetings,

Toni
[Quoted] 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. Thanks for any advice.
>
>
Received on Mon Nov 15 2004 - 16:36:56 CET