Oracle records the changes made to data files in online redo logs, which can be used to recreate the database at any specified point in time. Oracle rotates the logging process through a set of two or more logs.
When an Oracle database has been set up for archiving, the redo logs that are not in use are copied to a set of mandatory or optional archive destinations. The database administrator (DBA) sets up several archive destinations for each instance in the database and can configure the number of destinations that must succeed when archiving. Up to 10 destinations can be defined per instance.
Archive destinations can be set up in different types of locations:
Note: Spotlight reports equally on all archive destinations, with the exception of mapped network drives on Windows platforms, which do not support UNC naming of shares and prevent Spotlight from reporting on archive space or calculating time to failure.
To open the Archive Destinations page
Select the Spotlight on Oracle connection in the Spotlight Browser.
Click Disk Storage | Archive Destinations.
Charts on the Archive Destinations page
Chart |
Description |
---|---|
Archive Log Rate |
Archive Log Rate shows the aggregate rate (in megabytes per hour) at which data is being written from the Oracle database to ALL the defined archive destinations. Note: There are no additional Spotlight metrics available for this chart. |
Archive Free Space |
Archive Free Space shows the amount of free space available in EACH archive destination defined for the Oracle database. There are usually at least two (and there can be as many as 10) archive destinations defined per Oracle instance. If Spotlight has raised an Archive Destination Failure Alarm or Archive Critical Failure Alarm, you can use this chart to view:
A destination failure alarm indicates that at least one of the archive destinations is about to fail. A critical failure alarm indicates when the number of working destinations falls below the minimum number needed to archive successfully. Note: To prevent archive destination failure, consider using an automated background process to purge archive destinations when they reach a specified threshold. |
Archive Destination Grid
Archive Destination provides detailed information to complement the data shown for EVERY destination shown in the Archive Free Space chart above. Initially, the entries in this table are ranked in order of increasing time to failure. (Destinations whose time to failure is unknown are ranked first.)
Note: Information in the Archive Destination grid is updated every 5 minutes or at Spotlight's background refresh period (whichever is longer). Data Refresh Rates
Column |
Description |
---|---|
Archive Destination |
The name of the destination archive file. |
Status |
The current status of the destination in V$ARCHIVE_DEST — VALID, INACTIVE, DEFERRED, ERROR, DISABLED, BAD PARAM, ALTERNATE, or FULL. |
Destination |
The location where the archive is stored. This may be:
|
Destination total (MB) |
The total size of the archive destination target. |
Destination free (MB) |
The total amount of free space available for the archive destination target. |
Destination usable (MB) |
The total amount of usable space for the archive destination target. This is the same as the Destination free value if the archive destination is on a filesystem, or on an ASM diskgroup with EXTERNAL redundancy. Notes:
|
Time to failure |
If the archive log area is not backed up and purged, this is the amount of time before the archive log destination will become full. The projected time to failure is determined by recent log generation rates for the usable space in that destination. If the destination is an ASM diskgroup set up for redundancy, the time to failure is the point at which the value of V$ASM_DISKGROUP.USABLE_FILE_MB will be zero. Notes:
|
Notes |
A text area that contains further information about the specified archive destination.
|
Binding |
A value in V$ARCHIVE_DEST that specifies how failure affects the archiving operation:
|
Destination type |
Is the archived log destination PUBLIC or PRIVATE? By default, all archived log destinations are PUBLIC. Only PUBLIC destinations can be modified at runtime using the ALTER SYSTEM SET or ALTER SESSION SET statements. |
Log sequence |
The number of the last archived redo log on this destination. |
Re-open (sec) |
The retry time to open a destination after an error. |
Transmit mode |
The mode in which data is transmitted across the network — SYNCHRONOUS, ASYNCHRONOUS, or PARALLELSYNC. |
Valid for |
The optional VALID_FOR attribute allows you to use the same initialization parameter file for both primary and standby databases. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center