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.

"tpcolson" <tpcolson@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.
>


If you really expect to be able to manage an Oracle installation you better be prepared to learn 'all that SQL stuff'
This is not a point and click system and never will be...

Recovery is a very broad term and requires lots of parameters to determine what to recover, from where, and how ( to mention
just a few things)

There is no quick and dirty way to learn DBA procedures for Oracle..Read, test and read some more..( Even , gasp, take a
class)..

"tpcolson" <tpcolson@unity.ncsu.edu> wrote in message news:<cn30bb$ffc$1@uni00nw.unity.ncsu.edu>...
> 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.

Use MySQL. It's cheap, easy and can be run by the dumbest of users.
And, recovery is a snap since all you need do is restore a directory
tree.

So much easier than Oracle. Probably because it does so much less
than Oracle.

You reap what you sow, and, from the tenor of your post, you haven't
sown much, nor are planning to. Which makes MySQL the perfect product
for you.

David Fitzjarrell

tpcolson 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.

Hmmmm ... a 9.0.2 database ... would you please verify that number (I susect
it's a 9.2.0.x as Oracle went from 9.0.1 to 9.2.0 and 9.0.2 is a
designation for Application Server, not database)

There are a umber of things you could do, but there are an awful lot of
decisions that need to get resolved first. You might find a scan of the
Oracle Backup and Recovery Concepts manual useful - for 9.2 it's at

http://www.oracle.com/pls/db92/db92....emark=homepage ... and in PDF
http://download-west.oracle.com/docs...920/a96519.pdf

You don't seem to need up-to-the-minute recovery, so basically I'd almost
suggest that this is throw-away and you could get away with a cold backup
(shutdown database, copy all related files, restart). That can be handled
by a relatively simple script. Just remember to shutdown first (or you
have a 99.9999..% chance of unsync'd and therefore probably corrupt files)
and copy ALL related files.. Do that periodically (daily) and recovery is
to that point in time simply by copying the files back.

Since this is but one of several variations, I strongly suggest you spend
some time reading the manual to decide what is right.

By the way - I've dropped the comp.database.oracle.tools (cdo.tools) and
cdo.marketplace as the question is totally off-topic for those newsgroups.
Since the same group of people reads all the newsgroups, I suggest your
replies and further interaction be kept to cdo.server ... for more, see
http://orafaq.com (I, for one, don;t like seeing the same question over
and over.)

/Hans

"tpcolson" <tpcolson@unity.ncsu.edu> wrote in message news:<cn30bb$ffc$1@uni00nw.unity.ncsu.edu>...
> 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.

<old_timer>
forget all about that java stuff and fire up a command prompt.
</old_timer>

seriously, if you are windows-inclined, cmd.exe, sqlplus.exe, rman.exe
are all you need (although cygwin wouldn't hurt and the occassional
lsnrctl.exe, orapwd.exe, oradim.exe, imp.exe, exp.exe and sqlldr.exe).

if you're running on Linux, bash, sqlplus, and rman are all you need
for backup/restore/recovery.
I can think of no reason to be running the OEM GUI.

start here: http://otn.oracle.com/pls/db92/db92.homepage
(as I believe that you meant Oracle 9i R2 9.2)

hth.

-bdbafh

> "tpcolson" <tpcolson@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).
> > ....

fitzjarrell@cox.net (David Fitzjarrell) wrote:
> Use MySQL. It's cheap, easy and can be run by the dumbest of users.
> And, recovery is a snap since all you need do is restore a directory
> tree.
> ....

Sounds like a good idea except that ArcSDE doesn't run on MySQL.

nospam1978@yahoo.com (Tom Barnes) wrote in message news:<5af28966.0411130951.1206cfac@posting.google. com>...
> > "tpcolson" <tpcolson@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).
> > > ....
>
> fitzjarrell@cox.net (David Fitzjarrell) wrote:
> > Use MySQL. It's cheap, easy and can be run by the dumbest of users.
> > And, recovery is a snap since all you need do is restore a directory
> > tree.
> > ....
>
> Sounds like a good idea except that ArcSDE doesn't run on MySQL.

From the original text the OP is working toward a Ph.D., which should
indicate he/she has learned to perform proper research, and should be
able to learn the tools the course of study necessitates. It is also
apparent this poster has no such intention, nor inclination, to do so,
while taking on the air of disgust toward his Oracle database. Oracle
is not a toy, nor should it be treated as such. Hence, the suggestion
to use MySQL.

The OP cannot be bothered to post any of the " what seems like a 100
errors." Yet, he/she presumes participants in this newsgroup have
sufficient clairvoyance to divine the nature of these errors and
supply adequate and relevant advice. Also, the OP is sufficiently
disgusted with the inability of Oracle to opserate at the push of a
button. Oracle, simply, does not operate in that manner, it never
has, and it likely never will. All of the above add up to laziness, a
trait not accepted well by those of us who have worked very hard to
understand and use Oracle, and who take the time to assist others in
their understanding of the product.

Therefore, I shouldn't care if ArcSDE works with MySQL or not; the OP
cannot be bothered to actually LEARN Oracle, yet expects to use it
without effort on his/her part. If a Ph.D. candidate cannot learn the
tools required to earn his/her advanced degree, possibly their efforts
should be directed elsewhere.

My two cents.

David Fitzjarrell

fitzjarrell@cox.net (David Fitzjarrell) wrote in message news:<9711ade0.0411141356.31b93d0@posting.google.c om>...
> nospam1978@yahoo.com (Tom Barnes) wrote in message news:<5af28966.0411130951.1206cfac@posting.google. com>...
> > > "tpcolson" <tpcolson@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).
> > > > ....
> >
> > fitzjarrell@cox.net (David Fitzjarrell) wrote:
> > > Use MySQL. It's cheap, easy and can be run by the dumbest of users.
> > > And, recovery is a snap since all you need do is restore a directory
> > > tree.
> > > ....
> >
> > Sounds like a good idea except that ArcSDE doesn't run on MySQL.

> Therefore, I shouldn't care if ArcSDE works with MySQL or not; the OP
> cannot be bothered to actually LEARN Oracle, yet expects to use it
> without effort on his/her part. If a Ph.D. candidate cannot learn the
> tools required to earn his/her advanced degree, possibly their efforts
> should be directed elsewhere.
>
> My two cents.
>
> David Fitzjarrell

I think the OP didn't realize that Oracle isn't point'n click but that
it is a RDBMS that takes months (or years) to learn. I also think the
OP was primarily interested in running ArcSDE and didn't care too much
about the underlying RDBMS. I can certainly understand that, why spend
a few months learning Oracle DBA skills when your Ph.D. might be about
Geography (or whatever it is)?

My advice to the OP is to use Microsoft SQL Server instead of Oracle.
You can run ArcSDE on it and it's easier to use than Oracle (but less
powerful).

bdbafh@gmail.com (Paul Drake) wrote in message news:<910046b4.0411130734.7f0dde0e@posting.google. com>...
> "tpcolson" <tpcolson@unity.ncsu.edu> wrote in message news:<cn30bb$ffc$1@uni00nw.unity.ncsu.edu>...
> > 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.
>
> <old_timer>
> forget all about that java stuff and fire up a command prompt.
> </old_timer>
>
> seriously, if you are windows-inclined, cmd.exe, sqlplus.exe, rman.exe
> are all you need (although cygwin wouldn't hurt and the occassional
> lsnrctl.exe, orapwd.exe, oradim.exe, imp.exe, exp.exe and sqlldr.exe).
>
> if you're running on Linux, bash, sqlplus, and rman are all you need
> for backup/restore/recovery.
> I can think of no reason to be running the OEM GUI.
>
> start here: http://otn.oracle.com/pls/db92/db92.homepage
> (as I believe that you meant Oracle 9i R2 9.2)
>
> hth.
>
> -bdbafh

Yes -
I would definitley prefer command line RMAN-utility. In a few commands
you can Backup and Recover.

I would further suggest:

<old_timer>
Create another database for testing the recovery
read the ORACLE documentation about Backup/Recovery and RMAN
</old_timer>

Spent a few hours with it and skip that GUI...
It's always better to know what's going on under the covers.

yk

Hi,

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
In article <cn30bb$ffc$1@uni00nw.unity.ncsu.edu>, tpcolson
<tpcolson@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.
>
>