因spfile修改错误导致数据库无法启动的恢复方法

  1.在pfile中写入两行内容，后面的参数会覆盖之前的参数生效
一行内容是spfile的信息
另外一行是要改回的原来值
ora10g@linux5 /home/oracle$cat $ORACLE_HOME/dbs/initora10g.ora
SPFILE= '/oracle/u01/app/oracle/product/10.2.0/db_1/dbs/spfileora10g.ora'
log_archive_start = false

2. 使用pfile启动数据库，是 log_archive_start参数生效
sys@ora10g>startup pfile = '$ORACLE_HOME/dbs/initora10g.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1266392 bytes
Variable Size             104860968 bytes
Database Buffers           58720256 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.


-- The End --