DataGuard 日常维护
来源:互联网 发布:湖南工业大学网络认证 编辑:程序博客网 时间:2024/04/28 20:13
1.停止Standby
select process, status from v$managed_standby; --查看备库是否在应用日志进行恢复
alter database recover managed standby database cancel;
shutdown immediate;
shutdown immediate;
2.切换到只读模式
-----由shutdown模式切换到只读模式-------
startup nomount;
alter database mount standby database;
alter database open read only;
alter database mount standby database;
alter database open read only;
-----由应用日志模式切换到只读模式-------
alter database recover managed standby database cancel;-- 取消日志应用alter database open read only;
3.切换回管理恢复模式
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;-- 启动日志应用
alter database mount standby database;
alter database recover managed standby database disconnect from session;-- 启动日志应用
alter database recover managed standby database using current logfile disconnect from session;
4.主库和备库之间角色切换
4.1 主库切换为备库
alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby with session shutdown;-- 主库有会话连接的时候
shutdown immediate
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
shutdown immediate
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
4.2 从库切换为主库
alter database commit to switchover to primary;
shutdown immediate;
startup
alter system switch logfile;
shutdown immediate;
startup
alter system switch logfile;
5.备库自动使用主库传过来的日志进行恢复
alter database recover automatic standby database;
6.更改保护模式
alter database set standby database to maximize protection;
alter database set standby database to maximize availability;
alter database set standby database to maximize performancen;
alter database set standby database to maximize availability;
alter database set standby database to maximize performancen;
7.取消自动恢复模式
alter database recover managed standby database cancel;
alter database recover managed standby database finish;
alter database recover managed standby database finish force;
alter database recover managed standby database finish;
alter database recover managed standby database finish force;
0 0
- DataGuard日常维护
- 49、DataGuard日常维护
- DataGuard 日常维护
- Dataguard日常维护及故障解决
- Oracle 10g 物理Dataguard日常操作维护(一)
- Oracle 10g 物理Dataguard日常操作维护(二)
- Oracle 10g dataguard 物理备库日常维护
- Oracle 10g 物理Dataguard日常操作维护(一)
- Oracle 10g 物理Dataguard日常操作维护(二)
- 高可用性dataguard搭建和日常维护工作
- 日常维护
- dataguard日常管理
- dataguard日常管理
- dataguard日常操作
- 11g Dataguard维护手册
- Oracle DataGuard 常用维护命令
- VCS日常维护指导
- oracle数据库日常维护
- List去重
- iOS x,y坐标系两直线求交点
- ProDecoder
- 笨办法解决 datagrid中表头和表体不对齐问题
- SIP的几个主要标准协议
- DataGuard 日常维护
- 关于在eclipes中配置tomcat不能显示主页面问题
- android 开发环境搭建
- 边缘检测算法——图像处理
- rw_程序是怎样跑起来的 1-6章
- Android 6.0 运行时权限封装之路
- 欢迎使用CSDN-markdown编辑器
- Java中加载配置文件的方法总结
- C#调用dll提示"试图加载格式不正确的程序"解决方法(转)