4 Replies Latest reply on Oct 4, 2019 4:28 AM by Beauty_and_dBest

    EBS R12  BCP (Business Continuity Plan)

    Beauty_and_dBest

      EBS R12

      11g/12c

      OL6

       

      Hi ALL,

       

      Anybody here able to implement BCP for EBS?

       

      Does it mean using Dataguard on the database tier?

       

      How do you perform test for switching to standby database in EBS?

      I understand to switch to standby EBS instance, you need to run the following tasks?

       

      1. Truncate the following tables:

       

          truncate table applsys.fnd_oam_context_files;

          truncate table applsys.fnd_nodes;

          truncate table applsys.adop_valid_nodes;

       

      2. Run AutoConfig on the DB tier

       

          Confirm Autoconfig completes successfully

       

      3. Run AutoConfig on the run file system.

       

          Confirm AutoConfig completes successfully

       

      4. Run AutoConfig on the patch file system

       

          Before running AutoConfig on the patch file system the ebs_logon trigger MUST be disabled

          After the successful completion of AutoConfig the ebs_logon trigger MUST be re-enabled.

       

          This needs to be done as the SYSTEM schema user.

       

          4.1. Disable the ebs_login trigger using the following SQL.

       

                SQL> alter trigger ebs_logon disable;

       

                At this time Run AutoConfig with the patch environment variables sourced.

                Make sure AutoConfig completes successfully

       

          4.2. Enable the ebs_logon trigger using the following SQL.

       

                SQL> alter trigger ebs_logon enable;

       

       

      Please help how to setup switch to standby database.

       

       

      Kind regards,