oracle dataguard创建物理备库的时候需不需要恢复备库

[孙成]

我做实验，，做到查看同步的时候，老是不行，很郁闷，，我参考的三思笔记做的。。备库需不需要恢复啊，还是直接把文件拷过去就行。。求解。。。

[孙成]

自己顶一下，，别沉 了。。。
问题SELECT message FROM v$dataguard_status;

MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery starting Real Time Apply
Clearing online redo logfile 1 C:\ORACLE\PRODUCT\10.2.0\ORADATE\DG\REDO01.LOG
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 3
Fetching gap sequence in thread 1, gap sequence 3-3
FAL[client, MRP0]: Error 12514 connecting to web for fetching gap sequence
FAL[client, MRP0]: Error 12514 connecting to web for fetching gap sequence

MESSAGE
-------------------------------------------------------------------------------

FAL[client, MRP0]: Error 12514 connecting to web for fetching gap sequence
FAL[client, MRP0]: Error 12514 connecting to web for fetching gap sequence
FAL[client, MRP0]: Error 12514 connecting to web for fetching gap sequence
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 3-3
DBID 3035542104 branch 751887194
FAL[client]: All defined FAL servers have been attempted.

[孙成]

自己顶一下。。
上一个问题解决了。。是TNS没配置好。
又有新问题了。。
SELECT switchover_status FROM v$database;
主库是 SESSION ACTIVE
备库是 NOT ALLOWED
求解。。。
大家不给力啊。。

[孙成]

而正确的应该是
TO STANDBY
TO PRIMARY

[qq240971315]

悲剧啊，没人回答，还要自己上号来

[yao1248]

因为现在的模式是最大性能模式所以不行吧