Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup--从spfile 启动
ORACLE instance started.
Total System Global Area251658240 bytes
Fixed Size1218796 bytes
Variable Size83887892 bytes
Database Buffers163577856 bytes
Redo Buffers2973696 bytes
Database mounted.
Database opened.
实际上可以先create spfile from pfile = '
更简单些,比如上面的例子中需要去掉一个控制文件。当然此类问题是仁者见仁,智者见者。
总之一条,定期备份参数文件是相当有必要的!