Hi,
I am working on Oracle 11g R2 on Linux. Some time back we need to shut down database .
We used shut immediate commend to do it. But even after 2:30 Hours also database was not down . So we used shut abort command to shut it down.
After that when we start database , it started instance recovery , that is also running for more then 1 hour.
Is there any way to check while instance recovery , how much time it is going to take for roll forward and roll back phase . Actually that time our management was asking how much time you need to start database.
We do not know where to find out , how much time remaining for recovery.
Checked on internet but most of post are explaining instance recovery , not how to check time remaining after starting instance recovery.