遭遇ORA-01078，LRM-00109，ORA-27046 SPFILE文件损坏解决

今天在启动数据库时遭遇到

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 21:28:03 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/rdcrmap/oracrm/rdcrm/10.2.0/dbs/initrdcrm.ora'
试着用SPFILE 创建PFILE
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

遭了，SPFILE 文件损坏了，还好之前备份了PFILE，

$ cp initrdcrm.ora0914 initrdcrm.ora
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 21:30:37 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> create spfile from pfile;

File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size                  2044032 bytes
Variable Size            1107300224 bytes
Database Buffers         2097152000 bytes
Redo Buffers               14729216 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.