The most shortcut for recovering spfile through Rman

First, Sqlplus nomount database and restore SPFile

Sql> Startup

Ora-01078:failure in processing system parameters

LRM-00109: Unable to open parameter file ' E:\ORACLE\11_2_0\DATABASE\INITXFF. ORA '

rman> restore SPFile to ' E:\oracle\11_2_0\database\spfilexff.ora '

2> from ' F:\rmanbackup\20111113_0KMRIT19_1_1 ';

Start Restore in 1 April-November-11

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

Rman-00601:fatal Error in Recovery manager

RMAN-03004: A fatal error occurred during command execution

RMAN-10041: Cannot recreate the polling channel context after a failure.

RMAN-10024: An error occurred while setting up RPC polling

RMAN-10005: Error opening cursor

Rman-10002:oracle Error: Ora-03114:not connected to ORACLE

Rman-03002:restore command (on 11/14/2011 22:23:24) failed

ORA-03113: End of file for communication channel

Process id:2884

Session id:97 Serial Number: 1

1, no Spfilexff.ora/initxff.ora/init.ora files, Sqlplus can not start the database to Nomount state

2, in the database is not nomount state, can not restore SPFile

Ii. Rman nomount database and restore SPFile

Rman> Startup

Connected to target database (not started)

Startup failed: Ora-01078:failure in processing system parameters

LRM-00109: Unable to open parameter file ' E:\ORACLE\11_2_0\DATABASE\INITXFF. ORA '

Start an Oracle instance to retrieve SPFile without a parameter file

Oracle instance started

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:startup command (on 11/14/2011 22:00:32) failed

ORA-00205: Error identifying the control file, check the alert log for more information

rman> restore SPFile to ' E:\oracle\11_2_0\database\spfilexff.ora '

2> from ' F:\rmanbackup\20111113_0KMRIT19_1_1 ';

Start Restore in 1 April-November-11

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=10 Device Type =disk

Channel Ora_disk_1: Restoring from Autobackup F:\rmanbackup\20111113_0KMRIT19_1_1 spfile

Channel ora_disk_1: Restore from Autobackup SPFILE completed

Completed restore in 1 April-November-11

1, Rman will use an implied (default parameter file to start the database to Nomount State)

2, in the Nomount state, Rman can restore SPFile

Third, the Rman starts the database log

Mon Nov 14 22:00:26 2011

Starting ORACLE instance (restrict)

license_max_session = 0

license_sessions_warning = 0

Picked Latch-free SCN Scheme 2

Using log_archive_dest_1 parameter default value as E:\oracle\11_2_0\RDBMS

Autotune of undo retention is turned on.

Imode=br

Ilat =18

License_max_users = 0

SYS Auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production

With the partitioning, Oracle Label security, OLAP, Data Mining,

Oracle Database Vault and real application testing options.

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Using parameter settings in Client-side pfile C:\S5O4.1 on machine xifenfei-pc

System parameters with Non-default values:

Sga_target = 152M

compatible = "11.2.0.1.0"

_dummy_instance = TRUE

Remote_login_passwordfile= "EXCLUSIVE"

db_name = "Xff"

Mon Nov 14 22:00:27 2011

Pmon started with pid=2, OS id=2932

Mon Nov 14 22:00:28 2011

Vktm started with pid=3, OS id=4364 at elevated priority

Vktm running at (a) Millisec precision with DBRM Quantum (MB) MS

Mon Nov 14 22:00:29 2011

GEN0 started with pid=4, OS id=4524

Mon Nov 14 22:00:30 2011

DIAG started with pid=5, OS id=5472

Mon Nov 14 22:00:30 2011

DBRM started with pid=6, OS id=5296

Mon Nov 14 22:00:30 2011

PSP0 started with pid=7, OS id=6120

Mon Nov 14 22:00:30 2011

DIA0 started with pid=8, OS id=4528

Mon Nov 14 22:00:30 2011

Mman started with pid=9, OS id=6052

Mon Nov 14 22:00:30 2011

DBW0 started with pid=10, OS id=5348

Mon Nov 14 22:00:30 2011

LGWR started with pid=11, OS id=4904

Mon Nov 14 22:00:30 2011

CKPT started with pid=12, OS id=5388

Mon Nov 14 22:00:30 2011

Smon started with pid=13, OS id=4492

Mon Nov 14 22:00:30 2011

Reco started with pid=14, OS id=576

Mon Nov 14 22:00:30 2011

Mmon started with pid=15, OS id=6072

Mon Nov 14 22:00:30 2011

MMNL started with pid=16, OS id=5720

Oracle_base from environment = E:\oracle

Mon Nov 14 22:00:31 2011

ALTER DATABASE Mount

Ora-00210:cannot Open the specified control file

Ora-00202:control file: ' E:\ORACLE\11_2_0\DATABASE\CTL1XFF. ORA '

Ora-27041:unable to open File

OSD-04002: Unable to open file

O/s-error: (OS 2) The system could not find the specified file.

ORA-205 signalled During:alter database mount ...

Mon Nov 14 22:00:33 2011

Checker Run found 1 new persistent data failures

1, see the system did not find C:\S5O4.1 files

2, Restrict way Nomount database