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;’

Capture3

then, we can alter database to open.

Capture4

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

reference :

https://community.oracle.com/thread/641691?start=15&tstart=0

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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