Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 8 hot backup without archivelog mode ?

Re: oracle 8 hot backup without archivelog mode ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 2000/07/15
Message-ID: <8kq4f0$hl6$1@lure.pipex.net>#1/1

"Jeffrey Schott" <jschott_at_schottconsulting.com> wrote in message news:n5Ib5.48$aO1.877_at_news3.voicenet.com...
> If you bring the tablespace offline you can perform a backup while the
 rest
> of the tablespaces are available. Unfortunately, you will be not able to
> access the tablespace that you are backing up.

which is why you will not be able to backup the system tablespace & hence the data dictionary.<snip>

The short answer is NO.Archivelog is required for Hot Backup.

Niall Litchfield
Oracle DBA
Audit Commission
> Piotr Ga³uszkiewicz <pkg_at_poczta.fm> wrote in message
> news:8kms4n$q30$1_at_zeus.polsl.gliwice.pl...
> > Hi
> >
> > Know anybody some ways or software to "hot" backup (without shutdown)
 oracle
> > 8 database but
> > in NO ARCHIVELOG mode ? (Solaris / Sparc platform)
> >
> > Piotr
> >
> >
>
>
Received on Sat Jul 15 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US