RE: flashback query vs. log miner

I'm pretty sure that 5 days is a hard limit, unless you're into hacking
the database.....;-)

As I recall a certain dinner in Dallas, Kirti described how he
successfully did so, extending the 5 day limit to, um, 10 days,
perhaps....? ;-)

But, I don't think that would be a recommended approach for a production
database....;-)

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Monday, July 26, 2004 11:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: flashback query vs. log miner


Thanks Kirti,

That was a very concise description and along the lines of what I was =
=3D
telling a junior dba I am training. =3D20

However, is it a hard limit for FBQ - 5 days - or is it solely based on
=3D
undo tablespace size and undo tablespace retention parameter? =3D20

Also, is there any downside with allocating a great deal of space to the
=3D
undo tablespace in a database other than static allocation?



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kirtikumar Deshpande
Sent: Saturday, July 24, 2004 10:50 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: flashback query vs. log miner


Paula,
 One must use LogMiner if one needs to access data that is more than 5 =
=3D
days old (instance
uptime wise). FBQ does not help you. Of course, this changes with Oracle
=3D
10g ( and what
doesn't? ;).=3D20

 Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy
=3D
to use FBQ to
access past data (if it is still available in the undo segments). =3D
Accessing the same
information via LogMiner is a bit more involved process. With proper =3D
privileges, you can
let your developers use FBQ, but I doubt if DBAs will allow Developers =
=3D
to play with
LogMiner. =3D20

 So, I would not use one versus the other all the time, but may be =3D
required to use both,
depending on the requirement.=3D20

Regards,
- Kirti
=3D20
--- Paula_Stankus@xxxxxxxxxxxxxxx wrote:
> Guys,
>=3D20
> I know you can reconstruct data in a table (given your undo segments =
=3D
in =3D3D
> your undo tablespace is not overwritten)
> with flashback query.  However, you should be able to do the same =3D
using =3D3D
> log_minor.
>=3D20
>=3D20
> So flashback is easier to work but probably couldn't restore as much =
=3D
as =3D3D
> you could using log_minor. =3D3D20
>=3D20
> Why would you use one versus the other?


        =3D09
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail=3D20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 5416553) is spam:
Spam:        =3D
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Ds&i=3D3D5416553&m=3D3=
D3e3a
8=3D
d0f45c8
Not spam:    =3D
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Dn&i=3D3D5416553&m=3D3=
D3e3a
8=3D
d0f45c8
Forget vote: =3D
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Df&i=3D3D5416553&m=3D3=
D3e3a
8=3D
d0f45c8
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: