You are here

How to Backup an Oracle 11g Express Database Repository

How to Backup an Oracle 11g Express Database Repository

The following example shows how to do a full Oracle Express Database repository backup using the exp utility.

Note: The exp utility is one of many applications that can be used to do a full Oracle VM Manager Database repository backup.

The exp utility can be run in one of three modes: interactive dialogue, controlled through bypassed parameters and parameter file controlled. For the sake of brevity, we will use the interactive dialogue mode to do a full Oracle VM Manager 11g Standard or Enterprise Edition Database repository backup.

The exp utility usage is a field unto itself, a detailed review is beyond the scope of this book. The goal of this section is to explain how to do a full Oracle VM Manager 11g Standard or Enterprise Edition Database repository backup using the exp utility.

 

The next example shows how to backup an Oracle 11g Express Database repository using the exp utility.  

Log into the Oracle VM Manager host as the oracle user, or as root and type “su - oracle” to change to the oracle user. As the oracle user type the following commands to backup the  Oracle VM Manager 11g XE Database repository.

Note: Replace <PASSWORD> with the ovs database schema password that was selected during the Oracle VM Manager installation. In the below example a file named “ovsbackup.dmp” is created in the /tmp directory. Any name or directory can be used with the “file=” argument.

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=XE

Download PDF Now!