Use RMAN automatic backup to dump Spfile

[Scenario overview]
 
The parameter file of the server is lost in the production environment, and rman has enabled Automatic Backup Settings.
 
[Operation process description]
 
---- Start rman
 
$ Rman target/
 
---- Check rman settings
 
RMAN> show all;
 
---- Configure the rman automatic backup control file to simulate the initial setting of the rman automatic backup control file
 
RMAN> configure controlfileautobackup on;
 
RMAN> configure controlfileautobackup format for device type disk to '% F ';

---- After the control file is automatically backed up according to the execution plan developed by the maintenance personnel
 
---- View the automatic backup control file format in the corresponding directory
 
$ Ls
 
---- Format description: control file backup name_parameter file-Database ID (DBID)-backup date-serial number
 
Ctl_spfile_c-2712710828-20140526-38
 
Ctl_spfile_c-2712710828-20140526-39
 
---- Query the DBID of the database. The control file automatically backed up in rman is named as follows.
 
---- Administrator privilege is required to view v $ database in the production environment
 
SQL> select DBID, NAME from v $ database;
 
DBID NAME
 
-------------------
 
2712710828 DRON
 
$ Export ORALCE_SID = DRON
 
---- Create a simple pfile file to start the instance or a pfile file from cp under $ Oracle_HOME/dbs
 
$ Vi initDRON. ora

"InitDRON. ora" [New file]

Db_name = 'dron'
 
DB _ block_size = 8192
 
$ Sqlplus/as sysdba
 
---- Start the instance with the newly created pfile
 
SQL> startup nomount pfile = '/home/oracle/initDRON. ora ';

$ Export ORACLE_SID = DRON
 
$ Rman target/
 
RMAN> set dbid = 2712710828

---- Dumping spfile backup from automatic control file
 
RMAN> restore spfile [to '/home/oracle/initDRON. ORA'] from autobackup;

[Summary]
 
The above process is the spfile file generated through automatic backup of rman. This method is applicable when the parameter file of the server is lost and the automatic backup of the control file is set for rman, this method can be used to solve the problem.

-------------------------------------- Recommended reading --------------------------------------

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------