自己顶一下,,别沉 了 问题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 sequenceMESSAGE -------------------------------------------------------------------------------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 求解 大家不给力啊。。
问题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 sequenceMESSAGE
-------------------------------------------------------------------------------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