[oracle@node1 pfile]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 27 10:27:35 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> alter system set log_archive_dest_1='+archlog' scope=both;
alter system set log_archive_dest_1='+archlog' scope=both
*
1 :
ORA-32017: SPFILE
ORA-16179: SPFILE "log_archive_dest_1"
确实LOCATION
SQL> alter system set log_archive_dest_1='location=+archlog' scope=both;
SQL> alter system set log_archive_format='arch_%s_%t.arc' scope=both;
alter system set log_archive_format='arch_%s_%t.arc' scope=both
*
1 :
ORA-02095:
只能SPFILE
SQL> alter system set log_archive_format='arch_%s_%t.arc' scope=spfile;
SQL> alter system set log_archive_start=true;
alter system set log_archive_start=true
*
1 :
ORA-02095:
SQL> alter system set log_archive_start=true scope=spfile;
查看活动实例
SQL> col inst_name for a30
SQL> select * from v$active_instances;
INST_NUMBER INST_NAME
----------- ------------------------------
1 node1:MYRAC1
2 node2:MYRAC2
使用SPFILE文件启动的
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/myrac/spfilemyrac.ora
节点2也使用同一个文件启动的
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/myrac/spfilemyrac.ora
节点2参数文件得到立即更新
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=+archlog
log_archive_dest_10 string
SQL> shutdown immediate
ORA-01507:
ORACLE
SQL> startup mount
SQL> show parameter log
ORA-01034: ORACLE not available
SQL> shutdown immediate;
ORA-01012: not logged on
SQL> exit
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
[oracle@node1 pfile]$ export ORACLE_SID=MYRAC1
[oracle@node1 pfile]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 27 10:51:08 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-19905: log_archive_format must contain %s, %t and %r
SQL> show parameter log_archive
ORA-01034: ORACLE not available
SQL> host
[oracle@node1 pfile]$ pwd
/opt/oracle/database/admin/MYRAC/pfile
[oracle@node1 pfile]$ vi myrac1_pfile.ora
MYRAC2.__db_cache_size=75497472
MYRAC1.__db_cache_size=62914560
MYRAC1.__java_pool_size=4194304
MYRAC2.__java_pool_size=4194304
MYRAC1.__large_pool_size=4194304
MYRAC2.__large_pool_size=4194304
MYRAC2.__shared_pool_size=79691776
MYRAC1.__shared_pool_size=92274688
MYRAC1.__streams_pool_size=0
MYRA