This content has been marked as final. Show 4 replies
you need reset the logs ,before going to open the database ,
shut immediate;then you can open the database as
alter databse open resetlogs;
alter database open;i hope this will you.
Fixed my recovery just a while ago.
Anyway, thanks a lot for your feedback.
Yes Only write this
alter database open resetlog;
and your database will be up and running :)
see if you recover database incompletely , like until time, until sequence, until scn, until cancel.... you need to open the resetlgos bcoz of incomplete recovery.
alter database open resetlogs;close the thread as answered