Difference between revisions of "Backing up VM Manager DB"
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
Line 101: | Line 101: | ||
[[Category:Oracle]] | [[Category:Oracle]] | ||
[[Category:OVM]] | [[Category:OVM]] | ||
[[Category:Oracle OVM]] |
Latest revision as of 12:34, 3 June 2016
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.