RE: flashback query vs. log miner
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 11:46:30 -0400
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
