Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Logs

Re: Redo Logs

From: Karl E. Jørgensen <kjorg_at_msn.com>
Date: 1998/01/10
Message-ID: <ePpLlbfH9GA.276@upnetnews03>#1/1

It's rather simple really:

  1. Figure out what size you want your redo log files (3 Mb ?)
  2. Add three (or more, but at least two) new redo log files with your wanted size
  3. Force some log switches
  4. drop the old logs (if they're still in use, you'll have to force some more log switches)

If you're taking cold backups from time to time, you should remember to modify your scripts accordingly.

If you're using hot backups, you should backup you control file to trace (just to be on the safe side)

Hope this helps

--
Karl
Oracle Certified DBA

Vinay Joshi wrote in message
<717BDE76D864D011870F00A0C9283F1E0F13BB_at_exchange.pinnacle.co.uk>...

>I have an oracle db which has 3 redo logs 10MB each. Upon investigation,
>the redo logs are very big in size. Hardly 5% of the redo log size is
>being used. This causes severe problems when automatic archiving is on.
>Every time a log switch occurs, the system hiccups (because it is trying
>to archive the redo log file). Is there a way of decreasing the size of
>the redo logs. (Perhaps by creating new ones with a smaller size and
>deleting the old ones).
>
>Any help appreciated....
>
begin 666 Karl E. Jørgensen.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DKX<F=E;G-E;CM+87)L.T4N M#0I&3CI+87)L($4N($KX<F=E;G-E;@T*3D]413I396YI;W(@4WES=&5M<R!% M;F=I;F5E<@T*55),.@T*55),.FAT=' Z+R]S97%U96PM:6UA9V4N8V]M#0I% M34%)3#M04D5&.TE.5$523D54.E-004U'54%21"!K:F]R9T!M<VXN8V]M#0I2 @158Z,3DY.# Q,3!4,3_at_S-S(S6_at_T*14Y$.E9#05)$#0H` ` end end
Received on Sat Jan 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US