RE: Confusion why online redo logs should never be backed up.

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 23 May 2003 11:32:17 -0800
Message-ID: <F001.005A1BDB.20030523113217@fatcity.com>

Ray

   Oracle writes to the redo log until it reaches the limit you have set. Then it is filled. On a busy database with a lot of updates, that can occur very quickly. On a database that experiences few updates, this can take a long time. Once the log is filled, Oracle switches logs.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, May 23, 2003 9:47 AM
To: Multiple recipients of list ORACLE-L

On Thu, May 22, 2003 at 11:22:44AM -0800, David Wagoner wrote:
> Excerpt from the 9iR2 Backup and Recovery Concepts doc:
>
>
> ----------------------begin excerpt;
> If your database is in ARCHIVELOG mode, then the archiver is already
> archiving the filled redo logs.

I'm not sure what that phrase means, "filled redo logs?" Are there redo logs that is not in a file? What is this about?

---

Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 23 2003 - 14:32:17 CDT