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 21:35:01 -0400
Message-ID: <AANLkTinAu-osF7hYyB7NQas1J80k=AbaQ2cvhA_f2gbs_at_mail.gmail.com>
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 - 20:35:01 CDT