 |
|
Oracle Tips by Burleson |
Prepare a Vendor Evaluation
As we have noted many third-party vendors
offer hot backup utilities that can perform hot backups on Oracle
database.
Part of the job of any DBA is the
identification and evaluation of third-party software for the
database.
Your task is to perform Internet research
using Google and prepare a list of third-party disk vendors who offer
disk-level backup. This paper will include a single paragraph about
each third-party Oracle backup tool, listing its features. For extra
credit, research DBAs opinions of each vendor tool and provide a short
critique of the advantages and disadvantages of each tool.
Submit to instructor by due date.
The main points of this tutorial include:
* Oracle has two types of backups, a cold
backup and a hot backup.
* A hot backup can be done while the Oracle
database is active and relies on the synchronization of the redo logs
with each tablespaces.
* Oracle recovery required the archived redo
logs to apply the after-images of all Oracle database changes.
* Oracle introduced a tool called Enterprise
Backup Utility (EBU), back in Oracle7 to assist with Oracle backups.
* EBU was morphed into Recovery Manager (RMAN)
in Oracle8.
* RMAN aid in backup and recovery by
communicating with the tape management System (TMS). Examples of TMS
tools include Veritas, Legato and ADSM.
* The latest trend is moving away from
Oracle-centric backups, and many third-party vendors offer disk-level
backup and recovery tools that do not interface directly with Oracle.
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
