Oracle 10g r2 rac + ASM 修改为归档状态

Oracle 10g r2 rac数据库修改归档到ASM1，asm上创建相关空间目录 export ORACLE_SID=+ASM1asmcmdmkdir arch1 arch2ASMCMDgt; p

oracle 10g r2 rac数据库修改归档到asm

1，，asm上创建相关空间目录
 export oracle_sid=+asm1
asmcmd
mkdir arch1 arch2

asmcmd> pwd
+data/racdb/archive
asmcmd> ls
arch1/
arch2/
asmcmd>

2，mount状态下，在一个节点修改

[oracle@rac1 software]$ export oracle_sid=racdb1
[oracle@rac1 software]$ sqlplus "/as sysdba"

sql*plus: release 10.2.0.1.0 - production on thu dec 30 10:21:41 2010

copyright (c) 1982, 2005, oracle.  all rights reserved.

connected to an idle instance.

sql> startup mount
oracle instance started.

total system global area  209715200 bytes
fixed size                  1218556 bytes
variable size             100665348 bytes
database buffers          104857600 bytes
redo buffers                2973696 bytes
database mounted.
sql> archive log list
database log mode              no archive mode
automatic archival             disabled
archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
oldest online log sequence     14
current log sequence           15
sql> alter system set log_archive_dest_1='location=+data/racdb/archive/arch1' sid='racdb1';

system altered.

sql> alter system set log_archive_dest_1='location=+data/racdb/archive/arch2' sid='racdb2';

system altered.

sql> show parameter cluster_database

name                                 type        value
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     true
cluster_database_instances           integer     2

sql> alter database archivelog;

database altered.

sql> alter database open;

database altered.

sql> archive log list
database log mode              archive mode
automatic archival             enabled
archive destination            +data/racdb/archive/arch1
oldest online log sequence     14
next log sequence to archive   15
current log sequence           15
sql> exit

3,启动另一个节点
[oracle@rac1 software]$ crs_start ora.racdb.racdb2.inst
attempting to start `ora.racdb.racdb2.inst` on member `rac2`
start of `ora.racdb.racdb2.inst` on member `rac2` succeeded.

4，验证是否成功
node2执行

sql> alter system archive log current;

system altered.

[oracle@rac2 ~]$ export oracle_sid=+asm2
[oracle@rac2 ~]$ asmcmd
asmcmd> ls
data/
asmcmd> cd +data/racdb/archive/arch2
asmcmd> ls
2_7_738946915.dbf