『ORACLE』 DG切换主备库角色(11g)
来源:互联网 发布:mac与iphone照片同步 编辑:程序博客网 时间:2024/06/06 09:29
切换前enmo1为主库,enmo2为备库
[oracle@enmo1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat May 6 10:14:57 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
查看主库的基本信息:
SYS@enmo1 hey~1->select open_mode,protection_mode,database_role,switchover_status from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
-------------------- ----------------------------- ------------------------ ------------------------
READ WRITE MAXIMUM PERFORMANCE PRIMARY TO STANDBY
查看备库的基本信息:
SYS@enmo2 hey~2->select open_mode,protection_mode,database_role,switchover_status from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
------------------------- ----------------------------- ------------------------ ------------------------
READ ONLY WITH APPLY MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED
备库应用日志保持和主库数据一致(如果不一致,执行如下语句应用日志)
SYS@enmo2 hey~2->recover managed standby database using current logfile disconnect from session;
Media recovery complete.
SYS@enmo2 hey~2->recover managed standby database cancel;
Media recovery complete.
主库切换到备库角色并查看切换之后的状态为RECOVERY NEEDED
SYS@enmo1 hey~1->alter database commit to switchover to physical standby with session shutdown;
Database altered.
SYS@enmo1 hey~1->shutdown abort;
ORACLE instance started.
Total System Global Area 830930944 bytes
Fixed Size 2257800 bytes
Variable Size 700451960 bytes
Database Buffers 121634816 bytes
Redo Buffers 6586368 bytes
Database mounted.
SYS@enmo1 hey~1->select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
RECOVERY NEEDED
切换应用日志,然后在查看切换状态为TO primary正常:
SYS@enmo1 hey~1->recover managed standby database using current logfile disconnect from session;
Media recovery complete.
SYS@enmo1 hey~1->select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
备库切主库:
SYS@enmo2 hey~2->select open_mode,protection_mode,database_role,switchover_status from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
-------------------- -------------------- ---------------- --------------------
MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY TO PRIMARY
SYS@enmo2 hey~2->alter database commit to switchover to primary with session shutdown;
Database altered.
SYS@enmo2 hey~2->alter database open;
Database altered.
SYS@enmo2 hey~2->select switchover_status,database_role from v$database;
SWITCHOVER_STATUS DATABASE_ROLE
-------------------- ----------------
FAILED DESTINATION PRIMARY
SYS@enmo2 hey~2->select open_mode,protection_mode,database_role from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE
-------------------- -------------------- ----------------
READ WRITE MAXIMUM PERFORMANCE PRIMARY
- 『ORACLE』 DG切换主备库角色(11g)
- Oracle 11g Data Guard之主备库切换(switchover不使用DG Broker)
- 『ORACLE』 DG性能转换(11g)
- Oracle 11g Data Guard主备库角色切换
- 『ORACLE』DG之Snapshot Standby功能(11g)
- 『ORACLE』DG搭建时备库的db_name报错(11g)
- oracle 11g DG 搭建
- 【ORACLE】11g rac+dg
- oracle dg中角色切换后的序列测试
- [oracle]Oracle 11g 逻辑DG搭建
- 11g RAC+DG(Oracle Maximum Availability Architecture)
- Oracle 11g搭建DG(ADG方式)
- ORACLE 11G R2 DG BROKER 基础
- oracle dg主从切换
- oracle物理dg角色转换
- oracle 11g 权限--角色
- oracle 11g角色管理
- DG 物理Standby角色切换及Failover
- 索引
- php基础知识 12,文件操作函数库
- Scala 开发环境搭建和基础教程
- Ubuntu 16.04 OpenCV多版本冲突
- 909422229_JSP页面动态下拉菜单Ajax
- 『ORACLE』 DG切换主备库角色(11g)
- opencv 检测人脸、人眼
- Auto Ware 代码解析系列-pure_pursuit节点
- Virtualbox下XP虚拟机反复自动重启
- 原来Github上的README.md文件这么有意思——Markdown语言详解
- ButterKnife结合RecyclerView.Adapter一起使用
- 『ORACLE』 Real-time Query(11g)
- 关于闭包
- ubuntu安装php mysql apache2