Re: Redo logs. Please explain.

From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/12/11
Message-ID: <4aie91$hs5_at_peg.apc.org>#1/1


chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>I'm trying to learn the DBA job by reading the Oracle manuals. Can
>someone please explain how the redo log files relate to one another?
>If I create a database with the following redo log groups....
>
>CREATE DATABASE "tardis"
>...
>LOGFILE GROUP 1 ('a.log', 'b.log') size 1m,
>LOGFILE GROUP 2 ('c.log', 'd.log') size 1m;
>
>Which files are mirrors of which? And which are used in the circular
>fashion as described in the concepts manual?
>
In your case 'b' mirrors 'a'.

When group 1 (a and b) are full a log switch occurs to group2 (c and d).

>Do 'a' and 'c' mirror each other, or do 'a' and 'b'? I need to know
>so I know which drives to place the files on to protect against media
>failure.
>
>The manuals seem to cover everything about redo logs except this.
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>Never share a foxhole with anyone braver than yourself!
>

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt.

Anon. Received on Mon Dec 11 1995 - 00:00:00 CET

Original text of this message