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: backup without archivelog mode

Re: backup without archivelog mode

From: Sean M <smckeownNO_at_BACKSIESearthlink.net>
Date: Sat, 23 Mar 2002 15:35:18 GMT
Message-ID: <3C9CA0D7.6A39601A@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.

Regards,
Sean Received on Sat Mar 23 2002 - 09:35:18 CST

Original text of this message

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