Re: ORA-00357 strange... compared to V$CONTROLFILE_RECORD_SECTION

Thanks.

I suppose I have to restart the database ? It is version 8.1.6 btw, or are there ways that I can workaround this ?

It is a 24*7 database so I preferably dont want a restart.

Thanks.

/Christian

aviion <member_at_dbforums.com> wrote in message news:<3bfc0aa2$3_at_usenetgateway.com>...
> do alter database backup controfile to trace; and go to udump directory
> and open this tracefile and check the maximum limit on maximum number of
> log file members, u need to recreate the controlfile with newer value if
> the the number is less than what u are to trying to create.
>
> CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS ARCHIVELOG
> MAXLOGFILES 16 MAXLOGMEMBERS 4 MAXDATAFILES 50 MAXINSTANCES 3
> MAXLOGHISTORY 453
>
> Here maximum is 4 per group. MAXLOGMEMBERS 4
Received on Thu Nov 22 2001 - 05:09:17 CST