参数文件SPFILE损坏，使用RMAN自动备份的参数文件进行恢复

Oracle数据库的参数文件SPFILE损坏之后，数据库无法启动

SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initprod.ora'

解决办法

1）手动编辑pfile参数文件initprod.ora
[oracle@oracle10g dbs]$ vi /u01/app/oracle/product/10.2.0/db_1/dbs/initprod.ora
内容写：db_name=prod

2）数据库启动到nomount状态
SQL> startup nomount

3）使用RMAN转储参数文件SPFILE
RMAN> restore spfile from '/database/backup/controlfile/c-267595630-20140819-02';

Starting restore at 19-AUG-14
using channel ORA_DISK_1

channel ORA_DISK_1: autobackup found: /database/backup/controlfile/c-267595630-20140819-02
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 19-AUG-14

4）关库，使用SPFILE启动数据库
SQL> shutdown immediate;
[oracle@oracle10g dbs]$ rm /u01/app/oracle/product/10.2.0/db_1/dbs/initprod.ora

SQL> startup nomount;
SQL> alter database mount;
SQL> alter database open;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29424472/viewspace-1254115/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29424472/viewspace-1254115/