Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00357 strange... compared to V$CONTROLFILE_RECORD_SECTION

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

From: Christian Svensson <chse30_at_hotmail.com>
Date: 21 Nov 2001 05:26:58 -0800
Message-ID: <ccc2a7eb.0111210526.22b05718@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US