oracle11gR2 RAC开归档

11gR2 rac开归档：

11g RAC  更改归档模式   ASM


1.在节点1 cedb1上执行
[root@devnode1 ~]# su - grid
[grid@devnode1 ~]$
[grid@devnode1 ~]$
[grid@devnode1 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jun 9 05:42:20 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL>
SQL> select name from v$asm_diskgroup;

NAME
------------------------------
CRS
DATA
FAR

SQL> alter diskgroup data add directory '+FAR/ARCH1';

Diskgroup altered.


SQL> alter diskgroup data add directory '+DATA/ARC2';

Diskgroup altered.


执行完成后，退出ASM实例


2.正常关闭所有节点数据库
在一个节点上启动数据库到mount状态
SQL> STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
Database altered.


SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+FAR/ARCH1' SCOPE=both SID='cedb1';

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+FAR/ARCH2' SCOPE=SPFILE SID='cedb2';

System altered.


SQL> alter database open



SQL> archive log list
Database log mode Archive Mode
Automatic archival             Enabled
Archive destination +FAR/arch1
Oldest online log sequence 3
Next log sequence to archive   4
Current log sequence 4
SQL>

Cedb2
SQL> STARTUP
SQL> archive log list
Database log mode Archive Mode
Automatic archival             Enabled
Archive destination +FAR/arch2
Oldest online log sequence 1
Next log sequence to archive   2
Current log sequence 2
SQL>