Quote Originally Posted by PAVB
... or perhaps poster has one or more datafiles in need of media recovery... huh?
Yes, I agree, question seems to be confusing, so just tried to check some basics ... maybe an alert.log might help ...

Also,

SQL> select * from v$recover_file output would provide some insight.

Thanks, PAVB for showing the right path.

Regards,
Paresh