Restore spfile from controlfile autobackup using RMAN

Search
Generic filters
Exact matches only
Filter by Custom Post Type

Restore spfile rman method

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

  • Accidental deletion
  • Editing spfile using text editors

We can restore the spfile  in two methods

  1. Manually recreating the spfile, as discussed in this document
  2. Restore spfile rman method ( We should have a valid RMAN backup of the controlfile  for this method)

 

While using RMAN method to restore spfile , we have two options

  • Using controlfile autobackup , if controlfile autobackup is enabled
  • From the backup piece or backupset , which contains the controlfile backup , if  controlfile autobackup is unavailable

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

Sale

[adrotate banner=”3″]

Restore Spfile with controlfile autobackup

Use the following RMAN steps to restore spfile when controlfile auto backup is available

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

Finding Controlfile Autobackup Status

RMAN ‘Show all’ command will tell us if controlfile autobackup is enabled.

RMAN > show all;

If the controlfile autobackup is enabled , we will be getting a message similar to the below

RMAN > configure controlfile autobackup on;

By default controlfile autobackup will be created in “Autobackp” folder in flash recovery area. If you want to store the autobackup in another location use the below command

RMAN >  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/CTRL_%F';;

The above command will change the controlfile autobackup location to ‘/backup’ folder.

Next steps assumes that controlfile autobackup is enabled and autobackups are available

More Reading

[adrotate banner=”3″]

1)Find out the latest backup of spfile:

 Issue the following commands to  find the latest backup of the spfile:

RMAN > connect target /
RMAN > list backup of spfile;

2)Startup a temporary Instance :

For  RMAN to work at the minimum instance should be running . We can create a temporary instance for this purpose.  To start the temporary instance , create a pfile , start the instance in nomount stage .

3)Restore the spfile from autobackup :

Issue the following command to restore the spfile to default location ie $ORACLE_HOME/dbs in Linux/Unix

RMAN> restore spfile from autobackup;

To restore the spfile to temporary location issue the following command

RMAN> restore spfile to '/tmp/spfilemydb.ora'  from autobackup

Imp :  We will discuss more on RMAN steps to restore the spfile from backup piece   in another document

[adrotate banner=”3″]

Hope this helps ..

Happy Learning  🙂

Wysheid Team

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