Sybrand Bakker wrote:
>
> alter database drop logfile group <n>
>
> alter database add logfile group <n> ('<filename>','<filename>') size
> ...
>
> You must make sure the logfile is not in use which you can verify by
> querying v$log.
> If it is in use
> alter system switch logfile
and to make life easier for yourself, create the
new ones before you drop the old ones.
Then all you need is to switch logfile when you hit
the old one that is still being used.
Received on Sun Jan 29 2006 - 20:38:26 CST
