In this post, we will see how to restore spfile

ORA-01078 is a common error we are facing when we have lost our parameter file. In above case we need to restore spfile from backup

When rman does not find any parameter file , it will use default parameter and open database in nomount mode , so we can restore spfile from backup.

Let’s restore spfile now

Let’s shut down database and restart it

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

Leave a Reply

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