First page Back Continue Last page Graphics

…Principal Features…


Notes:

Oracle provides many standard high availability features. These include:
Multiplexed Redo Log files – All committed transactions are secure in the redo log file. Database (instance) failure is recoverable by applying committed transactions from the redo log files.
Recovery Manager – RMAN is a built-in utility for server-managed backup and recovery.
Online reorganization – Oracle has been providing limited online operations since release 8.0. 9i provides an advance in this area with the introduction of DBMS_REDEFINITION for complete online table redefinition.
Logminer – Logminer is another built-in utility that provides the ability to “look inside” the redo logs, to see activity that has transpired in the database. Both REDO and UNDO SQL can be mined from the logs using Logminer.
Flashback Query – This feature allows you to execute a query at previous point in time. By loading a table from a query run while in flashback query mode, we are provided “self-service” error correction capability.
Partitioning – By dividing up large logical tables into smaller physical partitions (transparent to applications), we gain the ability to maintain pieces of the object , while leaving other partitions available for general use.