 Donald K. Burleson
Oracle7 Enterprise Backup
Utility
Exactly what is the Oracle/Enterprise Backup
Utility (EBU) and how can it be used? Let’s take a quick look
at the facility and what it does for you.
The EBU facility provides an interface
between the Oracle database and your backup software. It is
not an interface to VMS-Backup, UNIX tar, dump, cpio, or dump.
The EBU facility automatically recognizes third-party tools it
is compatible with and, based on command line or script input
commands, processes Oracle backups against multiple databases.
EBU can make both hot (on-line) and cold (off-line)
backups.
The EBU facility includes the following
background processes:
·
obackup
·
brio
·
brdk
·
brtp
·
brd
The EBU facility uses a central backup
repository to track backups against multiple databases. The
EBU facility is invoked via the obackup command
The above mentioned command is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Registering a
DB in EBU. A database must be registered in the
EBU catalog before it can be backed up using EBU; an example
registration sequence would be register
db_name =
"TEST1"
oracle_home =
"/bto/sys/oracle/product/7.2.3"
oracle_sid =
"ORTEST1"
pfile =
"/oracle0/ORTEST1/admin/pfile/initORTEST1.ora"
log =
"/oracle0/ORTEST1/admin/log/obkTEST1.log"
Once a database is registered, it can
be backed up using commands similar to the following. For
on-line:
The above mentioned command is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
For tablespace backup:
The above mentioned command is
available from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
For control file backup:
The above mentioned command is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Control file and tablespace backups can be
done together, as can database and control file.
An example shell script for UNIX backup is
included with the EBU facility in the directory
The above mentioned script is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Restoration
of Databases Using EBU. The EBU facility also allows
for restoration of the database either to its original
locations or to another host. A restore can consist of one or
more of the following items:
·
Data
files
·
Control
file
·
Parameter
(initialization file)
·
Archive redo
log file
Restoration of entire database:
The above mentioned command is
available from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Restore of tablespaces and control
file:
The above mentioned command is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Restore with datafile move:
The above mentioned command is available
from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
You can also do a point-in-time
restore:
The above mentioned command is
available from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
The EBU facility also provides utilities
for maintaining the catalog and generating reports on backups.
I suggest a complete review of Oracle7
Enterprise Backup Utility Administrator’s Guide,
Release 2.0, March 1996, Part No. A42580-2 (Oracle
Corporation), before attempting to use the EBU facility. It
contains important information that time constraints prevented
me from covering in this lecture.
The above text is an excerpt from Mike
Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Oracle Utilities
Deep inside the operating system
executables there are many utilities at the fingertips of
Oracle professionals, but until now there has been no advice
on how to use these utilities. From tnsping.exe to
dbv.exe to wrap.exe, Dave Moore describes each
utility and has working examples in the online code depot.
Your time savings from a single script is worth the price of
this great book.
Get your copy of Oracle
Utilities today and receive immediate
access to the Online Code Depot! It’s only $19.95 (I don’t
think it is right to charge a fortune for books!) and you can
buy it right now and get immediate access to the online code
depot:
http://www.rampant-books.com/book_2003_1_utils.htm
| 
