Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

History of Database

user12050217Sep 5 2010 — edited Sep 6 2010

Hello,

How do i get below answer for my database 10.2.0.1 on windows xp :

1.Upto which period db run in archive and no archive mode after its creation.
2.How many times db has been recovered by RMAN till its creation. (suppose there is no log available)
3.On which date new control file/redo log group added/removed after its creation.
4.Which tables has been flashbacked after its creation.
5.Upto which period of time, which users were there on db.
Like
From 01-02-2009 to 10-04-2009 Scott
From 01-02-2009 to 10-04-2009 HR user
From 01-02-2009 to 05-04-2009 User1
etc.

4.Any other important date related to db.

I mean, is there any view or i just have to search/guess in alert log?

Thanks,

Edited by: user12050217 on Sep 4, 2010 10:07 PM
Couple of questions added.

This post has been answered by Billy Verreynne on Sep 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2010

Added on Sep 5 2010

#general-database-discussions

15 comments

1,633 views