Users Guide
Oracle Backup/Restore | Oracle Database Management
172 OMNM 6.5.3 Installation Guide
4
Calculate number of bytes for each class.
5
Sum calculated byte count to determine total datafile size (convert to mega- or gigabytes, if
needed)
NOTICE
Best practice is to size your database at least 20% larger than calculated above.
Oracle Backup/Restore
For Oracle fault tolerance, back up your Oracle database. To do this, we recommend using Oracle’s
Recovery Manager (RMAN) backup utility. This is an Oracle tool that lets you back up, copy,
restore, and recover data files, control files, and archived redo logs. It is included with Oracle server
and does not require a separate installation. For details about using RMAN, see the
Recovery
Manager User's Guide
provided by Oracle.
The next section describes backup and restoration in a little more detail. By default, the primary
database is
owbusdb
. For the web server, back up
lportal
and
synergy
too.
Backup with exp and imp
Although best practice is to use RMAN, Oracle’s backup utility, you can also use
imp
and
exp
export and import a schema in Oracle.
Installing OpenManage Network Manager creates two new user schemas:
netview
is the owner
for the database (or tablespace)
owportal01
,
synadmin
is the owner for the database
owsynergy01
, the default password for these two user is:
dorado.
(See
Database Login /
Passwords
on page 148)
Installation asks for an a oracle user, and this example uses
netmgr
. This selection also appears in
the
installed.properties
file.
User
netmgr
is the owner for the database
owdata01
(loaddb creates tablespace
owdata01
under user
netmgr
) as follows:
loaddb -u system -w
companyName
Executing this command creates
owportal01
and
owsynergy01
loaddb -u system -w
companyName
-s
so the complete backup/restore should includes
In this example dorado is the database administrator’s password, and sample61 is the SID:
Backup
exp system/
companyName
@sample61 owner=netmgr file=netmgr.dmp
exp system/
companyName
@sample61 owner=netview file=netview.dmp
exp system/
companyName
@sample61 owner=synadmin file=synadmin.dmp
Restore
imp system/
companyName
@sample61 fromuser=netmgr touser=netmgr ignore=y
file=netmgr.dmp
imp system/
companyName
@sample61 fromuser=netview touser=netview ignore=y
file=netview.dmp
imp system/
companyName
@sample61 fromuser=synadmin touser=synadmin
ignore=y file=synadmin.dmp