RAC开启归档

On By 去哪儿

1、查看ASM磁盘组

su – grid

sqlplus / as sysdba

select name,state from v$asm_diskgroup;

2、创建归档目录

因为磁盘组是共享的在任意以节点创建都可以

alter diskgroup ARCHDG add directory ‘+ARCHDG/arc1’;

alter diskgroup ARCHDG add directory ‘+ARCHDG/arc1”;

3、设置归档目录

rac1节点设置

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=+ARCHDG/ARC1′ SCOPE=SPFILE SID=’orcl1′;

rac2节点设置

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=+ARCHDG/ARC2′ SCOPE=SPFILE SID=’orcl2′;

4、两个节点关闭数据库

 shutdown immediate 或全部一起关闭 srvctl stop database -d orcl

5、设置归档模式

rac1和rac2设置

设置归档格式需要重启数据库

alter system set log_archive_format=’%t_%s_%r.arc’ scope=spfile; 

startup mount;

alter database archivelog;

archive log list;

alter database open;

6、查看日志是否生成

su – grid

asmcmd

ls

cd ARHCDG

cd ARC1

ls

查看命令

show parameter log_archive_dest_1;

show parameter log_archive_format;