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 -
Refresh : Will refresh all tabs in the log manager from the database
Create Redo Log Group: Create new redo log group
Edit Redo Log Group: Edit selected redo log group
Drop Redo Log Group: Drop selected redo log group
Redo Log Group Properties: View properties of selected redo log group
Switch Log File: Explicitly force Oracle Database to begin writing to a new redo log
file group, regardless of whether the files in the current redo log file group are full.
When you force a log switch, Oracle Database begins to perform a checkpoint but returns
control to you immediately rather than when the checkpoint is complete.
Take Checkpoint: Force Oracle Database to perform a checkpoint, ensuring that all
changes made by committed transactions are written to datafiles on disk
|
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}
|
 Oracle DBA Tools - Log Manager - Redo Logs Tab |
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
|
 Oracle DBA Tools - Log Manager - Archive Logs Tab |
