RE: flashback

From: <>
Date: Fri, 27 Aug 2010 07:27:12 +0300
Message-ID: <>

>Learned the new thing today.

few days ago our DBA team encountered yet another flashback issue. You have to have nologging on some db tables. You recover your database.
You truncate those nologging tables which are staging/temporary tables anyway.
And then you get
ORA-1578: ORACLE data block corrupted
Then you find that metalink note "Cannot Reuse a Corrupt Block in Flashback Mode, ORA-1578 [ID 729433.1]" claims this is fixed in 11.1 but 10g are all affected.

That one was a good point to demonstrate what good comes out of using new features recklessly.

Please consider the environment before printing this e-mail

             "Hsieh, Joan"                                                 
             .edu>                                                      To 
             Sent by:                  John Hallas                         
             oracle-l-bounce_at_f         <>,   
                 oracle_l <>   
             2010.08.25 16:47                                      Subject 
                                       RE: flashback                       
             Please respond to                                             

Thanks, John, I checked out our log and email back the date the flashback log had been stopped. It was exactly the case that our flashback area was 100% full. Until now, I donít know it automatically disable the flashback. Learned the new thing today. Thanks again.


From: John Hallas [] Sent: Wednesday, August 25, 2010 6:35 AM To: Hsieh, Joan; oracle_l
Subject: RE: flashback

See my post


From: [] On Behalf Of Hsieh, Joan
Sent: 24 August 2010 19:20
To: oracle_l
Subject: flashback

Hi Listers,

I had set flashback on to both our primary and standby databases since it was setup. I just noticed that it was disabled a year ago. I couldnít recall that I had issued any alter database command in the database. Is there any possible causes could turn the flashback_on =off?



Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.

If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.

This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at:

Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.

Received on Thu Aug 26 2010 - 23:27:12 CDT

Original text of this message