Enable the real-time apply in 10G

原创 2011年01月13日 17:29:00

If you want the redo data to be applied as it is received without waiting for the current standby redo log file to be archived, enable the real-time apply.

To start real-time apply:
SQL> alter database recover managed standby database using current logfile disconnect;

But Maybe you will encourter the error like this:

SQL> startup mount;
ORACLE instance started.

Total System Global Area 196681728 bytes
Fixed Size 1298836 bytes
Variable Size 104861292 bytes
Database Buffers 83886080 bytes
Redo Buffers 6635520 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect;

*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
Use the following command to close the process first.
SQL> alter database recover managed standby database cancel
2 ;

Database altered.
You can view if the recover process is kicked off.
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS
2 FROM V$MANAGED_STANDBY;

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 59 1 246
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 1 60 0 0
RFS IDLE 1 60 827 6
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0

9 rows selected.

相关文章推荐

Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply [ID 343424.1]

Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply [ID 343424.1] Modified 14...

10g dataguard的real-time apply与no real-time apply

dg为最大可用性模式时,主库可能是通过LGWR或者ARCH传输日志到备库,当使用LGWR传到redo log到备库的standby redo log时,什么时候applied到备库时,有个概念叫:re...
  • jolly10
  • jolly10
  • 2013年08月01日 17:10
  • 556

DG的dataguard real time apply

Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply (文档 ID 343424.1) 转到底部 ...
  • loryliu
  • loryliu
  • 2014年06月15日 22:31
  • 985

有关Real-time Apply和FAL_SERVER字段的疑问

临近年关,今天对数据库及其备库进行了一些检查,发现颇多。 查看备库日志,发现如下信息 RFS[6]: No standby redo logfiles created 这个以前没见过。这个备...

关于DG配置备库无法Real-Time Apply,无法实时查询的一个案例

检查一下logfile是否一致 SQL> select group#,bytes/1024/1024 from v$log;     GROUP# BYTES/1024/1024 -----...

New Apache project will Drill big data in near real time

New Apache project will Drill big data in near real time Dremel-based project accepted as...
  • ldbkyo
  • ldbkyo
  • 2012年08月23日 12:54
  • 315

How to monitor Nginx web server from the command line in real time

Once Nginx web server is up and running in a production environment, you will want to monitor its ...
  • xluren
  • xluren
  • 2014年10月15日 21:58
  • 963

文献阅读笔记: Real-time Multiple Objects Tracking with Occlusion Handling in Dynamic Scenes ---by 香蕉麦乐迪

文献阅读笔记: Real-time Multiple Objects Tracking with Occlusion Handling in Dynamic Scenes ---by 香蕉麦乐迪 文章...

Real-time human pose recognition in parts from single depth images 中文翻译【译】【中译】微软kinect中用的算法

Real-time human pose recognition in parts from single depth images  中文翻译 本文中,我们专注于组件的姿势识别(we focus ...

Visual Odometry(视觉里程计): StereoScan Dense 3d Reconstruction in Real-time

介绍 系统概述 A特征匹配 Bego-motion估计 C立体匹配 D3D重建 实验结果 运行结果及代码介绍从多个二维图片中重建3D影像是机器视觉必不可少的部分,这篇论文【1】提出的就是做3D重建的工...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Enable the real-time apply in 10G
举报原因:
原因补充:

(最多只允许输入30个字)