FAL behavior on 11.2 (文档 ID 1394472.1)

In this Document

 Goal
 Fix


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Goal

This Document talks about how FAL request work on 11.2

Fix

In DG configuration if primary has only one standby then no need to mention the FAL parameter.

From 11.2 no need to mentione FAL_CLIENT primary will take it from log_archiver
_dest_n (remote destination standby from where it received the FAL request) service.

For example,

1. On standby MRP now waiting for GAP sequence 24.


SQL> select process,sequence#,status from v$managed_standby;

PROCESS SEQUENCE# STATUS
--------- ---------- ------------
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
MRP0 24 WAIT_FOR_GAP
RFS 0 IDLE
RFS 28 IDLE

7 rows selected.



2. The corresponding Alert log shows FAL fetching the GAP sequence.


-------------Standby Alert log-----------

Wed Nov 30 19:44:43 2011
Fetching gap sequence in thread 1, gap sequence 24-25


3. But FAL defined on standby,


SQL> show parameter fal;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string
fal_server string
SQL>


4. Standby received sequence 24-25 and now applying sequence 28.


SQL> select process,sequence#,status from v$managed_standby;

PROCESS SEQUENCE# STATUS
--------- ---------- ------------
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
MRP0 28 WAIT_FOR_LOG
RFS 0 IDLE
RFS 28 IDLE
RFS 0 IDLE
RFS 0 IDLE

9 rows selected.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值