Skip to content

DESCRIPTION.md

Latest commit

 

History

History
27 lines (21 loc) · 1.32 KB

DESCRIPTION.md

File metadata and controls

27 lines (21 loc) · 1.32 KB

Executive Summary

The DBA Redo Log Files report details the physical configuration of the Online Redo Logs. Redo logs are critical for data integrity; if they are lost, the database cannot recover from a crash. This report verifies that logs are properly multiplexed (mirrored) and located on appropriate storage.

Business Challenge

  • Availability: "Do we have at least two members for each redo log group to protect against disk failure?"
  • Performance: "Are the redo logs on the fastest available disk (e.g., SSD or NVMe)?"
  • Configuration: "How large are our log files? Do we need to resize them?"

Solution

This report joins GV$LOG and GV$LOGFILE.

Key Features:

  • Group Status: CURRENT, ACTIVE, or INACTIVE.
  • Member Path: The full file system path to the log file.
  • Size: The size of the log file in bytes.

Architecture

The report queries GV$LOG and GV$LOGFILE.

Key Tables:

  • GV$LOG: Log group metadata (Sequence #, Size).
  • GV$LOGFILE: Physical file locations.

Impact

  • Data Protection: Ensures that a single disk failure won't cause data loss or downtime.
  • Write Performance: Confirms that redo logs are isolated from other heavy I/O workloads.
  • Recovery: Essential information for performing media recovery.