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
Friday, April 28, 2006
Subscribe to:
Post Comments (Atom)
2 comments:
Is there a way to change that restriction to, say, 512 B = 1 block?
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.
Post a Comment