Re: Resize redo log without making DB in restricted mode

> > Hi All,
> >
> > I have a question.
> >
> > I need to resize my redo log file (right now it is 3 groups (
> > group A, B,C) in 5 Megbyte redo log size,
> > ridiculous small, I did not set it up. I inherit this db).
> >
> > I know it is a better practice to
> > do shutdown DB and then
> > startup restrict and do all the maintenance work.
> >
> > I know how to add another 3 group with bigger size and then
> > drop back all the originally 3 groups, A, B,C.
> >
> > I plan to make the new redo 100Meg or even 150 Meg.
> >
> > Is it really bad style not to bring down
> > the database to do this mainteance?
> >
> > This is a development machine with NO ARCHIVE LOG on.
> > I plan to do it at night time, where , not much transaction going
on in
> > the DB.
> >
> >
> > Just curious? What other people do ... on development machine.
> >
> > On the production, I definitely would do the
> > startup restrict mode to do the mainteance work.
> >
> >
> > Thanks,
> >
> >
> > Dominica
> >
> For this operation there is need to take down the db or put it into
> restricted mode. Just add new log files of the size you want. Then
alter
> the database and switch log files until it is using the new ones.
Then drop
> the small ones.
> Jim

Hi,

• Alter system switch logfile - I presume we have to wait till oracle starts using the bigger logfiles in this case, as there are no commands to make Oracle switch to a specific logfile. correct?
• In case if the logs are being archived, before dropping the old ones we need to make sure they have been archived. I think we can find out if the smaller logs have been archived or not from SEQUENCE# column of v$archived_log. Is there any command to force archiver to start archiving a particular log file or does it start archiving a log autmoatically once a log switch happens. (and to prevent from oracle using the smaller log, drop the smaller logfile as soon as the archiving completes?). Any holes in my assumptions?

Thanks. Received on Mon Apr 25 2005 - 04:56:01 CDT