Re: backup without archivelog mode

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sun, 24 Mar 2002 07:46:40 +1100
Message-ID: <a7ipl6$m8e$1@lust.ihug.co.nz>

"Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message news:3C9CA0D7.6A39601A_at_BACKSIESearthlink.net...
> Sean M wrote:
> >
> > > But: You can never, ever make a copy of any database file whilst the
> > > database is running, without that copy being internally inconsistent.
> >
> > Except for datafiles belonging to read-only tablespaces.
> >
> > > If you want to take hot backups (which your use of the 'alter
tablespace
> > > Florence begin backup' command suggests you want to do) then you will
> > > absolutely, positively have to be in archivelog mode. There is no
exception
> > > to the rule that hot files cannot simply be copied.
> >
> > Except for datafiles belonging to read-only tablespaces.
>
> Sorry, one more exception to the "no exceptions" rule: datafiles that
> were taken offline normal.
>

And while you're in nit-picking correction mode, you might also bear in mind that anything offline is also, by definition, not hot.

So it's not an exception.

HJR
> Regards,
> Sean
Received on Sat Mar 23 2002 - 14:46:40 CST