David,
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.
Regards,
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
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
