Oracle DBA Tools - Log Manager Provides manageability of Redo Logs and Archive Logs. Allows users to create and manage redo logs including monitoring archive logs. | |
Toolbar Operations - Available Operations for Redo Logs tab Available Operations for Archive Logs tab | |
Redo Logs Tab - Provides log information from the control file Group Number: Log group number Status: Log status Members: Number of members in the log group Size: Size of the log Sequence Number: Log sequence number First Change Number: Lowest system change number in the log Archived: Archive status {YES, NO} | |
Archive Logs Tab - Provides archived log information from the control file. An archive log record is inserted after the online redo log is successfully archived or cleared. If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN COPY command. Name: Archived log file name Sequence #: Redo log sequence number Thread #: Redo thread number First Change #: First change number in the archived log Completion Time: Time when the archiving completed Archived: Indicates whether the online redo was archived or whether RMAN only inspected the log and created a record for future application of redo logs during recovery |