Re: How do you refresh your databases? - Slightly going off topic.... only slightly..... a bit, yeah a bit.... know what I mean, wink wink.....?
Date: Thu, 24 Mar 2011 19:23:49 -0700 (PDT)
Message-ID: <460294.21992.qm_at_web113203.mail.gq1.yahoo.com>
Exadata machines are known non-drinkers (except VOLT of course). So the 230043 error is not possible.
Do other databases have Exadata envy? What would Freud think?
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
From: Thomas Roach <troach_at_gmail.com> To: robertgfreeman_at_yahoo.com
Cc: oracle-l-freelists <oracle-l_at_freelists.org Sent: Thu, March 24, 2011 7:35:01 PM
Subject: Re: How do you refresh your databases? - Slightly going off topic.... only slightly..... a bit, yeah a bit.... know what I mean, wink wink.....?
Just buy an Exadata. It solves the following dreaded and DBA career ending error message "ORA-230043 - Hard drive spinning - unable to summarize without falling over."
On Thu, Mar 24, 2011 at 5:41 PM, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
I find that Oracle databases find coke more refreshing than Pepsi by 3 to 1
myself.
>
>Exadata requires that you refresh with VOLT (or an equivalent energy drink) at a
>minimum. It's in the manual. Really, go look. ;)
>
>I once knew an Oracle Database that had a drinking problem. It slurred it's
>query results.
>
>SQL>select last_name from my_names;
>
>LASSSTT_NNAAMMEE (OH MY HARD DRIVE)
>----------------------------------------------------------------------
>Free.... Freem .... No... I can do it.... Freeman (hic)
>K .... Kyttt .... Kyttteele...ugh my head.... Kyte (hic)
>
>2 rooooowwwsss retuurrnneeedd
>
>SQL>select region, sum(all_dollars) answer from sales group by region;
>ORA-304230 - Sorry, I'm sleeping off a hangover right now. Please try again
>later.
>ORA-203933 - Attempt to force calculation when BA index is > 2.0.
>ORA-230043 - Hard drive spinning - unable to summarize without falling over.
>ORA-201113 - Just saw a pink flying TRS-80 Model One.
>
>-- To correct the issue is the hidden parameter I found on dba-something.com
>somewhere....
>alter system set _take_aspirin_mode=on;
>
>I used it, but then the CPU started to have bleeding problems.
>
>So I opt for the _use_tylenol_mode in those cases.
>
>
>Bottom line, some databases need interventions because of bad design. Some
>databases need interventions because they need some good administration TLC.
>Some databases just need interventions. If you know of such a database, please
>be a friend and stop it before it kills some data with a hard drive crash. The
>bit you save may represent you or one of your family.
>
>I hear the Betty Ford Clinic is opening the Turing wing for the worst cases.
>
>Man.... what a day.
>
>Robert G. Freeman
>Master Principal Consultant, Oracle Corporation, Oracle ACE
>Author of various books on RMAN, New Features and this shorter signature line.
>Blog: http://robertgfreeman.blogspot.com
>
>
>
>
>
From: Michael Dinh <mdinh_at_XIFIN.Com>
>To: "cicciuxdba_at_gmail.com" <cicciuxdba_at_gmail.com>; oracle-l-freelists
><oracle-l_at_freelists.org>
>Sent: Thu, March 24, 2011 2:07:19 PM
>Subject: RE: How do you refresh your databases?
>
>
>A little late, but what about partial database recovery and a shameless plug?
>
>http://mdinh.wordpress.com/2010/12/01/partial-database-recovery/
>
>Michael Dinh
>
>NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
>individual or entity to which it is addressed, and may contain information that
>is privileged, confidential and exempt from disclosure under applicable laws.
>BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION
>(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS
>FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN,
>EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR
>OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this
>email (and attachments) is not the intended recipient, you are hereby notified
>that any dissemination, distribution or copying of this communication is
>strictly prohibited. Please notify the sender of the error and delete the e-mail
>you received. Thank you.
>From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
>Behalf Of Guillermo Alan Bort
>Sent: Tuesday, March 22, 2011 1:01 PM
>To: oracle-l-freelists
>Subject: How do you refresh your databases?
>
>List,
>
> We have to refresh a QA database from production (to have some real data) but
>we need to exclude all the PCI/PII from the refresh (it absolutely cannot be
>copied from Prod to QA). In addition, we have GG replication on Prod so anything
>we do is subject to that.
>
> What would be your approach?
>
> My idea was rman duplicate, but those pci/pii tables rule this out.
>
>Oh, GG cannot be used due to firewall restrictions, we only have database ports
>and SSH from Prod to QA
>
>any ideas?
>Alan.-
-- Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 24 2011 - 21:23:49 CDT