|
今天在启动数据库时遭遇到 $ sqlplus / as sysdba SQL*Plus: Release Production on Tue Jul :: Copyright （c） Oracle All Rights Reserved Connected to an idle instance SQL> startup nomount; ORA: failure in processing system parameters LRM: could not open parameter file /rdcrmap/oracrm/rdcrm//dbs/initrdcrmora 试着用SPFILE 创建PFILE SQL> create pfile from spfile; create pfile from spfile * ERROR at line : ORA: file size is not a multiple of logical block size Additional information: 遭了SPFILE 文件损坏了还好之前备份了PFILE $ cp initrdcrmora initrdcrmora $ sqlplus /nolog SQL*Plus: Release Production on Tue Jul :: Copyright （c） 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 bytes Fixed Size bytes Variable Size bytes Database Buffers bytes Redo Buffers bytes SQL> alter database mount; Database altered SQL> alter database open; Database altered 所以备份很重要 |
