Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Recovery Area Page

The Recovery Area page in the Disk Storage drilldown displays performance statistics related to the Oracle flash recovery area.

When available, the flash recovery area is a location — a directory, file system, or ASM disk group — where Oracle can store the backup and recovery files that are used to recover data that has been lost or corrupted by logical errors (such as human error).

To open the Recovery Area Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Disk Storage | Recovery Area.

Note: The Recovery Area page is unable to display flash recovery statistics for some Oracle systems.

  • (Oracle 10g Release 1) Only the Flashback Log IO chart is populated, and some home-page components are grayed out.
  • (Oracle 10g Release 2 and later) The Recovery Area page displays all the required data. If the components on this page contain incomplete data, flashback has been disabled.

Charts on the Recovery Area Page

Chart

Description

Flashback Log IO

Flashback Log IO shows the rate of I/O operations to the flashback log files.

The Oracle logs used to perform flashback database operations can be written only to the flash recovery area, and cannot be backed up to disk.

Flash Utilization

Flash Utilization shows the sizes of various file types within the flash recovery area over time.

The types of files typically found in the recovery area include:

  • Archived logs.
  • Backup pieces.
  • Control files.
  • Flashback logs.
  • Online logs.
  • Copies of datafiles and control files.

Grids on the Recovery Area Page

Grid

Description

Flashback Configuration

Flashback Configuration displays a collection of configuration variables and status indicators for the flash recovery area.

Variable

Description

DB_RECOVERY_FILE_DEST

The location of the flash recovery area.

DB_RECOVERY_FILE_DEST_SIZE

The total space to be used by recovery files in the flash recovery area (measured in bytes).

Retention target (minutes)

The upper limit (in minutes) on how far the database can be flashed back.

Current flashback log count

The number of flashback logs currently in the flash recovery area.

Estimated size for flashback logs (MB)

The estimated size of flashback data needed for the current target retention (provided by Oracle).

Most recent flashback log (minutes)

The time in minutes since the latest flashback log was written to the flash recovery area.

Oldest flashback log (minutes)

The time in minutes since the oldest flashback log was written to the flash recovery area.

Total size of all files in MB

The amount of space used by all files in the flash recovery area.

Total size of reclaimable files in MB

The amount of space that Oracle can reclaim from the flash recovery area.

Unused space in MB

The amount of free space in the flash recovery area.

Note: (Oracle 10g Release 2 and later) If flashback has been disabled, the Flashback Configuration table contains incomplete data.

Flashback History

Flashback History displays historical information on the use of the flash recovery area.

Column

Description

Begin Time

The beginning of the flashback time interval.

End Time

The end of the flashback time interval.

Minutes

The duration of the time interval.

MB read/write

The amount of data read and written during the interval.

KB/sec

The rate of reads and writes during the interval.

Size Estimate

The estimated size of flashback data needed for the current value of the DB_FLASHBACK_RETENTION_TARGET parameter (see the Flashback Configuration table).

Database MB

The amount of database data read and written during the interval.

DB KB/s

The rate of database reads and writes during the interval.

Flashback MB

The amount of flashback data written during the interval.

Flashback KB/s

The rate of flashback writes during the interval.

Redo MB

The amount of Redo data written during the interval.

Redo KB/s

The rate of Redo writes during the interval.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating