Restoring VM Manager DB

Back to Oracle VM Manager

Restoring Oracle VM Manager

To restore Oracle VM Manager, and the Oracle VM Manager database schema from a 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 follow these steps:

Drop the Old ovs User

$ sqlplus system/password
SQL> drop user ovs cascade;
SQL> exit;

Restore the Database

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.

Reinstall the Manager

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

Restart VM Manager

If you do not need to reinstall Oracle VM Manager, restart Oracle VM Manager:

# /sbin/service ovmm stop
# /sbin/service ovmm start