1 Reply Latest reply: Mar 20, 2013 1:18 PM by mseberg RSS

    FAL related questions

    998139
      Hello,

      Can you please clarify on the below query?

      1)Is FAL a method to resolve archive gaps?

      2) Is it mandatory to set FAL_SERVER & FAL_CLIENT on the standby database? Can Gap detection & resolution be possible without FAL process?

      3) Is FAL a server process or background process? How to view FAL process from O/S?

      4) The FAL method of Gap Resolution is implemented by the MRP process on the standby during Log Apply processing . Automatic Gap Resolution is implemented during log transport processing. Am I correct in my understanding?

      Any help will be highly appreciated.

      With regards
        • 1. Re: FAL related questions
          mseberg
          Hello;
          1)Is FAL a method to resolve archive gaps?
          The Fetch Archive Log Process (FAL) is a background Oracle process that runs on the primary database server.

          The Standby can initiate requests to the FAL server process to send the missing archived redo logs if needed.
          2) Is it mandatory to set FAL_SERVER & FAL_CLIENT on the standby database? Can Gap detection & resolution be possible without FAL process?
          No. They are required if you set one or the other. FAL_CLIENT is not required in Oracle 11. In RAC systems I would always set them.

          Yes, you can manaully resolve gap by registering a log file.
          3) Is FAL a server process or background process? How to view FAL process from O/S?
          Server process. FAL Archiver processes

          No idea. In the alert log you might see :

          ARC3: Becoming the ‘no FAL’ ARCH

          4) The FAL method of Gap Resolution is implemented by the MRP process on the standby during Log Apply processing . Automatic Gap Resolution is implemented during log transport processing. Am I correct in my understanding?
          FAL Gap Resolution is tied to MRP.

          Automatic Gap Resolution is implemented during log transport processing.

          See

          Data Guard Gap Detection and Resolution [ID 232649.1]


          Best Regards

          mseberg