RE: flashback
Date: Fri, 27 Aug 2010 07:27:12 +0300
Message-ID: <OFDEA45B4A.3D4943F9-ONC225778C.0017528F-C225778C.001876A9_at_seb.lt>
>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"
<Joan.Hsieh_at_tufts
.edu> To
Sent by: John Hallas
oracle-l-bounce_at_f <John.Hallas_at_morrisonsplc.co.uk>,
reelists.org oracle_l <ORACLE-L_at_freelists.org>
cc
2010.08.25 16:47 Subject
RE: flashback
Please respond to
Joan.Hsieh_at_tufts.
edu
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.
Joan
From: John Hallas [mailto:John.Hallas_at_morrisonsplc.co.uk]
Sent: Wednesday, August 25, 2010 6:35 AM
To: Hsieh, Joan; oracle_l
Subject: RE: flashback
See my post
http://jhdba.wordpress.com/2010/01/06/flashback-disabled-automatically-a-minor-rant/
John:
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
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?
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 26 2010 - 23:27:12 CDT