You have to drop and recreate your logfile groups. Look at the 'ALTER
DATABASE' statement. If you recreate your logfile groups while the
database is online, make sure that you don't drop a logfile group that is
currently in use!!
Sigrid Staudte wrote in message <34954829.7B70D0F_at_rz.uni-leipzig.de>...
>John P. Higgins wrote:
>>
>> It all depends on the activity level. On a busy database, I increased
>> the redo log files from 20MB to 200MB. Then I queried V$LOG_HISTORY and
>
>How can I increase the redo log size ?
>I already have created a new create control file command
>with the command alter system backup controlfile to trace
>and then I have increased the size of redo logs.
>But the execution of the create control file command
>produced an error that the operating system block size
>is not compatible with my file size.
>
>Sigrid
Received on Mon Dec 15 1997 - 00:00:00 CST
