『ORACLE』 Real-time Query(11g)
来源:互联网 发布:骑马与砍杀捏脸数据女 编辑:程序博客网 时间:2024/06/10 20:46
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY MOUNTED
取消应用日志
SQL> alter database recover managed standby database cancel;
Database altered.
打开数据库,打开后为read only模式
SQL> alter database open;
Database altered.
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
此时的状态即为read only with apply
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY
- 『ORACLE』 Real-time Query(11g)
- 11G real time query
- 体验一下Oracle 11g物理Active Data Guard实时查询(Real-time query)
- 【DataGuard】Oracle 11g物理Active Data Guard实时查询(Real-time query)特性
- 【DataGuard】Oracle 11g物理Active Data Guard实时查询(Real-time query)特性
- HDU Traffic Real Time Query System
- HDU3686 Traffic Real Time Query System
- 4839 -- Traffic Real Time Query System
- 11gR2 DataGuard standby开启实时查询(Real-time query)备份standby恢复报错:ORA-01194 ORA-01110
- uva 1464 - Traffic Real Time Query System(双联通+LCA)
- Hdu 3686 Traffic Real Time Query System(双联通分量+LCA)
- ORACLE 11G Flashback Versions Query
- 28msec - query data from any source in real time
- UVALive 4839 HDU 3686 Traffic Real Time Query System
- UVALive 4839 HDU 3686 Traffic Real Time Query System
- Oracle Dataguard之Real-Time Apply
- 10g dataguard的real-time apply与no real-time apply
- 一步一步跟我学习lucene(19)---lucene增量更新和NRT(near-real-time)Query近实时查询
- opencv 检测人脸、人眼
- Auto Ware 代码解析系列-pure_pursuit节点
- Virtualbox下XP虚拟机反复自动重启
- 原来Github上的README.md文件这么有意思——Markdown语言详解
- ButterKnife结合RecyclerView.Adapter一起使用
- 『ORACLE』 Real-time Query(11g)
- 关于闭包
- ubuntu安装php mysql apache2
- 年薪百万之路
- Java编程思想之网络编程(二)套接字Socket
- React Js Router 静态方法跳转 直接点到组件
- [POJ 2187]Beauty Contest:旋转卡壳
- 正则表达式总结与归纳
- cocoapods 创建方法