A backport shouldn't take two months, but it will take a while. Here's what I would try to do. 1) Press Oracle for a date for the backport (escalate and refer to the sev1 issues) Assume 2 months is the period 2) Take and keep a backup now. 3) Negotiate with the business a 3 month switch off of Flashback Archive. good luck anyway. Niall On Mon, Apr 21, 2008 at 9:07 PM, Bill Ferguson <wbfergus@xxxxxxxxx> wrote: > Geez, two months? > > If it takes that long, for sure the FileMaker advocates will finally > win. I've been battling them for years now. Something like this would > give them the ammunition they finally need to drop Oracle. > > It's not really flashback, but what they call "flashback archive" > (marketing calls it Total Recall), where after I set it up for which > tables I want changes tracked, all changes to the data in those tables > is recorded. This would save me having to edit a whole slew of > triggers. > > Anyway, if I now turn that off (and no guarantee that will solve my > problem), then I lose all of the table tracking that's been generated > this year. But, at least a RMAN backup might save me there. > > So it seems I can either: > 1. Wait for who knows how long before the database is usable again, > possibly with management deciding to finally drop Oracle and go with > FileMaker (major Yuck!). > 2. Experiment to see if losing all of the data changes this year fixes > my the problem. > 3. Revert back to 10.2 and lose this years data in case I can't export > it back into 10.2. > > Not a very heartening set of choices. > > Thanks everyone for the input. It's greatly appreciated. > > -- > -- Bill Ferguson > > On Mon, Apr 21, 2008 at 1:47 PM, Finn Jorgensen > <finn.oracledba@xxxxxxxxx> wrote: > > Bill, > > > > The last time I had Oracle create a one-off patch for a bug I > encountered it > > took somewhere around 2 months to get it fixed and delivered to me. This > is > > despite the fact it was on a production system that crashed every 2 > weeks > > due to the problem. This was on 10.2.0.1. > > > > Tell your users the truth, that you can't make it go any faster. It's > not > > what they want to hear, but it's not helping anybody that they're > banging on > > your door when the problem is off your desk. > > > > Can you workaround the problem a little? You said it was a combination > of > > UNDO and flashback. Perhaps you can turn off flashback for the time > being? > > > > Finn > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info