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;
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博客 ” ，链接：https://blog.itpub.net/29424472/viewspace-1254115/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
