Skip to Content
author's profile photo Former Member
Former Member

Failed to request gap sequence

Dear All,

We are configuring DR site using oracle data guard, Physical Standby maximum protection. Our Oracle

release is 11.2.0.4, and using same release for DR site. Operating system is HP-Unix. We have configured

all the parameters at primary and DR site. We have successfully mounted DR database and log shipment

is working fine but unable to start recovery on DR database.

When we execute command:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Following error occur:

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -

FAL[client]: Failed to request gap sequence

GAP - thread 1 sequence 51568-51568

DBID 1210060169 branch 889027849

FAL[client]: All defined FAL servers have been attempted.

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization

parameter is defined to a value that is sufficiently large

enough to maintain adequate log switch information to resolve

archivelog gaps.

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Wed Aug 10 14:54:00 2016

RFS[6348]: Possible network disconnect with primary database

Wed Aug 10 14:54:08 2016

Killing 1 processes with pids 27492 (idle RFS by thread/sequence) in order to al

low the in-transit gap to be queued. Requested by OS process 27595

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -

After the above message we have verified almost all parameter and all parameter are absolutely

accurate.

Kindly suggest the solution.

Thanks and Best Regard

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 17, 2016 at 08:46 AM

    Hi Faisal,

    Recently I saw many standby issues. 😔

    Can you please attach the alert logs from both standby and primary database?

    Best regards,
    James

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.