Oracle Database Version : 18.104.22.168.0
Some of the datafiles status have been changed to 'RECOVER', because the datafiles are physically missing...
how can i find that when (timestamp) the status of the datafiles have
been changed, as i am unable to find when the datafiles have been
Please consider both the case :
1) when the database is in ARCHIVELOG Mode.
2) when the database is in NOARCHIVELOG Mode.
Thanks in Advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!