You are here

Oracle 11g Standard or Enterprise Edition Database Repository Backup

Oracle 11g Standard or Enterprise Edition Database Repository Backup

The following example shows how to do a full Standard or Enterprise Edition Database repository 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.
 
Log into the Oracle VM Manager Database repository system as the oracle user, or as root and type “su - oracle” to change to the oracle user.

Tip: The exp utility help files are available by typing “exp help=yes”

# su - oracle
$ exp

Export: Release 11.1.0.6.0 - Production on Tue Oct 4 14:03:33 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Username: <USER NAME>
Password: <PASSWORD>

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp >

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

/

Export terminated successfully with warnings.

The above example creates a back up of the Database repository named expdat.dmp in the working directory.

The next example shows how to backup “only” the Oracle VM Manager 11g Standard or Enterprise Edition Database repository ovs schema. Change the user name and password for your environment.

$ exp USERID=<USER NAME>/<PASSWORD> OWNER=ovs FILE=exp_ovs.dmp

Export: Release 11.1.0.6.0 - Production on Mon Oct 3 16:24:09 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

/

Export terminated successfully with warnings.
Download PDF Now!