Re: resizing of log files

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
> >
> >
>
>
Received on Sun Jul 08 2001 - 10:13:19 CDT