Hands-On 06 (Obtaining a database structure information using OEM)

As a DBA, you are responsible for obtaining database structure information. The following is a summary of your task:

1. Selecting a target database

2. Obtaining information about Control Files

3. Obtaining information about Online Redo Log Files

4. Obtaining information about Archived Redo Log Files

Hands-On 06 (Obtaining a database structure information using OEM)

Description:

In this exercise you will learn how to find information about
the controlfiles, the Online redo log files, and the archived 
Redo Log file using the Oracle Enterprise Management tool (OEM).

==Start.
Expand the Database item.

==
Now, this time expand the SCHOOL database.

==
Expand the Storage item.

==
Highlight the "Controlfile" item.

==
Here is some general information about the SCHOOL controlfiles.

==
On the "Record Section" tab, you will see the School'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.


By now, you should be able to read and understand the information on
the screen by completing the pervious hands-on exercises.


==
For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!