Re: backup without archivelog mode

"Howard J. Rogers" wrote:
>
> Archivelog mode simply means that you can guarantee recoverability of all
> transactions.

Except for nologging transactions.

> 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.

Regards,
Sean Received on Sat Mar 23 2002 - 09:22:57 CST