Re: Command line backup

Okay okay that seems a good way. I'm not working in production environment. Thus, if I simply shutdown the NT service of my database I just have to copy all the files in "oradata/mydatabase" ?? I suppose that if I have a problem I can do the same for restore ? Just stop and overwrite the files ?

Thank you

"Alistair" <alistair.thomson_at_sphinxcst.co.uk> wrote in news:a2jdp8$jc0$1_at_thorium.cix.co.uk:

> You can use server manager in one of two ways, either shut down the
> database and copy all the files (cold backup) or if the database is in
> archivelog mode you can take a hot backup
>
> alter tablespace system begin backup;
> copy the file
> alter tablespace system end backup;
>
> There are scripts on the internet that go into this in detail and just
> require a bit of tweaking to set them for your environment.
>
> Alistair
>
Received on Tue Jan 22 2002 - 05:56:11 CST