Let’s have look on the steps are used by Oracle DBA  for “Recreate Database Using Only Datafile and Logfile”.
Backup of the control file in trace

create password file and service

set the environment and start the database in nomount

Create the controlfile

NOTE- If you want to set the new name of the database then use the following command:

Open the database

Today’s Thought

“You have to act and act now.” – Larry Ellison

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:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Comments

Leave a Reply

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