RE: flashback

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.

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.

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?

Thanks,

Joan

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:
http://www.morrisons.co.uk/gscop

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.