Re: backup Oracle 9i on Win 2K server

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 Wed Feb 20 2002 - 13:50:51 CST