good morning everyone, hello i am come back for write and post article on my site.i will tell u about how to fix one of problem in Oracle database. as we know there are any problem if we did something. example like when i was try to make tablespace in Oracle. the following statement has error line my database haven’t opened. so i try to alter database open for solve that. but the reality i have some error message like this.

Capture  Capture2

Then i was browsing in the Google how to fix that. finally i find a thread in Oracle site now i want to share from anyone hehehe :D. first u have to do ‘SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;’


then, we can alter database to open.


Hehehe thanks have read my simple post,may be useful. see u have a nice day.

reference :


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s