Re: How to do an online backup?

Yes, but the only problem with a export backup, is if you need to restore later by doing an import it takes forever! If you have a large database 5G or larger this method is unacceptable, unless you have weeks to kill and you users don't mind.

• Allen

junlei_at_my-deja.com wrote:

> Have you tried the full database export?
>
> Export and import in Oracle can be performed online (hot backup).
>
> Junlei
>
> In article <38148DB8.7EEAA223_at_tde-online.de>,
> Burkhard Schultheis <bschultheis_at_tde-online.de> wrote:
> > I'm coming from DB2, and there it is easy to do an online backup:
> > db2 backup database online
> > This creates a single file, and together with the log files I can
> > reconstruct the whole database. I've found nothing comparable for
> Oracle
> > (8.0.5 is used here). Or am I wrong?
> > Thank you in advance!
> > --
> > Burkhard Schultheis
> > Tele Data Electronic
> > Wagnerstr. 10
> > D-76448 Durmersheim
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 10:44:48 CDT