Sunday, June 6, 2021

EPM Automate for Oracle Enterprise Performance Management Cloud and Setting up Daily Replication

 To replicate an environment, you use EPM Automate to copy the artifact snapshot created during the daily maintenance from the primary environment to the secondary environment.

Oracle performs routine maintenance on each environment on a daily basis. During this service maintenance, Oracle creates a maintenance snapshot by backing up the contents of the environment (existing data and artifacts, including user and role assignments from the identity domain).

To setup daily service replication:

  1. Create a script file that contains the following EPM Automate commands. This script replicates the application snapshot from the primary environment to the secondary environment.

    Note:

    Be sure to change the user name, password file, identity domain names, and service URLs. For information on creating an encrypted password file, see the encrypt command.
REM Sign in to the secondary instance
epmautomate login serviceAdmin secondaryPassword.epw secondary_URL secondaryDomain
REM Delete the existing artifact snapshot
epmautomate deletefile "Artifact Snapshot"
REM Copy the snapshot from the primary instance
epmautomate copysnapshotfrominstance "Artifact Snapshot" primaryPassword.epw primary_URL primaryDomain
REM Sign out of the secondary instance
epmautomate logout

2. Using a scheduler; for example, Windows Task Scheduler, schedule the execution of the script file so that it runs two hours from the beginning of the maintenance window.

3. Set identical Maintenance Window start time on both the primary and secondary environments. See Setting Service Maintenance Time in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators for more information.

No comments:

Post a Comment