Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase log file size after Database creation?

KaziMay 25 2006 — edited May 25 2006

Hi guys !
I m getting the following Problems. Whats the solution...?

SQL> ALTER DATABASE OPEN;
Error :
ORA-01589 : must use RESETLOGS no RESETLOGS options for database open

Then I used the Following command
SQL> ALTER DATABASE OPEN RESETLOGS
Error:
ORA-00336: log file size 4 blocks is less then minimum 8192 blocks

Please tell me How can I increase log file size while database is in mount mode to open the database successfully.

Thanks in advance

Kazi Mokarem

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2006

Added on May 25 2006

#general-database-discussions

3 comments

542 views