No question at this time
DBA Top 10
1 M. Cadot 15900
2 B. Vroman 15500
3 A. Kavsek 10000
4 T. Boles 6800
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3900
7 P. Wisse 1800
8 T. P 700
9 B. Derous 500
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48209
Total active users1645
Act. users last 24h6
Act. users last hour0
Registered user hits last week186
Registered user hits last month812
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, 2952 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, 2952 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, 2952 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, 2951 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, 2951 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