Recovering Server Parameter File

Generic filters
Exact matches only
Filter by Custom Post Type

Recovering server parameter file

If the Server Parameter file is lost or corrupted , the next startup of the instance may fail . There is chance of the failure of the current instance as well.

The following are the common reasons for the corruption or loss of the spfile

  • Accidental deletion
  • Editing spfile using text editors

in this document , we will disucss on  two situations of recovering  server parameter file or spfile

  1.  When the database up and running , that is using the information from memory
  2. Using the text based parameter file

Related Course

Oracle 12c Backup & Recovery Using RMAN

Oracle 12c Backup & Recovery Using RMAN

The complete self learning course on Backup and Recovery Using RMAN For Oracle 12c Database ...

$125.00 $100.00Add to cart


Steps For Recovering server parameter file or spfile

Use the following steps to recovering server parameter file or spfile

Please note : Whenever RMAN backup the controlfile  , the spfile is automatically   backed up along with controlfile

The control is automatically backed up in the following situations

  • When the full back is taken place
  • When the system datafile is backed up
  • On all backup commands , if the controlfile auto backup is enabled

More Reading

Recreate  using the values in memory:

If the instance is running, issue the following command to recreate the SPFILE from the current values of initialization parameters in memory:

SQL> create spfile from memory

Recreate  using the pfile:

SQL> create spfile from pfile;

Restore spfile from RMAN Backup:

RMAN> restore spfile from autobackup


RMAN> restore spfile from backuppiece

Imp :  We will discuss more on RMAN steps to restore the spfile   in this document

Subscribe to receive updates of our blogs

[email-subscribers namefield=”YES” desc=”” group=”Blog Subscribers”]

Liked this Article.?

We have lot more interesting posts like this!  Join more than 5000 subscribers who stays ahead on technology.

By entering your email, you agree to the Terms and Conditions and Privacy Policy and cookies usage

You Make like the below posts

About The Author

Share on

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest

Leave a comment

Your email address will not be published. Required fields are marked *

Can't Find What You Are Looking For?.

Please enter the details below. We will try our best for you :-)

We have more amazing posts

Try searching here

lick edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve