Encountered ORA-01078, LRM-00109, ORA-27046 SPFILE file File Corruption solved today when starting the database encountered
$ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.4.0-Production on Tue Jul 16 21:28:03 2013 Copyright (c) 1982,200 7, Oracle. all Rights Reserved. connected to an idle instance. SQL> startup nomount; ORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/rdcrmap/initrm/rdcrm/10.2.0/dbs/initrdcrm. ora 'try to create PFILESQL> create pfile from SPFILE; create pfile from spfile * ERROR at line 1: ORA-27046: file size is not a multiple of logical block sizeAdditional information: 1
The SPFILE file is damaged. Fortunately, PFILE is backed up before,
$ 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.
Therefore, backup is very important.