# 43548
乐天
来自: beijing
|
|
To:
Data Gurad applied 不做
我在做oracle 9i 的data guard, primary DB 和 standby DB 都配置好了,分别启成了 primary database 和 physical standby DB.
我用 SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; 查看standby DB 节点,可以得到:
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
RFS RECEIVING
MRP0 WAIT_FOR_LOG
但是,用 SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;查看得到的却是:
SEQUENCE# APP
---------- ---
47 NO
48 NO
49 NO
50 NO
51 NO
52 NO
归档日志已经都能正常地归到 standby DB 节点上,是什么原因引起 APPLIED 没有完成呢. 我用的是 MAXIMIZE PERFORMANCE protection mode. 是因为 MAXIMIZE PERFORMANCE 保护模式就是滞后吗?
请盖老师和大家帮忙看看. 先谢谢了!
From: 乐天 2007.09.06 23:25
|
|
|
|
To: 乐天
[COLOR=blue]是不是没有启动自动恢复阿?[/COLOR]
From: eygle 2007.09.10 01:13
|
|
|
|
# 43544
zergduan
|
|
To:
您的新书循序渐进...第222页中
“这个临时空间使用需要等到 Session 退出后才能释放,那么在并非很高的情况下,中一个空间使用就将值得关注。”
这句话好像少写了一个字,我地理解应该是:
“这个临时空间使用需要等到 Session 退出后才能释放,那么在并[B]发[/B] 非很高的情况下,中一个空间使用就将值得关注。”
From: zergduan 2007.09.05 23:25
|
|
|
|
To: zergduan
[COLOR=blue]
并非 应该 改为 并发
谢谢指出,看得好快啊:)
[/COLOR]
From: eygle 2007.09.06 03:01
|
|
|
|
# 43542
chi
来自: Mexico
|
|
To: Eygle
More findings of my previous post about the "have no uniqueness constraints" in my alert log when the MV was refreshed BY FORCE. According to the 9i Data Warehousing doc, it states that "If there are outer joins, unique constraints must exist on the join columns of the inner table",However, that same statement is taken out from 10g R2 doc and the only statement about the REFRESH FORCE is "if the example did not include the columns times_rid and customers_rid, and if the refresh method was REFRESH FORCE, then this
materialized view would be fast refreshable only if the 'outer' table was updated, but note if the 'inner' tables were updated".So if my MV includes the row_id of both inner and outer table, the MV will be FORCE refreshable whenever either base table was updated.
From: chi 2007.09.05 11:48
|
|
|
|
# 43538
lsllcm
|
|
To: eygle
我们有个项目是从oracle9i升级到oracle 10.2.0.3,请问有什么兼容性的问题。
From: lsllcm 2007.09.04 22:24
|
|
|
|
To: lsllcm
[COLOR=blue]最主要要注意执行计划的变迁,严格充分的测试是必须的。[/COLOR]
From: eygle 2007.09.05 18:50
|
|
|
|
# 43537
mymmyy11
|
|
To:
请问eygle ,湖南长沙什么时候有你的大作<<循序渐进ORACLE>>买.我不想网上采购.
From: mymmyy11 2007.09.04 20:51
|
|
|
|
To: mymmyy11
[COLOR=blue]现在应该有卖了。[/COLOR]
From: eygle 2007.09.05 18:47
|
|
|
|
|