alter database open resetlogs;
529178Jan 17 2007 — edited Feb 5 2007hi,
i created a newcontrolfile to do cloning of a database i created the trace of controlfile then,
SQL> alter database mount;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00336: log file size 2048 blocks is less than minimum 8192 blocks
then my redolog file size is 1m,
my parameter related to log
SQL> show parameter log_buffer
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_buffer integer 524288
SQL>
SQL> show parameter db_block_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192
SQL>
but all of my setting are, correct i think but dont knew what the mistake was,
can any one help me in this.