立即登录 马上注册
首页 › 开发帮助文档 › 数据库 › 详解Oracle dg 三种模式切换

赞

评论

收藏

[Oracle] 详解Oracle dg 三种模式切换

数据库 数据库 发布于：2022-01-27 12:04 | 阅读数：249 | 评论：0

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 三种模式切换的相关知识，希望大家喜欢。

关注下面的标签，发现更多相似文章
免责声明：

1. 本站所有资源来自网络搜集或用户上传，仅作为参考不担保其准确性！

2. 本站内容仅供学习和交流使用，版权归原作者所有！© 查看更多

3. 如有内容侵害到您，请联系我们尽快删除，邮箱：kf@codeae.com

分享到： QQ好友和群QQ好友和群 QQ空间QQ空间

举报

返回列表
相关帖子
avatar
3253 经验
3251 文档
OPNE在线字典
  • 手机版| 免责声明|
2021-2024  版权所有：CodeAE代码之家   
粤ICP备2023096576号-2