oracle RAC--归档日志的开启方法
来源:互联网 发布:淘宝站外展销活动 编辑:程序博客网 时间:2024/05/16 19:23
oracle RAC--归档日志的开启方法
==================================
10g R1 要修改cluster_database参数 ,10G R2和以后的版本就不需要了
1. 例子(10g R1或之前):
srvctl stop database -d RAC
节点1
sql>startup mount
SQL> alter system set log_archive_dest_1='location=/racdb1_arch' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_1='location=/racdb2_arch' scope=spfile sid='RAC2';
SQL> alter system set log_archive_dest_2='service=rac2' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_2='service=rac1' scope=spfile sid='RAC2';
SQL> alter system set standby_archive_dest='/racdb2_arch' scope=spfile sid='RAC1';
SQL> alter system set standby_archive_dest='/racdb1_arch' scope=spfile sid='RAC2';
sql>alter system set cluster_database=false scope=spfile;
sql>shutdown immediate
sql>startup mount
sql>alter database archivelog
sql>alter database open
sql>alter system set cluster_database=true scope=spfile;
sql>shutdown immediate
srvctl start database -d RAC
1. 例子(10g R1或之前):
srvctl stop database -d RAC
节点1
sql>startup mount
SQL> alter system set log_archive_dest_1='location=/racdb1_arch' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_1='location=/racdb2_arch' scope=spfile sid='RAC2';
SQL> alter system set log_archive_dest_2='service=rac2' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_2='service=rac1' scope=spfile sid='RAC2';
SQL> alter system set standby_archive_dest='/racdb2_arch' scope=spfile sid='RAC1';
SQL> alter system set standby_archive_dest='/racdb1_arch' scope=spfile sid='RAC2';
sql>alter system set cluster_database=false scope=spfile;
sql>shutdown immediate
sql>startup mount
sql>alter database archivelog
sql>alter database open
sql>alter system set cluster_database=true scope=spfile;
sql>shutdown immediate
srvctl start database -d RAC
2. 例子(10g R2或之后):
节点1
SQL>startup mount;
SQL> alter system set log_archive_dest_1='location=/racdb1_arch' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_1='location=/racdb2_arch' scope=spfile sid='RAC2';
SQL> alter system set log_archive_dest_2='service=rac2' scope=spfile sid='RAC1';
SQL> alter system set log_archive_dest_2='service=rac1' scope=spfile sid='RAC2';
SQL> alter system set standby_archive_dest='/racdb2_arch' scope=spfile sid='RAC1';
SQL> alter system set standby_archive_dest='/racdb1_arch' scope=spfile sid='RAC2';
srvctl stop database -d RAC
节点1
SQL> startup mount
SQL> alter database archivelog;
SQL> startup mount
SQL> alter database archivelog;
srvctl start database -d RAC
3. 测试归档日志的切换:
节点一,二上分别执行切换日志操作如下:
SQL> alter system switch logfile; 操作执行这条语句5次
节点一查询:
SQL> !ls -l /racdb*
/racdb1_arch:
total 1072
-rw-r----- 1 oracle oinstall 93696 Oct 7 08:57 1_82_762368314.dbf
-rw-r----- 1 oracle oinstall 980992 Oct 7 09:10 1_83_762368314.dbf
-rw-r----- 1 oracle oinstall 1536 Oct 7 09:10 1_84_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 1_85_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 1_86_762368314.dbf
/racdb1_arch:
total 1072
-rw-r----- 1 oracle oinstall 93696 Oct 7 08:57 1_82_762368314.dbf
-rw-r----- 1 oracle oinstall 980992 Oct 7 09:10 1_83_762368314.dbf
-rw-r----- 1 oracle oinstall 1536 Oct 7 09:10 1_84_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 1_85_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 1_86_762368314.dbf
/racdb2_arch:
total 980
-rw-rw---- 1 oracle oinstall 166400 Oct 7 08:56 2_57_762368314.dbf
-rw-rw---- 1 oracle oinstall 811520 Oct 7 09:10 2_58_762368314.dbf
-rw-rw---- 1 oracle oinstall 2560 Oct 7 09:10 2_59_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 2_60_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 2_61_762368314.dbf
total 980
-rw-rw---- 1 oracle oinstall 166400 Oct 7 08:56 2_57_762368314.dbf
-rw-rw---- 1 oracle oinstall 811520 Oct 7 09:10 2_58_762368314.dbf
-rw-rw---- 1 oracle oinstall 2560 Oct 7 09:10 2_59_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 2_60_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 2_61_762368314.dbf
节点二查询:
SQL> !ls -l /racdb*
/racdb1_arch:
total 1072
-rw-rw---- 1 oracle oinstall 93696 Oct 7 08:57 1_82_762368314.dbf
-rw-rw---- 1 oracle oinstall 980992 Oct 7 09:10 1_83_762368314.dbf
-rw-rw---- 1 oracle oinstall 1536 Oct 7 09:10 1_84_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 1_85_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 1_86_762368314.dbf
/racdb1_arch:
total 1072
-rw-rw---- 1 oracle oinstall 93696 Oct 7 08:57 1_82_762368314.dbf
-rw-rw---- 1 oracle oinstall 980992 Oct 7 09:10 1_83_762368314.dbf
-rw-rw---- 1 oracle oinstall 1536 Oct 7 09:10 1_84_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 1_85_762368314.dbf
-rw-rw---- 1 oracle oinstall 1024 Oct 7 09:10 1_86_762368314.dbf
/racdb2_arch:
total 980
-rw-r----- 1 oracle oinstall 166400 Oct 7 08:56 2_57_762368314.dbf
-rw-r----- 1 oracle oinstall 811520 Oct 7 09:10 2_58_762368314.dbf
-rw-r----- 1 oracle oinstall 2560 Oct 7 09:10 2_59_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 2_60_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 2_61_762368314.dbf
total 980
-rw-r----- 1 oracle oinstall 166400 Oct 7 08:56 2_57_762368314.dbf
-rw-r----- 1 oracle oinstall 811520 Oct 7 09:10 2_58_762368314.dbf
-rw-r----- 1 oracle oinstall 2560 Oct 7 09:10 2_59_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 2_60_762368314.dbf
-rw-r----- 1 oracle oinstall 1024 Oct 7 09:10 2_61_762368314.dbf
节点一:
SQL> show parameter archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/racdb1_arch
log_archive_dest_10 string
log_archive_dest_2 string service=rac2
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
standby_archive_dest string /racdb2_arch
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/racdb1_arch
log_archive_dest_10 string
log_archive_dest_2 string service=rac2
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
standby_archive_dest string /racdb2_arch
节点二:
SQL> show parameter archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/racdb2_arch
log_archive_dest_10 string
log_archive_dest_2 string service=rac1
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
standby_archive_dest string /racdb1_arch
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/racdb2_arch
log_archive_dest_10 string
log_archive_dest_2 string service=rac1
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
standby_archive_dest string /racdb1_arch
===========================================
0 0
- oracle RAC--归档日志的开启方法
- Oracle 11G RAC开启和关闭归档日志
- oracle 11g rac开启归档日志和闪回
- Oracle 11g RAC 开启、修改归档方法
- Oracle 11g RAC 开启、修改归档方法
- oracle归档日志的开启和关闭
- oracle开启自动日志归档
- oracle 归档日志开启,关闭
- ORACLE 开启归档日志功能
- oracle 开启关闭归档日志
- oracle 开启关闭归档日志
- oracle rac及单实例开启归档
- rac下最简单归档开启方法
- oralce RAC 归档日志的方式及RMAN备份方法
- 更改rac oracle归档日志路径
- oracle归档日志满的处理方法!
- ORACLE正确删除归档日志的方法
- ORACLE 正确删除归档日志的方法
- xen 网络设置
- Zookeeper集群环境安装过程详解
- 我们梦想新
- 第二章 D - Number Sequence(1.5.10)
- android Configuration系统设置
- oracle RAC--归档日志的开启方法
- 断言使用,调试宏定义
- 经纬财富:西安7月16日金银交易须知
- Unity3D——数据操作之PlayerPerfs
- Spring容器
- 项目管理用户需求分析
- Unexpected exception parsing XML document from class path resourcebean name 'cdWhEquipmentManager' f
- C++语言之标准IO库详解
- 【UVALive】3661 Animal Run 平面图最小割 最短路