环境:ORACLE 11.2.0.1 但实例的ASM存储
故障:由于修改数据库参数设置错误,重启数据库导致无法启动
解决步骤:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile='/tmp/pfile01.txt' from spfile;
create pfile='/tmp/pfile01.txt' from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> create pfile='/tmp/pfilehidb' from spfile='+hi_data/hidb/spfilehidb.ora';
File created.