ORA-00336: log file size 400 blocks is less than minimum 8192 blocks
753926Jun 3 2010 — edited Jun 4 2010I have windows XP with 10g 10.2.0.1.0
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00336: log file size 400 blocks is less than minimum 8192 blocks
SQL> show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_buffer integer 7024640
SQL> show parameter db_block_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192
SQL>