In this session, we will try to solve the issue related to redo log corruption.
We are trying to open the database but facing error ORA-00742 and ORA-00312
Now, checking the logfile status and the location in database
Trying to recover the database and then let try to open the database
Now at last, Rename the redo log file through the OS command as below snap
Now trying to open the database using resetlogs
Issue has been resolved........................................Enjoy and stay connected.
Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
A. Rawat
Email: 88arawat@gmail.com