Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Command line backup
Hi Zorglub,
to copy the files in "oradata/mydatabase" might not be enough. For example you
might miss the control files.
Check http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.
817/a76993/toc.htm for further
reading (you have to be registered to technet - it is not a big deal, just answer
some questions).
Thomas
Zorglub <no_at_mail> wrote:
>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
>>
-- __________________________________________________________ News suchen, lesen, schreiben mit http://newsgroups.web.deReceived on Tue Jan 22 2002 - 06:57:59 CST