当前位置:首页 > 开发 > 数据库 > 正文

Dataguard切换保护模式(从MAXIMUM PERFORMANCE 到 maximize availability)

发表于: 2014-10-05   作者:czmmiao   来源:转载   浏览次数:
摘要: 1. 首先查看主库当前保护模式(主库操作)SQL> select protection_mode,protection_level from v$database;PROTECTION_MODE      PROTECTION_LEVEL-------------------- --------------------MAXIMUM PERF

1. 首先查看主库当前保护模式(主库操作)
SQL> select protection_mode,protection_level from v$database;
PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE
2. 修改主库初始化参数(主库操作)
SQL> alter system set log_archive_dest_2='SERVICE=phystandby OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=phystandby'  ;
System altered.
具体参数修改,参照如下表格
Maximum Availability     Maximum Performance     Maximum Protection
AFFIRM
NOAFFIRM
AFFIRM
SYNC
ASYNC
SYNC
DB_UNIQUE_NAME
DB_UNIQUE_NAME
DB_UNIQUE_NAME
3.重启主库到mount
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area  422670336 bytes
Fixed Size                  1336960 bytes
Variable Size             348129664 bytes
Database Buffers           67108864 bytes
Redo Buffers                6094848 bytes
Database mounted.
4. 在主库修改保护模式为maximize availability,并打开数据库
SQL> alter database set standby database to maximize availability;
Database altered.
SQL> alter database open;
Database altered.
5. 校验主库保护模式
SQL> select protection_mode,protection_level from v$database;
PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
6. 查看备库保护模式
SQL> select protection_mode,protection_level from v$database;
PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
7. 修改备库保护模式(为数据库角色切换做铺垫)
SQL> alter system set log_archive_dest_2='service=phyprimary OPTIONAL LGWR SYNC AFFIRM valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=phyprimary';
System altered.

 

参考至:http://blog.sina.com.cn/s/blog_6a5aa0300102uzeb.html

如有错误,欢迎指正

邮箱:czmcj@163.com

Dataguard切换保护模式(从MAXIMUM PERFORMANCE 到 maximize availability)

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
译者前言 本文翻译自<Visual Studio Performance Testing Quick Reference Guide 3.6> 有关于
在查找资料的过程发现了一份关于linux内核启动的课件,在这里附上。(本笔记参考了众多资料,向原作
前面的文章提到,当用grid contorl中的broker页面配置的dataguard,进行switchover切换时,只需在页
Memcached is a high performance centralized cache system that stores data as key/value pair.
Posted By: Ali Hodroj on March 4, 2013 The following is Part 1 of 2 on architecting highly av
前几天将段式保护模式从理论上了解了。所以这几天就借助一些书籍和网络得力量来争取实践---将代码跳
这几天还是在学习《自己动手写操作系统》,终于将保护模式了了。 上来贴上代码: %include "pm.inc"
1. Definitions: -- Input : An edge-weighted digraph (edge capacity) , source vertex s, and ta
Host availability is 'gray' for agent [FOR HELP] I have added about 40 freeBSD servers as hos
single point of failure (SPOF) Removal 本文出自 “Ilovecat(个人笔记)” 博客,请务必保留此出处
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号