ORA-03113 ERROR after shutdown abort(incomplete shutdown)

if you got error ORA-03114 like this

Snip20141228 1

you can simply try to fix by following commands
1.)
go to service.msc, restart the service of the instance
2.)
after restart the service.
should be able to get in by sqlplus as sysdba
then,

shutdown abort
exit

3.)
re-login sqlplus as sysdba

startup mount
recover database 
until time '2014-12-27 0:00:00'; -- TODAY's DATE
alter database open resetlogs;
shutdown;
startup;

that’s it!

good luck!

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s