everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 06

Next >>


 

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.

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.