详解Oracle dg 三种模式切换-巨人网络通讯

详解Oracle dg 三种模式切换

oracle dg 三大模式切换

===================================
1 最大性能模式MAXIMUM PERFORMANCE ------默认模式
===================================

一最大性能模式特点

192.168.1.181
SQL> select database_role,protection_mode,protection_level from v$database;
DATABASE_ROLE  PROTECTION_MODE   PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY     MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_config          string   dg_config=(orcl,db01)
log_archive_dest_1          string   location=/home/oracle/arch_orc
                         l valid_for=(all_logfiles,all_
                         roles) db_unique_name=orcl
log_archive_dest_2          string   service=db_db01 LGWR ASYNC val
                         id_for=(online_logfiles,primar
                         y_roles) db_unique_name=db01
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   31
Next log sequence to archive  33
Current log sequence      33
192.168.1.183
SQL> select database_role,protection_mode,protection_level from v$database;
DATABASE_ROLE  PROTECTION_MODE   PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_config          string   dg_config=(db01,orcl)
log_archive_dest_1          string   location=/home/oracle/arch_db0
                         1 valid_for=(all_logfiles,all_
                         roles) db_unique_name=db01
log_archive_dest_2          string   service=db_orcl LGWR ASYNC val
                         id_for=(online_logfiles,primar
                         y_roles) db_unique_name=orcl
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   31
Next log sequence to archive  33
Current log sequence      33
192.168.1.181
SQL> alter system switch logfile;
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   32
Next log sequence to archive  34
Current log sequence      34
192.168.1.183
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_db01
Oldest online log sequence   32
Next log sequence to archive  0
Current log sequence      34

===================================
2 最大性能模式--切换到-->最大高可用 (默认是最大性能模式---MAXIMUM PERFORMANCE)
===================================

192.168.1.181
SQL> select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database; 
DATABASE_ROLE  PROTECTION_MODE   PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY     MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> show parameter log_archive_dest_2
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2          string   service=db_db01 LGWR ASYNC val
                         id_for=(online_logfiles,primar
                         y_roles) db_unique_name=db01
192.168.1.181
SQL> shutdown immediate
192.168.1.183
SQL> alter database recover managed standby database cancel;
SQL> shutdown immediate
192.168.1.181
SQL> startup mount;
SQL> alter database set standby database to maximize availability;
SQL> alter system set log_archive_dest_2='service=db_db01 LGWR SYNC valid_for=(online_logfiles,primary_roles) db_unique_name=db01' scope=spfile;
192.168.1.183
SQL> startup nomount
SQL> alter database mount standby database;
SQL> alter system set log_archive_dest_2='service=db_orcl LGWR SYNC valid_for=(online_logfiles,primary_roles) db_unique_name=orcl' scope=spfile;
SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
192.168.1.181
SQL> startup
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive_dest_2
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2          string   service=db_db01 LGWR SYNC vali
                         d_for=(online_logfiles,primary
                         _roles) db_unique_name=db01
SQL> select database_role,protection_level,protection_mode from v$database;
DATABASE_ROLE  PROTECTION_LEVEL   PROTECTION_MODE
---------------- -------------------- --------------------
PRIMARY     MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   34
Next log sequence to archive  36
Current log sequence      36
192.168.1.183
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive_dest_2
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2          string   service=db_orcl LGWR SYNC vali
                         d_for=(online_logfiles,primary
                         _roles) db_unique_name=orcl
SQL> select database_role,protection_level,protection_mode from v$database;
DATABASE_ROLE  PROTECTION_LEVEL   PROTECTION_MODE
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_db01
Oldest online log sequence   35
Next log sequence to archive  0
Current log sequence      36
192.168.1.181
SQL> alter system switch logfile;
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   35
Next log sequence to archive  37
Current log sequence      37
192.168.1.183
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_db01
Oldest online log sequence   36
Next log sequence to archive  0
Current log sequence      37

===================================
3 最大高可用--切换到-->最保护能模式
===================================

DG最大保护模式Maximum protection

192.168.1.181
SQL> shutdown immediate
192.168.1.183
SQL> shutdown immediate
192.168.1.181
SQL> alter database set standby database to maximize protection;
SQL> shutdown immediate
192.168.1.183
SQL> startup nomount
SQL> alter database mount standby database;
192.168.1.181
SQL> startup
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive_dest_2
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2          string   service=db_db01 LGWR SYNC vali
                         d_for=(online_logfiles,primary
                         _roles) db_unique_name=db01
SQL> select database_role,protection_level,protection_mode from v$database;
DATABASE_ROLE  PROTECTION_LEVEL   PROTECTION_MODE
---------------- -------------------- --------------------
PRIMARY     MAXIMUM PROTECTION  MAXIMUM PROTECTION
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   37
Next log sequence to archive  39
Current log sequence      39
192.168.1.183
SQL> col dest_name for a25
SQL> select dest_name,status from v$archive_dest_status;
DEST_NAME         STATUS
------------------------- ---------
LOG_ARCHIVE_DEST_1    VALID
LOG_ARCHIVE_DEST_2    VALID
SQL> show parameter log_archive_dest_2
NAME                 TYPE    VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2          string   service=db_db01 LGWR SYNC vali
                         d_for=(online_logfiles,primary
                         _roles) db_unique_name=db01
SQL> select database_role,protection_level,protection_mode from v$database;
DATABASE_ROLE  PROTECTION_LEVEL   PROTECTION_MODE
---------------- -------------------- --------------------
PRIMARY     MAXIMUM PROTECTION  MAXIMUM PROTECTION
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_db01
Oldest online log sequence   37
Next log sequence to archive  0
Current log sequence      39
192.168.1.181
SQL> alter system switch logfile;
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_orcl
Oldest online log sequence   38
Next log sequence to archive  40
Current log sequence      40
192.168.1.183
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination      /home/oracle/arch_db01
Oldest online log sequence   37
Next log sequence to archive  0
Current log sequence      40

附：Oracle DG管理模式和只读模式相互切换

将standby数据库开启至只读模式(用于primary非常忙时，可以在standby跑一些报表)

$sqlplus “/as sysdba”
SQL>startup mount
SQL>alter database open read only;
[@more@]

将只读模式standby数据库切换至管理模式

$sqlplus “/as sysdba”
SQL>alter database recover managed standby database disconnect from session;

将管理模式的standby数据库切换至只读模式

$sqlplus “/as sysdba”
SQL>alter database recover managed standby database cancel;
SQL>alter database open read only;

以上内容给大家介绍了Oracle dg 三种模式切换的相关知识，希望大家喜欢。

您可能感兴趣的文章:

DBCA命令行搭建Oracle ADG的流程
Oracle 给rac创建单实例dg并做主从切换功能
Oracle 10g DG 数据文件迁移的实现
Oracle数据库 DGbroker三种保护模式的切换
win平台oracle rman备份和删除dg备库归档日志脚本
Oracle区别ADG与DG案例详解

上一篇：Oracle数据库 DGbroker三种保护模式的切换
下一篇：Linux中Oracle的sqlplus下退格和Del键无效的问题解决

详解Oracle dg 三种模式切换

oracle dg 三大模式切换 =================================== 1 最大性能模式MAXIMUM PERFORMANCE ------默认模式 =================================== 一最大性能模式特点 192.168.1.181SQL select database_role,protection_mo详解,Oracle,三种,模式,切换,...

贵阳智能电销机器人系统（智能电销机器人资讯智能电

本文目次一览： 1、智能德律风呆板人哪个牌子好 2、人工智能德律风营销呆板人究竟能...

企业离不开400电话办理对于企业的巨大作用

商家在使用多年以来的400电话办理后，便会不舍抛开400电话办理了，原因是它实在太完...

甘肃外呼营销系统价格（免费销售外呼系统）

本篇文章给我们谈谈甘肃外呼营销体系价格，以及免费出售外呼体系对应的常识点，期...

如何成为深圳物联卡代理？

"代理”已经成各行各业中不可缺少的一个职业，它不仅可以帮助企业分销商品，更重要...

电销机器人效果怎么样云呼_电话机器人

【电销机器人效果怎么样】优质的话术源自于对智能外呼机器人逻辑的建立，机器人问...

郑州长春电销卡（长春卖卡）

本文目录一览：1、连连科技手机卡实名靠谱吗2、怎么注销在公司认证的电销卡号3、电...

白名单高频防封电销卡-电销卡怎么使用

中卡通信主营电销卡、防封电话卡、电销专用卡、高频不封外呼系统、呼叫中心、防封...

给员工解压的四种方式

美国的丹甘斯特教授及其研究生经调查研究得出：对于工作压力最有效的方法就是优化...

苏州防封电销线路办理服务商,外呼系统-服务为先

一企嗨电话营销系统 1．当前的电销场景有哪些困扰？ 1）手机.卡频繁被封，电销业务...

外呼系统属于违法吗（外呼系统犯法吗）

本文目录一览： 1、语音群呼（外呼）合法吗？什么是网关？2、语音外呼体系合法不...

外呼系统线路费用是多少钱（线路好的外呼系统）

本文目次一览： 1、外呼体系一个几何钱，有哪些功能？ 2、电销外呼体系几何钱一个月...

品牌资产的由来及其结构

世界各国真正对品牌的高度重视，始于20世纪80年末90年代初发生的几起大型并购案，其...

公司申请400电话流程详解：从申请到开通的全过程-公司

公司申请400电话流程详解：从申请到开通的全过程-公司申请400电话流程作为企业客服...

在ASP.NET 2.0中操作数据之七十二：调试存储过程

导言： Visual Studio有很多的调试功能.我们只需要稍稍点点鼠标，敲敲键盘就可以使用断...

呼叫中心智能机器人使用介绍

1、导入拨打数据【呼叫中心智能机器人使用介绍】然后，需要选择这次的呼叫模板。...

详解Oracle dg 三种模式切换

全 部 栏 目

全部栏目