Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Logs
It's rather simple really:
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>...Received on Sat Jan 10 1998 - 00:00:00 CST
>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