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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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
|
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
|
Flashback Configuration |
Flashback Configuration displays a collection of configuration variables and status indicators for the flash recovery area.
|
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.
|
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
Spotlight on Oracle Drilldowns
