iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - OEM

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |

 

Lesson 06

"Why don't you write books people can read?" - Nora Joyce to her husband James (1882-1941)

 

Read first then play the video:

   OEM-VIDEO -Obtaining a database structure

   

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 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.