Re: backup Oracle 9i on Win 2K server

Ok. All I am concerned about is the cold backup. We don't have a production database (it is only for development testing) so backup of every single transaction is not necessary. If there is a better way to shut down the instances then what is it?? Can it be done automatically??

Thanks for all the replies.

Andrew

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3c740090_1_at_mk-nntp-1.news.uk.worldonline.com...
> Andrew,
>
> Well, there's a lot to this, and you really do need to do some reading.
But
> the immediate answer to the highest priority question is Yes, the
> instance(s) *must* be shut down before you do a cold backup, or any backed
> up files will be unusable (I think the backup utility will not copy them
> anyway, as the files are open).
> There are better ways of shutting down the instance(s) than stopping the
> services, but that at least would be a start.
>
> For *only* getting a successful cold backup, you don't need to worry about
> archivelog mode (yet, until you've done some of that reading). That's for
> other types of recovery.
>
> To others, before war breaks out, this is a _starting_ point. Yes, I am
> aware of the issues. Let's help Andrew at least get a cold backup first.
>
> Paul
>
> "Andrew Tompkins" <andrew.tompkins_at_jjmackay.ca> wrote in message
> news:r2Sc8.40$7S6.30711_at_sapphire.mtt.net...
> > Hello,
> >
> > I am not a DBA or anywhere near that (so my questions may be very
simple).
> > I have a Windows 2000 server, on it (among other things) is Oracle 9i.
> Now,
> > I am backing up the complete server using the backup utility that comes
> with
> > Win2k (it is only a test server for now!).
> >
> > The only thing I am concerned with is if my server complete goes down
> (i.e.
> > hard drives go), then I want to beable to put the entire system back to
> the
> > state from the last backup. I read that before a backup I need to shut
> down
> > the "OracleServicesid" service on the Win2K server so that it will
unlocks
> > certain files. Do I (or should I) also put the database in "Archivelog"
> > mode?? Is there anything else I need to do before I do general
backups??
> >
> > Appreciate any help. Thanks,
> >
> > Andrew
> >
> >
>
>
Received on Tue Feb 26 2002 - 08:13:30 CST