Difference between revisions of "Backing up VM Manager DB"

From PeformIQ Upgrade
Jump to navigation Jump to search
(Created page with '=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, ...')
 
Line 53: Line 53:
Run the following commands:
Run the following commands:


  export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
  $ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
  export PATH=$ORACLE_HOME/bin:$PATH
  $ export PATH=$ORACLE_HOME/bin:$PATH
  export ORACLE_SID=XE
  $ export ORACLE_SID=XE
  exp ovsschema/password grants=y compress=y file=/location/ovsbackup.dmp
 
  $ 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
The ovschema user in the exp command should be replaced with the name of your
Line 64: Line 65:




3.8 Restoring Oracle VM Manager
[[Category:Oracle]]
To restore Oracle VM Manager, and the Oracle VM Manager database schema from a
[[Category:OVM]]
backup, you must have performed the steps to back up Oracle VM Manager in
Section 3.7, "Backing Up Oracle VM Manager".
To restore Oracle VM Manager from a backup:
1.
 
Restore the Oracle VM Manager OVS database schema. Log into the Oracle
Database to perform the following steps to restore the OVS schema from backup.
Log into the Oracle Database as the sys or system user to create the Oracle VM
Manager administration user:
 
$ sqlplus system/password
SQL> create user ovs identified by password;
SQL> grant connect, resource to ovs;
SQL> exit;
 
Import the OVS schema from the backup file:
 
#
#
#
#
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=XE
imp ovsschema/password file=/location/ovsbackup.dmp full=y
 
The ovschema user in the imp command should be replaced with the name of your OVS schema; the default schema name in an Oracle XE install is ovs.
 
2.
 
If you you need to reinstall Oracle VM Manager, use the Oracle VM Manager
installation media to perform an install of the software on your server. See
Section 3.4, "Installing Oracle VM Manager" for information on how to perform
the installation.
 
You should perform the install using the runInstaller.sh --uuid uuid
option and provide the UUID from the previous manager installation. The uuid
can be located in the Oracle VM Manager configuration file. For example,
 
# ./runInstaller.sh --uuid 0004FB000000100002CB7F2DFFA8D8
 
When the Oracle VM Manager installer prompts for installation information other
than passwords, reuse the same usernames for the Oracle Database schema, Oracle
WebLogic Server and Oracle VM Manager administration user, as set out in the
backedup of the Oracle VM Manager configuration file. You must set new
passwords as the passwords are not backed up and cannot be restored.
 
3.
 
If you do not need to reinstall Oracle VM Manager, restart Oracle VM Manager:
 
# /sbin/service ovmm stop
# /sbin/service ovmm start

Revision as of 19:27, 22 September 2011

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>

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
  1. .

As the root user, shut down Oracle VM Manager: 

# /sbin/service ovmm stop
  1. .

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.

Retrieved from "https://performiq.com/kb/index.php?title=Backing_up_VM_Manager_DB&oldid=3589"