How we can back up and restore the APM database(we are using Oracle database)
CA APM release 10.7
Oracle backup is taking care by your oracle admins. Whenever I did migration or upgrade I asked oracle team to take a backup and when they done I start my task. If you have to take care of the oracle database also following link will help you in this.
Upgrade the Oracle Database - CA Application Performance Management - 10.7 - CA Technologies Documentation
Sometime Back I created this . I distribute this AS-IS
Oracle Restore for APM
Version 0.2 June 2nd 2012
Sr. Support Engineer
CA Technologies, Inc.
Table of Contents
This document covers how to do a successful Oracle Restore since it is not covered in the APM Configuration and Administration Guide.
Step 1: Create tablespace
Run the following in SQL Plus. This creates the needed tablespace used to store the APM export. Use an appropriate size if 20 Gigabytes is too much.
create tablespace CA_APP_DAT datafile ‘D:\emd_data_file\DATA_FILE1.DBF’ size 20g;
Alter tablespace CA_APP_DAT add datafile ‘D:\emd_data_file\DATA_FILE2.DBF’ size 20g; (create as many additional tablespaces as needed.)
Step 2: Create CEM User Account
Again in SQL Plus, create the CEM User account along with password (identified by) and associate it with the tablespace that you just created. Set the correct permissions on the account.
create user cemuser_2 identified by Quality123 default tablespace CA_APP_DAT;
grant connect,resource,create view to cemuser_2;
Step 3: Create Directory Alias and permissions (impds only)
Create the directory alias and needed permissions to do the import
CREATE OR REPLACE DIRECTORY ex_dir AS 'D:\oracle126.96.36.199\directoryname\my_import';
GRANT READ, WRITE ON DIRECTORY ex_dir TO cemuser_2;
Step 4: Run the import
Run the appropriate command from the command line:
The command remaps the schema to use apm_adm tablespace and exportuser account associated with the export.
impdp cemuser_2/Quality123 directory=ex_dir dumpfile=exp_APMP1_full_20120515.dmp' REMAP_SCHEMA=apm_adm:exportuser logfile=db_imp.log
imp sys/syspword@sid fromuser=apm_adm touser=exportuser file='C:\Documents and Settings\Administrator\Desktop\exp_APMP1_full_20120515.dmp' log=imp.log;
Note if the wrong command is used, the output may complain about the dump file format.
Credits and Acknowledgements
My thanks to Michal Lehotsky, Vijay Shankar Venkatachalam, and David Lewis for their assistance and input that became this tech note.
so from the CA APM tool end we have to do any configuration to make a backup of the oracle database and then restore the APM database?
I am not getting a clear picture that how the backup and restore will be done
You have two posts basically on the same topic. (APM & AXA Oracle database)
You can use Oracle or a filesystem backup to backup the APM/AXA database.
Retrieving data ...