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@xxxxxxxxx>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@xxxxxxxxx> > *To:* "cicciuxdba@xxxxxxxxx" <cicciuxdba@xxxxxxxxx>; oracle-l-freelists < > oracle-l@xxxxxxxxxxxxx> > *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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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@xxxxxxxxx