Re: hot Oracle 8 / NT backups

Hi Robin,
try this:

run your RDBMS in ArchiveLog mode

with at command (NT) start a script using the servermanger (svrmgrl, svrmgr23...(oracle)) with following commands

connect internal [pw]
alter tablespace <name> begin backup;
....(all tablespaces)
exit;

then windows:
copy all nessesary files: data, system, redologs.... to backup directory

again servermanager
connect internal [pw]
alter tablespace <name> end backup;
....(all tablespaces)
exit;

but please:
training only at non-production system!

Christoph

GunHack schrieb in Nachricht <86t8er$v5p$1_at_nnrp1.deja.com>...
>Greetings to the List!
>
>I am a novice Oracle administrator, attempting to set up hot,
>preferably automatic, back ups for a Oracle DB supported on an NT
>server. I do not have any third party tools, so anything I do must be
>native Oracle 8 / NT. I am having a heck of a time just trying to get
>the backup catalog DB set up, etc. Does anyone have a set of NT .bat
>files they would care to share to get me over the initial hump of just
>getting the infrastructure set up?
>
>ANY help, advice, etc. would be greatly appreciated...!
>
>Regards;
>
>Robin Arthur Gustavson
>RFD & Associates, Inc.
>Austin, Tx.
>rgustavson_at_rfdinc.com
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Jan 29 2000 - 00:00:00 CST