在设置DATA GUARD 时，修改了系统参数，重启数据库后出错：
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
SQL> alter system set log_archive_dest_1='+RECOVERY/racdb/archivelog/' scope=spfile;
alter system set log_archive_dest_1='+RECOVERY/racdb/archivelog/' scope=spfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 19 Serial number: 48797
计划从spfile 生成pfile 文件：
[oracle@rac1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 19 11:42:10 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connetc / as sysdba
SP2-0734: unknown command beginning "connetc / ..." - rest of line ignored.
SQL> connect /as sysdba
Connected to an idle instance.
create pfile='init.ora' 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
出错，找不到文件和目录，我环境为RAC+ASM.
指定文件
File created.
SQL> startup pfile='init.ora';
LRM-00109: could not open parameter file 'init.ora'
ORA-01078: failure in processing system parameters
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup pfile='/opt/app/oracle/product/11.2.0/dbs/init.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.
Total System Global Area 3.2603E+10 bytes
Fixed Size 2214816 bytes
Variable Size 1.8254E+10 bytes
Database Buffers 1.4227E+10 bytes
Redo Buffers 120008704 bytes
Database mounted.
Database opened.
把pfile 修改回以前文件。
[root@rac1 dbs]# cp initracdb1.ora.org initracdb1.ora
cp：是否覆盖“initracdb1.ora”? y
（修改前有备份此文件）
[root@rac1 dbs]# cat initracdb1.ora
SPFILE='+DATA/racdb/spfileracdb.ora'
再重新建立 SPFILE:
create spfile='+data/racdb/spfileracdb.ora' from pfile='/opt/app/oracle/product/11.2.0/dbs/init.ora';
(
要指定pfile 具体文件。不然生成pfile 无效，
我在这里错了。出现错误：
ORA-01506: missing or illegal database name
)
指定数据库启动时加载参数文件的路径
alter system set spfile='+DATA/ORCL/spfileorcl.ora';
