Databases Reference
In-Depth Information
Figure 11-9. Database backup and recovery with archived redo logs
Especially useful is the LogMiner utility, accessible through Oracle Enterprise Manager,
and used for investigating redo logs providing analysis for all datatypes. If the redo log
has become corrupted, the LogMiner can read past corrupted records as desired in order
to analyze the impact on transactions after the corruption.
Recovery Manager
Recovery Manager (RMAN) is an Oracle-recommended MAA solution for data cor‐
ruption that provides server-managed online backup and recovery. RMAN does the
following:
• Backs up one or more datafiles to disk or tape
• Backs up archived redo logs to disk or tape
• Backs up automatically the control file and server parameter file to disk or tape
• Backs up CDBs and PDBs to disk or tape
• Restores datafiles from disk or tape
• Restores and applies archived redo logs to perform recovery
• Restores the control file and server parameter file
• Restores CDBs and PDBs from disk or tape
