Databases Reference
In-Depth Information
This Log Miner session initiated through OEM shows a sequence of DML
statements executed by GARY against the ORDER_ITEMS table. The SQL Redo col-
umn shows the DML statement used to change the ORDER_ITEMS table, and the
SQL Undo column shows how to reverse the change made by the DML statement
in the SQL Redo column. Double-clicking a row in the report brings up a second
window that shows the complete text of both the SQL Undo and SQL Redo col-
umns, as shown here.
Recovery Manager
The
Recovery Manager
(RMAN)
tool is an extensive and comprehensive set
of tools that can streamline the backup and recovery of a database. It can be
accessed via either a command line or a GUI interface through OEM by selecting
Tools
Recovery Manager (RMAN)
A comprehensive set of backup and
recovery tools that can streamline the
backup and recovery of a database.
Backup. Using RMAN can
reduce errors by automating many of the tasks that a DBA would otherwise need
to perform manually, such as checking a backup set for completeness or logging
the results of a backup operation.
RMAN can perform the following tasks:
Back up all database objects
RMAN can back up every individual type
of database or filesystem object, or the entire database. It can back up
tablespaces, datafiles, control files, and log files.
Database Tools
Backup Management
