Restore spfile from rman backup

SPFILE RECOVERY:

Take backup of spfile via rman

rman target /
backup spfile;


Now in order to restore the same:

Create a pfile with initSID.ora name and enter DB_NAME parameter in it.

vi $ORACLE_HOME/dbs/initSID.ora
DB_NAME=TEST


·        Start DB in nomount with force and set DBID ( It is necessary to know the DBID ). post that you can restrore spfile and then restore your controlfile and then you will be required to start your database with reset log option.

      
     rman target /
     startup force nomount;
     set dbid 2943784586;
     restore spfile from '/backup/backup_of_spfile.bkp';
     restore controlfile from '/backup/latest_controlfile_backup.bkp';
     alter database mount;
     alter database open resetlogs;



    Thanks & Regards
    Nikhil Kumar.





Comments

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

Queryable inventory could not determine the current opatch status.