Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Redo log

RE: Redo log

From: Reardon, Bruce (CALBBAY) <>
Date: Tue, 02 Jul 2002 15:13:21 -0800
Message-ID: <>

Based on the ls output it seems you may have 4 groups with 1 member in groups 1,2 & 4 but 3 members in group 3. Do a "select * from v$log;" and see how the logs are really setup.

I would suggest you want to have the same number of members in each group.

If you want them to switch less often either (a) produce less redo (use logminer to analyse and maybe updates / deletes etc are happening that don't need to) or (b) use bigger logfiles. This assumes they're switching because they're full. How big are the archive logs that are produced - are they all around the same size or are some very small?

As for LogMiner - if you're in archive log mode and you've backed up / got a copy of the archive logs from 2 days ago then yes LogMiner will be able to analyse them.

Bruce Reardon

-----Original Message-----

Sent: Wednesday, 3 July 2002 2:43

I found couple redo logs in my Oracle8.0.5 database, as shown they are switched every 5 minutes. I'd like to have only two or three logs out there and don't want them to be switched until every 4 hours. Is there a way to control it that way?

Secondly, if redo log switchs every 5 minutes, does LogMiner have capability to view transaction history from two days ago? Please advise.

$ ls -l redo*                                                      

-rw-r----- 1 oracle dba 512512 Jul 2 11:20 redo01.log
-rw-r----- 1 oracle dba 512512 Jul 2 11:20 redo02.log
-rw-r----- 1 oracle dba 512512 Jul 2 11:15 redo03.log
-rw-r----- 1 oracle dba 512512 Jul 2 11:20 redo03_1.log
-rw-r----- 1 oracle dba 512512 Jul 2 11:20 redo03_2.log
-rw-r----- 1 oracle dba 512512 Jul 2 11:15 redo04.log


Please see the official ORACLE-L FAQ:

Author: Reardon, Bruce (CALBBAY)

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Tue Jul 02 2002 - 18:13:21 CDT

Original text of this message