| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Paula_Stankus_at_doh.state.fl.us
Sent: Monday, July 26, 2004 11:42 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kirtikumar Deshpande
Sent: Saturday, July 24, 2004 10:50 AM
To: oracle-l_at_freelists.org
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_at_doh.state.fl.us 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
=3D09
-- 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_at_freelists.org 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_at_freelists.org 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 -----------------------------------------------------------------Received on Mon Jul 26 2004 - 10:44:56 CDT
 |
 |