Recovering Databases with RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 225

starting Oracle instance without parameter file for retrieval of SPFILE
Oracle instance started
Total System Global Area 159019008 bytes
Fixed Size 1331852 bytes
Variable Size 67112308 bytes
Database Buffers 83886080 bytes
Redo Buffers 6688768 bytes
The restore process for an spfile differs a bit depending on whether you have been using
the FRA or not. We will look into these two different options in the next sections.
Restoring the Spfile When Using the FRA
Restoring the spfile when using the FRA is a bit more complex than restoring the control
file. First, you will need to start the database instance, as demonstrated previously. Then
you will need to configure the FRA location. Because the FRA parameter DB_RECOVERY_
FILE_DEST is not dynamic, you need to create a temporary pfile based on the current
memory settings and then update it with the correct FRA location.
You create the temporary pfile from the in-memory settings using the SQL command
CREATE PFILE FROM MEMORY . This command will create a database parameter file that you
will edit. The parameter settings in this file will be based on the default, in-memory settings
used when RMAN started the database. Here is an example of the creation of the pfile from
memory:
RMAN> sql 'create pfile from memory';
using target database control file instead of recovery catalog
sql statement: create pfile from memory
Note that you must create a pfile and not an spfile. This is because you cannot restore
over an existing spfile that is in use. Using your editor of choice, edit the pfile you just
created. The pfile will typically be created in ORACLE_HOME/database in Windows and
$ORACLE_HOME/dbs in Linux.
You will want to set the DB_RECOVERY_FILE_DEST parameter to the location of the FRA
and DB_RECOVERY_FILE_DEST_SIZE to the size of the FRA. When setting the DB_RECOVERY_
FILE_DEST_SIZE parameter, don't worry about how big to size it because this is just a tem-
porary parameter setting for the spfile restore. The real value of the parameter will be set
after the spfile has been restored. Here is an example of what those parameters would look
like in a pfile:
db_recovery_file_dest='c:\oracle\fast_recovery_area'
db_recovery_file_dest_size=10g
Once the parameter has been set correctly, save the file and restart the database using
the temporary pfile, as shown here:
C:\Documents and Settings\Robert>rman target=/
Recovery Manager: Release 12.1.0.1.0 -