topic Discussion in Operating System - HP-UX

Discussion

sachin kapse — Wed, 30 Aug 2006 08:52:45 GMT

What are redo log files & latches in oracle

Re: Discussion

HGN — Wed, 30 Aug 2006 08:56:59 GMT

Hi

Looks like you have posted in the wrong forum, this is a Unix forum (HPUX), someone might have details you can also try oracle discussion.

Rgds

HGN

Re: Discussion

Peter Godron — Wed, 30 Aug 2006 09:27:03 GMT

Hi,
In short:

redo logs are files where uncommited changes are written as part of a two-phase commit process i.e. changes are held there until the commit is issued.

latches are holds of data-structures in the SGA whilst the process is using them.

For further reading on latches:
http://oracle.ittoolbox.com/documents/peer-publishing/latches-and-latch-contention-2371

Re: Discussion

Sean Dale — Wed, 30 Aug 2006 12:16:54 GMT

Just in case you were wondering, once redo log rotations are full, they are archived. That is what archivelogs are. Archivelogs are used to restore/undo information, if needed. They are also transferred to standby databases to keep them in sync if you are using dataguard.

Re: Discussion

Jonathan Fife — Wed, 30 Aug 2006 12:26:01 GMT

Hi,

A follow up to Peter's response -- the redo logs actually hold both committed and uncommitted data. If you lose a group of un-archived redo logs you will almost certainly lose committed data, so it is important to multiplex them across physical locations.