熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

遭遇ORA-01078,LRM-00109,ORA-27046 SPFILE文件損壞解決

2022-06-13   來源: Oracle 
今天在啟動數據庫時遭遇到
    $ 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
    所以備份很重要
From:http://tw.wingwit.com/Article/program/Oracle/201311/17592.html
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.