事在人为
全部博文(10)
分类: Oracle
2013-03-07 09:34:16
各节点均建立归档目录,例如:
实例一:本地/rac1_arch 节点一/rac1_arch
实例二:本地/rac2_arch 节点二/rac2_arch
配置每个实例的归档位置:
alter system set log_archive_dest_1='location=/rac2_arch' scope=spfile sid='rac2';
alter system set log_archive_dest_2='service=rac1' scope=spfile sid='rac2';
alter system set log_archive_dest_1='location=/rac1_arch' scope=spfile sid='rac1';
alter system set log_archive_dest_2='service=rac2' scope=spfile sid='rac1';
alter system set standby_archive_dest='/rac2_arch' scope=spfile sid=‘rac1';
alter system set standby_archive_dest='/rac1_arch' scope=spfile sid=’rac2';
修改归档模式:
alter system set cluster_database=false scope=spfile sid='*';
shutdown immediate
startup mount
alter database archivelog
alter system set cluster_database=true scope=spfile sid='*';
重启数据库
查看归档是否生效:
archive log list;
手工归档:
alter system switch logfile;
查看各节点的归档目录中都能收到日志吗