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

Production on Sun Sep 28 14:56:38 2013
Connected to:
Oracle Database 12c Enterprise Edition
Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics
and Real Application Testing options
connected to target database (not started)
RMAN> startup force nomount pfile=?/database/initorcl.ora
Oracle instance started
Total System Global Area 163213312 bytes
Fixed Size 1331852 bytes
Variable Size 71306612 bytes
Database Buffers 79691776 bytes
Redo Buffers 10883072 bytes
Using ? in the Pile Command
Did you see how we used the ? placeholder in the PFILE command? The ? placeholder
represents the location for ORACLE_HOME .
You can now restore the spfile backed up in the last control-file autobackup using the
RESTORE SPFILE FROM AUTOBACKUP command, as shown here:
RMAN> restore SPFILE from autobackup;
Starting restore at 28-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=98 device type=DISK
recovery area destination: c:\oracle\fast_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2013_09_28
\O1_MF_S_666628278_4FZTDYVC_.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
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\2013_09_28
\O1_MF_S_666628278_4FZTDYVC_.BKP
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 28-SEP-13