how about re-creating the controlfiles with a larger size for the redo logs
?
> ----------
> From: Jenkins, Michael[SMTP:Michael.Jenkins_at_Nextel.com]
> Sent: Wednesday, January 10, 2001 3:58 AM
> To: oracledba_at_lazydba.com
> Subject: RE: Redo logs resizing
>
> My thanks to all concerned. I pulled the article #1035935.6 from metalink
> and successfully performed it live on my Q/A database!
>
> --Michael
>
> -----Original Message-----
> From: Kelly Fu [mailto:kelly.fu_at_brightstar.com]
> Sent: Tuesday, January 09, 2001 1:24 PM
> To: 'Jenkins, Michael'; oracledba_at_lazydba.com
> Subject: RE: Redo logs resizing
>
>
> I posted this long time ago:
>
> I changed my logfile from 4M to 25M and it seems to work fine.
>
> The step I did:
> 1) Alter database sidname add logfile group 4
> ('/u08/oradata/fpro/redofpro01a.log','/u10/oradata/fpro/redofpro01a.log')
> size 25m;
> 2) alter database sidname drop logfile group 1;
> 3) remove old logfile from OS.
>
> Repeated 1 through 3 for all logfile groups. When I tried to drop group
> 2,
> it told me 'log 2 is current log' so I did 'alter system switch logfile;'
> and then continue. All commands from 1 through 3 seem to work fine with
> database open.
>
>
> -----Original Message-----
> From: Jenkins, Michael [mailto:Michael.Jenkins_at_Nextel.com]
> Sent: Tuesday, January 09, 2001 11:19 AM
> To: oracledba_at_lazydba.com
> Subject: Redo logs resizing
>
>
> Does anybody know of any good articles on changing the size of your
> on-line
> redo logs while the database is still available?
>
> Thanks in advance.
>
> Michael L. Jenkins
> Oracle Certified DBA
> Nextel Communications Norcross
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Received on Tue Jan 09 2001 - 22:11:43 CST
