Oracle

Archive PBCS Snapshots to Amazon S3 Cloud Storage

Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to archive snapshot files extracted from Oracle Planning and Budgeting Cloud Service (PBCS). In the following paragraphs, I will use the AWS Command Line interface (CLI) to upload to the Amazon S3 bucket to archive backup files pulled down from a PBCS instance. This will make automating your backup process faster, more reliable, and more programmatic. You can use this information to build a scheduled task (or cron job) to handle your backup operations assuming that an AWS administrator provides S3 bucket information.

 

 

The following procedure will demonstrate download, install and configuration Command Line InterfaceWindows download

To install the AWS CLI using the MSI installer

  1. Download the appropriate MSI installer.

Note

The MSI installer for the AWS CLI does not work with Windows Server 2008 (version 6.0.6002). Use pip to install with this version of Windows.

  1. Run the downloaded MSI installer.
  2. Follow the instructions that appear.

The CLI installs to C:\Program Files\Amazon\AWSCLI (64-bit) or C:\Program Files (x86)\Amazon\AWSCLI (32-bit) by default. To confirm the installation, use the aws –version command at a command prompt (open the START menu and search for “cmd” if you’re not sure where the command prompt is installed).

> aws –version

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

aws-cli/1.11.84 Python/3.5.2 Windows/7 botocore/1.5.47

Don’t include the prompt symbol (‘>’ above) when you type a command. These are included in program listings to differentiate commands that you type from output returned by the CLI. The rest of this guide uses the generic prompt symbol ‘$’ except in cases where a command is Windows-specific.

If Windows is unable to find the executable, you may need to re-open the command prompt or add the installation directory to your PATH environment variable manually.

AWS CLI configuration

On your windows server open command line
Type aws configure and press enter

Enter the information provided by your AWS administrator. Below an example of the credentials.csv file that is generated during the creation of the user

 

AWS Access Key ID[None]: enter the access key id form the credentails.csv
AWS Secret Access Key[None]: enter the Secret access Key from the credentials.csv
Default region name[None]: enter region where the bucket is located

Default output format[None]: enter json
JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write.
Add the following command at the end of the Oracle/PBCS script

                                          aws s3 cp “location of the file” s3://S3Bucket/

 

     aws s3 cp C:\Oracle\BackupScript\SupportNet\Backups\Archive\TEST_LCMEXPORT_20170524.zip s3://s3perficientbucket/

AWS console bucket view after a successful upload

About the Author

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

Leave a Reply

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

Subscribe to the Weekly Blog Digest:

Sign Up
Categories