Hi Gurus,

I understand that if all the controlfile / redologs / system tablespace/ RBS is inaccessable (media error) by oracle instance, the instance crashes. If any other datafile becomes inaccessable, it takes the tablespace offline. - correct me if I am wrong.

But is there a way to specify a timeout so that Oracle waits for that period before coming down crashing.

Thanks
Sridhar