遭遇ORA-01078，LRM-00109，ORA-27046 SPFILE文件损坏解决
今天在启动数据库时遭遇到
$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 21:28:03 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.SQL> startup nomount;ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/rdcrmap/oracrm/rdcrm/10.2.0/dbs/initrdcrm.ora'试着用SPFILE 创建PFILESQL> create pfile from spfile;create pfile from spfile*ERROR at line 1:ORA-27046: file size isoracle账号 not a multiple of logical block sizeAdditional information: 1
遭了，SPFILE 文件损坏了，还好之前备份了PFILE，
$ cp initrdcrm.ora0914 initrdcrm.ora$ sqlplus /nologSQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 21:30:37 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.SQL> conn /as sysdbaConnected to an idle instance.SQL> create spfile from pfile;File created.SQL> startup nomountORACLE instance started.Total System Global Area 3221225472 bytesFixed Size 2044032 bytesVariable Size 1107300224 bytesDatabase Buffers 2097152000 bytesRedo Buffers 14729216 bytesSQL> alter database mount;Database altered.SQL> alter database open;Database altered.
所以备份很重要