Backing up VM Manager DB

From PeformIQ Upgrade
Jump to navigation Jump to search

Back to Oracle VM Manager

Backing Up Oracle VM Manager

To back up Oracle VM Manager, you should back up the Oracle VM Manager configuration file, and the Oracle VM Manager database schema. By default, this schema is named OVS, and this is used in the back up example. Replace the schema name with your own.

The Oracle VM Manager configuration file is stored in the location:

/u01/app/oracle/ovm-manager-3/.config

This configuration file contains database connection information, ports and the UUID used by Oracle VM Manager. An example of this configuration file follows:

Oracle VM Manager configuration file

DBHOST=<hostname of database server>
SID=<oracle SID>
LSNR=<listener port number defaults 1521>
APEX=<application express port number defaults 8080>
OVSSCHEMA=<database schema name for oracle vm manager defaults ovs>
WLSADMIN=<weblogic server admin defaults weblogic>
OVSADMIN=<oracle vm manager administrator name defaults admin>
COREPORT=<oracle vm manager core port defaults 54321>
UUID=<oracle vm manager uuid>

and here is a real example:

[root@vmmanager ~]# cd /u01

[root@vmmanager u01]# find . -name .config
./app/oracle/ovm-manager-3/.config

[root@vmmanager u01]# cd app/oracle/ovm-manager-3/

[root@vmmanager ovm-manager-3]# ls -l
total 20
drwxr-xr-x. 2 root   root 4096 Sep 22 19:41 bin
drwxr-xr-x. 3 oracle dba  4096 Sep 22 19:30 machine1
drwxr-xr-x. 4 oracle dba  4096 Aug 18 12:08 ovm_shell
drwxr-xr-x. 7 oracle dba  4096 Sep 22 19:41 ovm_upgrade
drwxr-xr-x. 4 oracle dba  4096 Aug 18 12:09 weblogic

[root@vmmanager ovm-manager-3]# more .config 

DBHOST=localhost
SID=XE
LSNR=1521
APEX=8080
OVSSCHEMA=ovs
WLSADMIN=weblogic
OVSADMIN=admin
COREPORT=54321
UUID=0004fb0000010000c2e0efabad53a550
BUILDID=1361

To back up Oracle VM Manager:

1.

Back up/copy the Oracle VM Manager configuration file located at

/u01/app/oracle/ovm-manager-3/.config

2.

As the root user, shut down Oracle VM Manager:

# /sbin/service ovmm stop

3.

Back up the Oracle VM Manager database OVS schema. Run the Oracle Database EXP utility to export the OVS schema. The following example shows how to run this utility on the local install of Oracle XE. If you are using an Oracle Standard or Enterprise Edition on the local host, or on a remote computer, you should consult your Oracle Database documentation for the appropriate method for your environment.

Log into the operating system as the oracle user. You can su - oracle as the root user if you do not have the password for the oracle user.

Run the following commands:

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
$ export PATH=$ORACLE_HOME/bin:$PATH
$ export ORACLE_SID=XE
$ exp ovsschema/password grants=y compress=y file=/location/ovsbackup.dmp

The ovschema user in the exp command should be replaced with the name of your OVS schema; the default schema name in an Oracle XE install is ovs. Store the Oracle VM Manager database schema backup along with the Oracle VM Manager configuration file.