Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

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





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

      
 

    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 Remote 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 Remote DBA Made Simple by Rampant TechPress.

For tablespace backup:

The above mentioned command is available from Mike Aultís Oracle Remote DBA Made Simple by Rampant TechPress.

For control file backup:

The above mentioned command is available from Mike Aultís Oracle Remote 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 Remote 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 Remote DBA Made Simple by Rampant TechPress.

Restore of tablespaces and control file:

The above mentioned command is available from Mike Aultís Oracle Remote DBA Made Simple by Rampant TechPress. 

Restore with datafile move:

The above mentioned command is available from Mike Aultís Oracle Remote 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 Remote 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 Remote DBA Made Simple by Rampant TechPress.

 

Oracle Utilities


For more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress.

 

 

 

 

 

 

     

     

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracleģ is the registered trademark of Oracle Corporation.