Skip to main content

Oracle

Setting up Daily Replication Script for PBCS applications

One of the things that organizations tend to want or need during and after an implementation are application refreshes.

In this blog post, I have two environments, PROD (Source) and TEST (Target), which I have developed a script to facilitate end users to refresh TEST environment. This script should be run where EPMAUTOMATE was installed and it can be automate by using windows task scheduler on or cron jobs on Linux.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

By default Oracle Cloud runs full application backups every night and stores the Snapshots on the application inbox.

We will use the ‘Copysnapshotfrominstance’ command is used to move artifact snapshot across instances in cloud.

Sample Script:
@echo off
rem This script is useful to migrate Artifact Snapshot from Production to Test instance
rem Update the following parameters based on requirement
call epmautomate login Target_user Target_password Target_url Target_Domain.
timeout 10
epmautomate recreate –f
epmautomate deletefile “Artifact Snapshot”
call epmautomate copysnapshotfrominstance Artifact Snapshot Source_password Source._URL Source_Domain
timeout 8
call epmautomate importsnapshot Artifact Snapshot
timeout 10
call epmautomate logout

Reference(s)
https://docs.oracle.com/cloud/latest/epm-common/CEPMA/epm_automate_command_ref_general.htm#CEPMA-GUID-5400C490-264F-493A-9EAD-267AB2A320F1

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Eddie Cisneros, Lead Technical Consultant

Technology and business visionary with 15+ year leading the design, development and implementation of Enterprise Performance Management System solutions. Strong record of success in resolving client issues with Hyperion Products proven ability to bring the benefits of IT to solve business issues while delivering application, infrastructure, costs and risks. Provide strategic direction to senior leadership on technology. Led innovation project for infrastructure delivery to improve the delivery Enterprise Performance Management Solution.

More from this Author

Categories
Follow Us
TwitterLinkedinFacebookYoutubeInstagram