Re: Command line backup

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 22 Jan 2002 10:09:14 -0000
Message-ID: <a2jdp8$jc0$1@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

"Zorglub" <no_at_mail> wrote in message
news:Xns919E6F467616DzorglubID1923_at_213.228.0.138...
> Hello, I would like to backup a database without using the enterprise
> manager console.
> Does Oracle 8i provide a command line app like exp and imp but for backups
> ??
>
> Thanks you..
Received on Tue Jan 22 2002 - 04:09:14 CST