Obtaining a database structure information
using OEM
Introduction
As a DBA, you
are responsible for obtaining database
structure information. The following is a
summary of your task:
Covers:
Selecting a
target database
Obtaining
information about Control Files
Obtaining
information about Online Redo Log Files
Obtaining
information about Archived Redo Log Files
Hands-on
Expand the
Database item.
Now, this time expand the YOURDBNAME
database.
Expand the Storage item.
Highlight the "Controlfile" item.
Here is some general information about the
YOURDBNAME controlfiles.
On the "Record Section" tab, you will see
the yourdbname's controlfile Record Section
information.
Highlight the "Redo Log" item
Double click on the current Redo Log file to
get more information about the Redo Log
file.
Close the window and do the same for the
Archive logs item.
All of the archived Log files with the
archived date stamp and change number will
be displayed.
Double click on the last archived log to
display more information about that archived
Log. |