Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00357 strange... compared to V$CONTROLFILE_RECORD_SECTION
Greetings,
I got a strange error when creating a loggroup with 3 members in.
I got ORA-00357 (too many members specified for log file, the maximum is string)
Then I looked at V$CONTROLFILE_RECORD_SECTION
and it says:
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ---------- DATABASE 192 1 1 0 0 CKPT PROGRESS 4084 8 0 0 0 REDO THREAD 104 8 1 0 0 REDO LOG 72 32 6 0 0 DATAFILE 180 254 22 0 0 FILENAME 524 319 31 0 0 TABLESPACE 68 254 20 0 0 RESERVED1 56 254 0 0 0 RESERVED2 1 1 0 0 0 LOG HISTORY 36 65535 52086 35535 22085 OFFLINE RANGE 56 291 0 0 0 ARCHIVED LOG 584 811 811 740 739 BACKUP SET 40 408 0 0 0 BACKUP PIECE 736 510 0 0 0 BACKUP DATAFILE 116 563 0 0 0 BACKUP REDOLOG 76 107 0 0 0 DATAFILE COPY 660 519 0 0 0 BACKUP CORRUPTION 44 371 0 0 0 COPY CORRUPTION 40 408 0 0 0 DELETED OBJECT 20 816 0 0 0 PROXY COPY 852 575 0 0 0 RESERVED4 1 8168 0 0 0
according to REDO LOG here it should be no problem, or what am I missing here ?
Thanks for any comments.
/Christian Svensson Received on Wed Nov 21 2001 - 07:26:58 CST
![]() |
![]() |