11g RAC 更改归档模式 ,归档文件存放在ASM 磁盘组

11g RAC  更改归档模式   ASM本实验有两个节点tip01,tip02oracle_sid 分别是 tips1,tips21.在节点1 tip01上执行[root@tip01 ~]# su - grid[grid@tip01 ~]$ sqlplus  / as  sysasmSQL> select name from v$asm_diskgroup;NAME------------------------------DATAOCRSQL> alter diskgroup data add directory '+DATA/ARC1';Diskgroup altered.2.在节点1 tip02上执行[root@tip01 ~]# su - grid[grid@tip01 ~]$ sqlplus  / as  sysasmSQL> select name from v$asm_diskgroup;NAME------------------------------DATAOCRSQL> alter diskgroup data add directory '+DATA/ARC2';Diskgroup altered.执行完成后，退出ASM实例3.在tip01上执行[grid@tip01 ~]$ su - oracle[oracle@tip01 ~]$ sqlplus  / as sysdbaSQL> SELECT INSTANCE_NAME FROM V$INSTANCE;INSTANCE_NAME----------------tips1SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC1' SCOPE=SPFILE SID='tips1';System altered.SQL>  ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA/ARC2' SCOPE=SPFILE SID='tips2';System altered.4.关掉所有节点实例tips1,tips2服务节点tip01上执行SQL> SHUTDOWN IMMEDIATE节点tip02上执行SQL> SHUTDOWN IMMEDIATE5.更改归档模式节点tip01上执行SQL> STARTUP MOUNTSQL>ALTER DATABASE ARCHIVELOG;Database altered.SQL> archive log listarchive log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            +DATA/arc1Oldest online log sequence     255Next log sequence to archive   256Current log sequence           256节点tip01已经更改成功节点tip02上执行SQL> STARTUP MOUNTSQL>ALTER DATABASE ARCHIVELOG;Database altered.SQL> archive log listarchive log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            +DATA/arc2Oldest online log sequence     255Next log sequence to archive   256Current log sequence           2566.打开数据库节点tip01,tip02上分别执行 SQL> alter database open7.验证归档文件节点tip01上执行SQL> alter system switch logfile;System altered.[oracle@tip01 ~]$ su - grid[grid@tip01 ~]$ asmcmdASMCMD> lsDATA/OCR/ASMCMD> cd DATAASMCMD> cd arc1ASMCMD> ls1_256_784611206.dbf节点tip01 已经有归档文件产生了