Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: Data guard: Re-synchronize standby database

    Hi all,

    I had a problem with a standby database, it was off during several days.
    Now there is a gap of more than one week between the primary and standby.

    I have all the archive logs generated during those days.

    The question iso I have to manually copy all archive logs to be applied on standby or the archiver can do that for me ?
    I mean to copy remaining archive logs to standby and then apply them.
    How do I instruct archiver to copy archives from primary to standby?

    Thanks a lot

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool By hand?

    If archiver did not copy them automatically when created, you need to copy manually.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2005
    Posts
    67
    Hi,

    I checked alert log of standby and found the following:

    FAL[client]: Failed to request gap sequence
    GAP - thread 1 sequence 4240-4294
    DBID 767729917 branch 705494287
    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.

    FAL is not configured, but I cannot stop the primary database.
    Is it mandatory to have FAL client and server configured to automastically resolve gaps ?

    Thanks

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Dynamic parms

    FAL_SERVER and FAL_CLIENT are dynamic parameters that can be set with "ALTER SYSTEM" -- no recycle db necessary.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •