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
--
Posted via dBforums
http://dbforums.com
Received on Wed Nov 21 2001 - 14:12:18 CST
