Restore lost spfile using RMAN backuppiece

rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 13 08:09:37 2014

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

connected to target database (not started)

RMAN> startup

startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/CVRMAN/spfileCVRMAN.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/CVRMAN/spfileCVRMAN.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/cvrman/spfilecvrman.ora
ORA-15173: entry 'spfilecvrman.ora' does not exist in directory 'cvrman'
ORA-06512: at line 4

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 05/13/2014 08:09:58
ORA-00205: error in identifying control file, check alert log for more info

1.Command file to restore the lost spfile
cat rman_spfile_restore.cmd
shutdown abort;
set dbid 657566608;
startup  force nomount; # starting the database in mount mode
restore spfile from "+DATA/cvrman/backupset/2014_05_13/nnsnf0_tag20140513t080118_0.298.847440079";
startup force;  #database will instansiate with the new spfile created from autobackukp

2. Start rman using the command file

rman target="/" @ rman_spfile_restore.cmd

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 13 08:15:28 2014

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

connected to target database: DUMMY (not mounted)

RMAN> shutdown abort;
2> set dbid 657566608;
3> startup  force nomount; # starting the database in mount mode
4> restore spfile from "+DATA/cvrman/backupset/2014_05_13/nnsnf0_tag20140513t080118_0.298.847440079";
5> startup force;  #database will instansiate with the new spfile created from autobackukp
6>
7>
8>
using target database control file instead of recovery catalog
Oracle instance shut down

executing command: SET DBID

startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/CVRMAN/spfileCVRMAN.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/CVRMAN/spfileCVRMAN.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/cvrman/spfilecvrman.ora
ORA-15173: entry 'spfilecvrman.ora' does not exist in directory 'cvrman'
ORA-06512: at line 4

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

Total System Global Area    1068937216 bytes

Fixed Size                     2260088 bytes
Variable Size                281019272 bytes
Database Buffers             780140544 bytes
Redo Buffers                   5517312 bytes

Starting restore at 13-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK

channel ORA_DISK_1: restoring spfile from AUTOBACKUP +DATA/cvrman/backupset/2014_05_13/nnsnf0_tag20140513t080118_0.298.847440079
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 13-MAY-14

Oracle instance started
database mounted
database opened

Total System Global Area     730714112 bytes

Fixed Size                     2256832 bytes
Variable Size                452984896 bytes
Database Buffers             272629760 bytes
Redo Buffers                   2842624 bytes

Recovery Manager complete.

3.Check the mode of the database

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

CVRMAN    READ WRITE