oracle数据库,服务器异常断电,导致数据库不能启动。。。。
错误提示:
SQL> startup ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initsznfpt.ora
解决方案:
服务器异常断电导致的文件丢失,恢复即可。 cp -a $ORACLE_BASE/admin/pfile/initxxx.ora $ORACLE_HOME/dbs/init<sid>.ora
01、进入sid保留的init
echo $ORACLE_SID //查看当前sid
cd $ORACLE_BASE/admin/<sid>/pfile
init.ora.1131201617420 ----> init<sid>.ora
02、复制init<sid>.ora到dbs/pfile中
/u01/app/oracle/product/11.2.0/db_1/dbs/pfile/
initsznfpt.ora
03、启动数据库实例
sqlplus / as sysdba;
SQL> startup
ORACLE instance started.
Total System Global Area 6680915968 bytes
Fixed Size 2213936 bytes
Variable Size 3556771792 bytes
Database Buffers 3087007744 bytes
Redo Buffers 34922496 bytes
Database mounted. Database opened.