No question at this time
DBA Top 10
1 M. Cadot 15900
2 A. Kavsek 11800
3 B. Vroman 10800
4 M. Hidayathullah ... 7600
5 T. Boles 4800
6 P. Wisse 4000
7 J. Schnackenberg 3000
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 700
9 T. P 700
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48114
Total active users1700
Act. users last 24h12
Act. users last hour1
Registered user hits last week507
Registered user hits last month1127
Go up

flashback database + flashback technology
Next thread: difference between v$datafile and v$datafile_header + rman
Prev thread: Data warehoue strategy

Message Score Author Date
hi guys, just want to comfirm a point, my old m...... sze jie koh May 22, 2010, 19:05
There are many flashback features that depend on...... Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts Michel Cadot May 22, 2010, 19:31
i trust pple here more then any words i heard outs...... sze jie koh May 22, 2010, 20:33
Franck and Micheal No words to say, you are gre...... rishaan ahamed May 23, 2010, 05:02
Frank and Michael, You people are truly the her...... Noufal Paramboor May 23, 2010, 22:23

Follow up by mail Click here


Subject: flashback database + flashback technology
Author: sze jie koh, Singapore
Date: May 22, 2010, 19:05, 2797 days ago
Os info: win xp
Oracle info: oracle 10g
Message: hi guys,

just want to comfirm a point, my old mentor today taught me that flashback technology depends solely on flashback area ?


i argue that undo tablespace play a part as well for flashback queries

q1) am i wrong ? does all the flashback capability depends on the flashback area (flshback logs) only ?
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: flashback database + flashback technology
Author: Michel Cadot, France
Date: May 22, 2010, 19:31, 2797 days ago
Score:   Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts
Message:
There are many flashback features that depend on different things:
- flashback database that allows to put the database in state it was before without gavong to restore and recover it and relies on flashback logs
- flashback drop that allows to retrieve a dropped table and relies on recycle bin
- flashback table that allows to put back the data in a table as they were back in the past and relies on undo data
- flashback query that allows to query the data as they were in the past and relies on undo data (and archived ones in 11g)
- flashback version query that allows to retrieve all the versions of the data of a table and relies on undo data
- flashback transaction query that allows a DBA to know the transaction stream on a table and relies on undo data.

Only the first one depends on FRA where reside the flashback logs.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: flashback database + flashback technology
Author: sze jie koh, Singapore
Date: May 22, 2010, 20:33, 2797 days ago
Message: i trust pple here more then any words i heard outside!

tahnks alot michel!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: flashback database + flashback technology
Author: rishaan ahamed, India
Date: May 23, 2010, 05:02, 2796 days ago
Message: Franck and Micheal

No words to say, you are great.

May God gives you and your family a long life.

Have a nice weakend.

Rahman//
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: flashback database + flashback technology
Author: Noufal Paramboor, India
Date: May 23, 2010, 22:23, 2795 days ago
Message: Frank and Michael,

You people are truly the heros..

may u both live long..

Take care..
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here