Standby is not an option because: (1) additional space requirement (2) the ETL script that is supposed to get the data as of a specific time (which can be as much as 24 hours ago) expects that. The 5 day requirement is merely to ensure that DW programmers have some leeway when the script fails, particularly over the weekend, especially over a long weekend, and after the recovery period from long trips. In case you are wondering about the reason #2, they are not covered by the 24X7 policy! And God said - let there be flashback! ----- Original Message ----- From: <babette.turnerunderwood@xxxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, February 12, 2004 9:22 AM Subject: RE: Undo Retention of 5 days; anyone? > Dumb question...=20 > > Why not have a stand-by database that is always 5 - 6 days behind ? > If you need to get the information from 5 days ago, put standby in read = > mode and select it from across a database link. > > Babette Turner-Underwood > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx = > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Connor McDonald > Sent: 2004-02-12 1:15 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: Undo Retention of 5 days; anyone? > > > I'd say the issue is not "5 days", but how much is "5 days worth of = > transactions". If there is > lots (of txns) thats sounds like a very very big undo tablespace...It = > might almost be easier just > to have 5 copies of the database, marked "today", "today-minus-one" etc = > - which would be far > quicker to query :-) > > Cheers > Connor > > --- Arup Nanda <orarup@xxxxxxxxxxx> wrote: > List, > > I have a very unusual request from users to have UNDO_RETENTION set to = > 5 days. Normally I set to > > about 5 hours, not days. Don't ask why. They have inherited a bad = > design that requires flashing > > back to 5 days ago and, no, they can't redesign it. > >=20 > > I'm curious if anyone has actually done it, i.e setting it to a very = > high value. Any input will > > be highly appreciated. > >=20 > > Thanks a lot in advance. > >=20 > > Arup > > ---------------------------------------------------------------- > > 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 > > -----------------------------------------------------------------=20 > > =3D=3D=3D=3D=3D > Connor McDonald > Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available = > now > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: connor_mcdonald@xxxxxxxxx > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, = > and...he will sit in a boat and drink beer all day" > > > =09 > =09 > =09 > ___________________________________________________________ > BT Yahoo! Broadband - Free modem offer, sign up online today and save = > =A380 http://btyahoo.yahoo.co.uk > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------