RE: URGENT: need help by point in time recovery
We use that method for our 8.0.6 testing environments all the time. I don't know if it's supported but it's a really fast, easy way to get what you need. -Original Message- From: Ray Stell [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT: need help by point in time recovery This reminds me of something I always wanted to try to work out. It seems like you should be able to rebuild part of a db, so that the recovery of a certain tables data would be faster. That way you don't spend the time reading all the datafiles for all the TS you don't need to recover. Could you just edit the trace control file to change the structure of the db, so that the only user TS is the one of interest? On Wed, Feb 13, 2002 at 12:32:09PM -0800, [EMAIL PROTECTED] wrote: Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: need help by point in time recovery
*** Standard Disclaimer: If you've never cloned a database before, please try this out in a test environment first. Yeah, it really is that easy. We pretty much only use this method for testing bug fixes so I would suggest that if you want the resulting database around for any length of time, you do a cold backup immediately after you're done. Also, downtime is not a problem as our dr strategy is to have complete live copies of our production databases in readonly mode all the time. We tend to throw hardware at problems. :) On the source: * backup controlfile and copy it to the target * shutdown the source * copy all the necessary datafiles in some manner to the target machine (method depends on if it's raw or cooked, whether or not the machines are on the same frame, etc) On the target after the datafiles are copied: * edit the create controlfile trace script to meet your needs (change the database name, noarchivelog, etc as well as removing the *un-necessary* datafiles) * startup using the new create controlfile trace script * recover the database * open database resetlogs hth, ~Ruth -Original Message- From: Ray Stell [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT: need help by point in time recovery On Fri, Feb 15, 2002 at 10:03:48AM -0800, Dejam, Ruth wrote: We use that method for our 8.0.6 testing environments all the time. I don't know if it's supported but it's a really fast, easy way to get what you need. neat, is it as easy as I stated, just dropping out the ts you don't want. I guess I was thinking when the redo was applied it might barf, but I wasn't sure. Does the recovery just skip over the entries it doesn't know about? Any details on this would be appreciated. Thanks. -Original Message- From: Ray Stell [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT: need help by point in time recovery This reminds me of something I always wanted to try to work out. It seems like you should be able to rebuild part of a db, so that the recovery of a certain tables data would be faster. That way you don't spend the time reading all the datafiles for all the TS you don't need to recover. Could you just edit the trace control file to change the structure of the db, so that the only user TS is the one of interest? On Wed, Feb 13, 2002 at 12:32:09PM -0800, [EMAIL PROTECTED] wrote: Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858
RE: Oracle Advanced Replication
Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MC/Serviceguard vs Sun Clusters
I'll second this. I worked with Sun a few years ago at another place. Here, we're an HP shop with 2 OPS clusters (2 node and 4 node). We finally moved our straggler Compaq cluster to HP a couple of months ago. I'll caveat by saying that we do have a couple of well seasoned SAs and DBAs so it's all been pretty easy to setup and we've found it to be very reliable. hth, ~Ruth Beware of the lollipop of mediocrity. One lick and you'll suck forever. -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 8:18 AM To: Multiple recipients of list ORACLE-L Subject: Re: MC/Serviceguard vs Sun Clusters Stay with HP Serviceguard! From experience, I rank HA solutions in this order: 1. HP serviceguard - easy and it works. 2. IBM HACMP - do it the way IBM wants it and it works. 3. Sun Cluster - get a high paid consultant to set it up and have them come back to change it :) Better yet, go with Veritas Trusted Cluster. Just my $.02. I know some Sun ppl on this list will disagree, but if they worked in a HP env maybe not :) Gene [EMAIL PROTECTED] 02/06/02 08:23PM Hi... I am looking for inputs from anybody who has experience in both MC/Serviceguard (MC/S) as well as Sun cluster implementation. If a DBA/SA team has lots of experience in implementing MC/Serviceguard clusters on HP and trying to move to SunClusters for HA solution ... a) What are the common things between MC/S and and Sun clusters (ex: about 5 minute fail-over time, fixed IP address, 2 or more nodes in a cluster, disk sharing etc..) b) Any differences between these... What are the things to watch out for (assuming the team already knows in and out of MC/Serviceguard) Thank you in advance... Rama -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rama Malladi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Raw I/O
I had responded to Witold privately but it seems that people want more so here goes: We went raw with our production billing system a few months ago because the vendor told damagement that it would be faster. We also converted our failover and testing environments because we do some combination of SRDFs and BCVs of the production system (we are an HP shop). FWIW, each of these monsters is a 2.4T OLTP database. Their code was crappy in a cooked database, and unbelievable as it may seems, performs slightly less crappy in a raw database. We have few SAs and DBAs that have ever worked with raw devices. Despite excellent documentation, configuring aio was *challenging*. The lack of experience has also given us ample opportunity to practice backups and restores. The good news is that our failover has worked flawlessly. :) The upshot is yes, we've gotten slight performance gains. Can you imagine what would happen if we tuned the code, make a few database architectural changes, etc? In the meantime, it was easier and faster to go raw rather than fix the code. Add in the poor resources and you have a weiner! My personal opinion is that we will not realize enough gains to justify going raw. I imagine it's only a matter of time before our business grows enough to bring the system to a screeching halt again. By them we will have implemented yet another version or 2 and will not be able to figure out exactly what to do. I guess, at that time, we can go back to cooked. :) It was probably done for the vendor's own job security and most of our management is totally clueless. For me personally, it's been great because I'm one of 3 DBAs here who have worked with raw before so I have more things to play with now. If you decide to go this route, make sure your SAs and DBAs are educated and careful and get thyself some good backup software. You can check out past discussions about raw vs cooked at http://www.fatcity.com/ListGuru/login.php hth, ~Ruth Ruth Dejam Senior Oracle DBA VoiceStream Wireless Do not meddle in the affairs of dragons for you are crunchy and taste good with ketchup. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 1/17/02 6:50 AM I have been searching for the same answers for a long time and have downloaded a lot of papers on the raw vs cooked and to get definitive answers is a complicated task. Simple methods and opinions and examples will go a long way in the understanding of a controversial and complicated subject. Yes, I know that it is faster, more complicated, a bear to administer but the answer is it is used today in quite a few shops. More informative answers would be appreciated and would help in the decision process of should we or shouldn't we use raw devices and what are the pitfalls and advantages if we do. A guide ,reference, or link to help in the decisions would be a blessing. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Please stop all the rhetoric
FWIW, some of us are still waiting/hoping to hear about people we love. Although, under other circumstances I like to get history lessons, etc, I think there's been more than enough. I'm trying to work and get my mind off things. Not that this lists purpose in life is to do that but I really wish it would go back to being oracle related. It's been really nice to see the out-pouring of emotion from all over the world. I'm sure you all have valid points about religion, history, and world politics. Somehow, who's right seems pretty insignificant in the general scheme of things. Please, take the arguing off line, already. Thanks, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !! Keeping the list alive
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dejam, Ruth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - Vaccines
Title: RE: OT - Vaccines How on earth can a parent make the right decisions?? This is why we have more than 1 child. You try your best with the first. Fix your mistakes and make new ones with the second. and so on, and so on... Despite the same 2 parents, each child has their own personality and you just learn to adapt your parenting style to them. We'reraising 3 teenage princesses.The age I most disliked was around 3 when they would wander offanywhere they liked; confident thatmommy would find them. My eldest was out shopping last weekend and in the midst of buying herself CDs, bought me a novel she thought I'd like. This is one of the ways you know you're doing something right. :) ~Ruth -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, August 17, 2001 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT - Vaccines YOU GUYS ARE SCARING ME OUT OF HAVING CHILDREN! How on earth can a parent make the right decisions?? All the information flying around on the list is pretty unnerving. Sure the numbers may be very low but the #1 thing I worry about (and most other expectant parents) is the baby's health. How do all you parents do this without going batty But thanks for sharing all this info. -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT - Vaccines actually, while the overall rate may well have dropped, the US has an ABHORRENT record in this department: Read this and *weep* http://www.aihw.gov.au/publications/health/ihhac/ihhac-c05d.pdf Note, also, that MOST of the reduction in IMR have NOTHING to do with vaccines...most of them have to do with congenital defects...perinatal complications...etc. In fact, SIDS may be *directly correlated* to increased vaccination: A quote: * In 1950, before mass vaccination began, the USA had the third lowest infant mortality rate in the world. By 1986, the USA dropped to 17th place. By 1995, there were 23 countries ahead of the USA, by now world renowned for its appalling infant mortality. The greatest percentage of these deaths is from Sudden Infant Death Syndrome (SIDS). The link between vaccination and SIDS is indisputable http://hometown.aol.com/drdawndc/cdab.htm SIDS is not easy to cure with Infant Tylenol. Happily, at least one country thinks it has a solution: http://www.seanet.com/~alexs/ascorbate/199x/hattersley-jg-j_orthomol_med-199 3-v8-n4-p229.htm A quote: "(2) Crib deaths nearly disappeared in Japan in 1975 when first inoculations were postponed until the 24th month of life." -Original Message- Sent: Friday, August 17, 2001 12:16 PM To: Multiple recipients of list ORACLE-L sicker? possibly. But the infant mortality rate has dropped. From: "Babette Turner-Underwood" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT - Vaccines Date: Fri, 17 Aug 2001 05:36:53 -0800 I wonder if there is a link between all of these vaccines that are forced upon our children and the increase in childhood illnesses, such as asthma and allergies and ADHD and ...?? Something has changed. With our new improved health care system, I believe on average children are sicker than they were 20 or 30 years ago. - babette -Original Message- Sent: Thursday, August 16, 2001 5:33 PM To: Multiple recipients of list ORACLE-L yikes.the immune system is fabulously complexsecond in complexity only to the brain itself...and it is still very very much in development at early ages...this is why kids -- all kids -- get more colds, etc than us older folks...the system is literally "learning" for the first few years or more. Pounding this system with "new" vaccines...before it is developed, or fully able to defend itself ( vaccines ARE basically hobbled diseases, folks ) is really scary to me. Also, remember...you and I may get chicken pox ( i did, and mumps...) but we get it by host to host contact...NOT by *intravenous injection* directly into the bloodstream where orders of magnitude more of disease vectors are introduced into the body than if they had to pass through the skin or mucosal linings just a thought. -Original Message- Sent: Thursday, August 16, 2001 4:45 PM To: Multiple recipients of list ORACLE-L Give the kid some baby motrin or baby tylenol prior to the shot. Works wonders. I've got two who just got a round of vaccinations this week. Scott Shafer San Antonio, TX Kathy Duret wrote: Thanks for the