8.239 V$FOREIGN_ARCHIVED_LOG
V$FOREIGN_ARCHIVED_LOG
can be queried on a logical standby database to find out the list of foreign archived logs received by a database.
No rows are returned for this view on a physical standby database.
Column | Datatype | Description |
---|---|---|
|
|
Archived log record ID |
|
|
Archived log record stamp |
|
|
Archived log file name. If set to NULL, either the log file was cleared before it was archived or an RMAN |
|
|
Original destination from which the archive log was generated. The value is 0 if the destination identifier is not available |
|
|
Redo thread number |
|
|
Redo log sequence number |
|
|
Resetlogs change number of the database when the log was written |
|
|
Resetlogs time of the database when the log was written |
|
|
Resetlogs identifier associated with the archived redo log |
|
|
First change number in the archived log |
|
|
Timestamp of the first change |
|
|
First change in the next log |
|
|
Timestamp of the next change |
|
|
Size of the archived log (in blocks) |
|
|
Redo log block size. This is the logical block size of the archived log, which is the same as the logical block size of the online log from which the archived log was copied. The online log logical block size is a platform-specific value that is not adjustable by the user. |
|
|
Creator of the archive log: ARCH - Archiver process FGRD - Foreground process RMAN - Recovery Manager SRMN - RMAN at standby LGWR - Logwriter process |
|
|
Registrar of the entry: RFS - Remote File Server process ARCH - Archiver process FGRD - Foreground process RMAN - Recovery Manager SRMN - RMAN at standby LGWR - Logwriter process |
|
|
Indicates whether the online redo log was archived ( |
|
|
Indicates whether the archivelog has been applied to its corresponding standby database ( This column is meaningful at the standby site for the You can use this field to identify archivelogs that can be backed up and removed from disk. |
|
|
Indicates whether an RMAN |
|
|
Status of the archived log: A - Available D - Deleted U - Unavailable X - Expired |
|
|
Time when the archiving completed |
|
|
Indicates whether the log contains the start of a LogMiner dictionary ( |
|
|
Indicates whether the log contains the end of a LogMiner dictionary ( |
|
|
Indicates whether the archived redo log contains the end of all redo information from the primary database () or not () |
|
|
Redo thread number of the instance that performed the archival operation. This column differs from the |
|
|
Indicates whether the file was created in the fast recovery area ( |
|
|
Reserved for internal use |
|
|
Indicates whether the archive log was generated as the result of a FAL request ( |
|
|
Possible values are as follows: SWITCHOVER - Shows archived redo log files that are produced at the end of a switchover TERMINAL - Shows archived redo log files produced after a failover RESETLOGS - Shows online redo log files archived on the primary database after an ACTIVATION - Shows any log files archived on a physical standby database after an "empty string" - Any empty string implies that the log is just a normal archival and was not archived due to any of the other events |
|
|
Database ID of the source database that generated this archived log |
|
|
The ID of the container to which the data pertains. Possible values include:
|