Re: SQL Server v. Oracle re: transaction log

From: John P. Higgins <jh33378_at_deere.com>
Date: Tue, 23 Jun 1998 22:20:41 -0500
Message-ID: <35907089.79528B97@deere.com>

Yes. Oracle always has at least two redo logs. When one fills, Oracle switches to the next -- round robin fashion.

If your Oracle database is in ARCHIVLOG mode, Oracle will not overwrite a log file until it has been copied to tape or another directory. This copying (archiving) can be automatic.

If the archive tape or directory fills up, the archiver becomes 'stuck' because it has no place to write the copy. We backup and purge the archived logs daily.

Hocus Pocus wrote:

> SQL server stops completely when the transaction log becomes full. I
> was wondering if Oracle worked the same way. Does Oracle have any
> kind of built in safety features to prevent the transaction (redo) log
> from becoming full?
>
> --
> Regards,
> Ray
Received on Tue Jun 23 1998 - 22:20:41 CDT