Restore spfile

In this post, we will see how to restore spfile

SQL> startup mount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/appndb/oracle/product/12.2.0.1/db_1/dbs/initorcl.ora'
SQL> 

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

[oracle@dbatesting dbs]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jan 23 18:21:27 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/product/12.2.0.1/db_1/dbs/initorcl.ora'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area    1073741824 bytes

Fixed Size                     8628936 bytes
Variable Size                293602616 bytes
Database Buffers             763363328 bytes
Redo Buffers                   8146944 bytes

RMAN> 

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

RMAN> restore spfile from autobackup recovery area '/home/oracle/fast_recovery_area/orcl' db_name 'orcl';

Starting restore at 23-JAN-19
using channel ORA_DISK_1

recovery area destination: /home/oracle/fast_recovery_area/orcl
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP /home/oracle/fast_recovery_area/orcl/ORCL/autobackup/2019_01_17/o1_mf_s_997807244_g40roof5_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /home/oracle/fast_recovery_area/orcl/ORCL/autobackup/2019_01_17/o1_mf_s_997807244_g40roof5_.bkp
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 23-JAN-19

RMAN> 

Let’s shut down database and restart it

[oracle@dbatesting dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 23 18:28:58 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> shut abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size		    8794696 bytes
Variable Size		  620760504 bytes
Database Buffers	 1459617792 bytes
Redo Buffers		    7979008 bytes
SQL> show parameter spfile

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string	 /home/appndb/oracle/product/12.2.0.1/db_1/dbs/spfileorcl.ora
SQL> 

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