Today we are going to have look on the steps which we are going to use in Oracle for ” Recover From Redo Log File (After Lost Data File)”. The loss is loss being DBA we well understand the cost of loss “CDR”

Check archive list

check the tablespaces and datafile

Create new tablespace and table with some data

Check records in table and recheck the tablespace

Shutdown the database and delete datafile

Try to start the database

Create the data file and recover it

Today’s thought If people like you, they’ll listen to you, but if they trust you, they’ll do business with you.– By  Zig Ziglar 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.