Friday, April 28, 2006

ORA-00336 in Oracle 10g

When I create add logfile , occured ORA-00336

SQL> alter database add logfile group 4
2 'd:\redo4.log' size 3m;
alter database add logfile group 4
*
ERROR at line 1:
ORA-00336: log file size 6144 blocks is less than minimum 8192 blocks

...

The problem is due to restriction in 10g to take the log file size to less than 4m.
Blocks in logfile size means OS-blocks (size 512 Bytes)

8192 blocks = 8192 * 512 (bytes) = 4MB
6144 blocks = 6144 * 512 (bytes) = 3MB

2 comments:

Anonymous said...

Is there a way to change that restriction to, say, 512 B = 1 block?

HunterX said...

Actually I need another way too.
But I think most OS-Blocks be 512 bytes for this.

I tried to test:
>> create ext3 filesystem block 2K bytes

# mkfs.ext3 -b 2048 -L /u02 /dev/sda6

# mount /dev/sda6 /u02/

# mkdir /u01/oratest

# chown -R oracle:dba -R /u01/oratest

# su - oracle

$ sqlplus / as sysdba

SQL> alter database add logfile group 4 '/u02/oratest/redo04.rdo' size 3m;
alter database add logfile group 4 '/u02/oratest/redo04.rdo' size 3m
*
ERROR at line 1:
ORA-00336: log file size 6144 blocks is less than minimum 8192 blocks


SQL> alter database add logfile group 4 '/u02/oratest/redo04.rdo' size 4m;

Database altered.