This discussion is archived
2 Replies Latest reply: Mar 19, 2013 8:43 AM by mseberg RSS

Gap Detection & Resolution

991261 Newbie
Currently Being Moderated
Hello all,

I have one query regarding Gap detection & resolution.

1) On a 10.2.0.4 DB with physical standby, gap detection and resolution happened using automatic gap resolution without setting FAL_server and FAL_Client on the standby. So I would like to know why should one set the said parameters?

Thanks and regards
  • 1. Re: Gap Detection & Resolution
    user11982706 Newbie
    Currently Being Moderated
    Well, please refer to below link

    http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1268281

    it's says that automatic gap resolution doesn't require any setting but primary should be available. For FAL_SERVER, you can specify name for other standby by , oracle stream also from where you can get the archive log too, in case primary not available for some reason.


    Thanks

    Yogesh
    http://orasteps.wordpress.com/
  • 2. Re: Gap Detection & Resolution
    mseberg Guru
    Currently Being Moderated
    Hello;

    On Oracle 10 FAL_SERVER and FAL_CLIENT are only required if the other parameter is specified.

    When a database is running in the standby role, it uses FAL_SERVER from which to fetch (request) missing archived redo log files if Primary is unable to automatically send the missing log files.

    Best Regards

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points