From lerobe@acxiom.co.uk Thu, 24 May 2001 00:28:46 -0700 From: Robertson Lee - lerobe Date: Thu, 24 May 2001 00:28:46 -0700 Subject: RE: Database Down Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Database Down Woo Hoo, well done and have a virtual (drink of your choice) on me.   I know it is really scary when you get thrown in at the deep end like this but if you are anything like me, after this happened to me for the first time and I had, by all means at my disposal, got through it all, WOW - what a feeling.   Relief, pride, accomplishment etc. etc   PS. I probably owe my house to Rama Velpuri !!!!   Regards   Lee -----Original Message-----From: Burton, Laura L. [mailto:BurtonL@prismplus.com]Sent: 23 May 2001 19:56To: Multiple recipients of list ORACLE-LSubject: RE: Database Down My database is up and with no data loss!!!  I was able to do a complete recovery, not incomplete. After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday.  The control files 1 and 2 were restored because they were on the corrupted disks, but I had a 3rd copy which I used to recover the database.  It worked just like Case 4 and all is well. Just a note, I am glad I had another copy of the control file.  When I tried to use the file that had been restored I received an 'old controlfile' error.  I do have the Backup and Recovery book by Rama Velpuri (v7.3) and it helped.  This is one of those things I have wanted to do but have never had time to do...  It has been about 3 years since I took the class and the 'use it or lose it' scenario has taken over. Thanks to all who replied!! Laura -----Original Message----- From: Jared Still [mailto:jkstill@cybcon.com] Sent: Wednesday, May 23, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Subject: Re: Database Down On Wednesday 23 May 2001 01:00, Paul Drake wrote: > > 0. caffeine. Agreed. > 2. You *will* be performing incomplete recovery. Recover until cancel, > preferably with a backup controlfile. >    Did you create a backup controlfile as part of the hot backup on May > 11th? Restore with that controlfile. Is there a particular reason for recommending the backup controlfile? Shouldn't be needed unless the controlfile has been lost. > 3. After the recovery is completed (you've opened RESETLOGS) close the > database and get a *full* cold backup. Fight the urge to *get the Some repetition for emphasis here.  As Paul says, a cold backup must be completed before any work is done on the database.  Some add'l advice for Laura.  Read Rama Velpuri's book 'Oracle Backup and Recovery Handbook' cover to cover, and do all of the exercises.  It will make an immense difference in your understanding of recovery. Backup is easy, recovery is not always so. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still   INET: jkstill@cybcon.com 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: ListGuru@fatcity.com (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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.