2 Day DBA > Managing Database Storage > Viewing Redo Log Files
Viewing Redo Log Files |
Previous |
Next |
You can use the Oracle Database XE graphical user interface to view location and status information for the online redo log files.
To view redo log files:
Access the Database Home Page.
See "Accessing the Database Home Page" for instructions.
In the Usage Monitor at the right-hand side of the page, click the link at the bottom that reads either Log Archiving: Off or Log Archiving: On.
Note: If the Usage Monitor does not appear on the Database Home Page, click the Customize link near the upper right-hand corner of the page, and then enable the Usage Monitor. |
The Database Logging page appears.
This example shows a database in which the redo log was multiplexed in the following way:
There were three log groups created, each with two members.
In each log group, one member was located with the datafiles, and the other left in the flash recovery area.
See "Online Redo Log Files" for more information on redo log groups and log group members.
Note: The Database Logging page does not display information on archived redo log files. In addition, the default configuration of Oracle Database XE does not include redo log multiplexing. |