Free Oracle Tips

Oracle Consulting Oracle Training Development
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 


      
 

    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

 

 

 

 

 

 

     

     


 

Free Oracle dictionary reference poster

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

North Carolina Oracle Users Group

 

 Arabian horse breeder

Seeing eye horses

 

 

 

 

 

BC Remote Oracle Support
P.O. Box 511 • Kittrell, NC, 27544

Copyright © 2007 by Burleson Enterprises, Inc. All rights reserved.