Re: resizing of log files

Alexander V. Silantiev wrote:
>
> No problem, I simply would like to clear the question.
> Thanks for the information about
> Alexander
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
> ÓÌÅÄÕÀÝÅÅ:tkgu0dfp5b9kb0_at_beta-news.demon.nl...
> > Exactly!
> > Only 2 commands instead of 1.
> > Of course you may also need to switch the logfile because you obviously
> > can't do anything with a current logfile, nor drop nor resize.
> > As resizing online redo logfiles occurs only very infrequently I don't see
> > what the problem is with running two commands instead of one.
> > Put them in a script with proper parameters and that's it.
> >
> > Regards,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> >
> > "Alexander V. Silantiev" <silantiev_at_bashkortostan.ru> wrote in message
> > news:9i9pbu$84d$1_at_poikc.bashnet.ru...
> > > And its still means that there is not the way of log file resizing
 without
> > > droping and recreating its
> > > with a different attributes?
> > > Alexander
> > >
> > >
> > >
> > >
> > >
> > > Daniel A. Morgan <dmorgan_at_exesolutions.com> ñîîáùèë â íîâîñòÿõ
> > > ñëåäóþùåå:3B486091.723BCA8F_at_exesolutions.com...
> > > > "Dr.J" wrote:
> > > >
> > > > > no. not in Oracle. DB2 lets you do this
> > > > >
> > > > > Dr.J
> > > > >
> > > > > "Alexander V. Silantiev" <silantiev_at_bashkortostan.ru> wrote in
 message
> > > > > news:9i9kik$89k$1_at_poikc.bashnet.ru...
> > > > > > Is there the way of log file resizing without droping and
 recreating
 its
> > > > > > with a different attributes?
> > > > > > Thanks in advance
> > > > > > Alexander
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > > Where'd you get your PhD doctor? <g>
> > > >
> > > > The following is quoted from Oracle8i Designing and Tuning for
 Performance
> > > > Release 2 (8.1.6) A76992-01 which can be found on release CDs,
 documentation
> > > > CDs, and at technet.oracle.com.
> > > >
> > > > "Although you specify the number and sizes of online redo log files at
> > > > database creation, you can alter the characteristics of your redo log
 files
> > > > after startup. Use the ADD LOGFILE clause of the ALTER DATABASE
 statement
 to
> > > > add a redo log file and specify its size, or the DROP LOGFILE clause
 to
 drop a
> > > > redo log."
> > > >
> > > > Daniel A. Morgan
> > > >
> > > >
> > >
> > >
> >
> >

To be pedantic, you could stop and open your database resetlogs after recreating the controlfile - you haven't dropped and recreated them - but its a hard longwinded way of doing it...

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."