From oracle-l-bounce@freelists.org Mon Sep 26 03:14:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8Q8E4x5001656 for ; Mon, 26 Sep 2005 03:14:05 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8Q8Du6H001610 for ; Mon, 26 Sep 2005 03:13:56 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AC381EF3AC; Mon, 26 Sep 2005 03:13:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10000-10; Mon, 26 Sep 2005 03:13:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8EB031EF3BD; Mon, 26 Sep 2005 03:13:52 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: GJohnson@gam.com X-Msg-Ref: server-4.tower-58.messagelabs.com!1127722316!93453134!1 X-StarScan-Version: 5.4.15; banners=-,-,- X-Originating-IP: [193.202.231.225] Message-ID: From: "Johnson, George" To: "'prabhu_adam@hotmail.com'" , oracle-l@freelists.org Subject: RE: Oracle Complete Recovery. Date: Mon, 26 Sep 2005 09:11:53 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-archive-position: 25876 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: GJohnson@GAM.COM Precedence: normal Reply-To: GJohnson@GAM.COM X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.6 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Just some thoughts on this, may be a little OT. I always ask to have the interviewer clarify the exact situation as they see it. I despise people who panic, "Oh DB has crashed and it's corrupted, quick get all the backups and all the logs and a new server and...". When you actually look at it, it crashed and one temporary tempfile can't be found! In this instance ask them to clarify exactly what happened, then assure him you will start with a good look through the alert logs and trace files, if still possible, then work from there. Say you will order up the tapes just in case, if they're offsite, then make a thorough investigation ASAP. This could be a simple test to see if you panic over what may be potentially nothing, like a missing tempfile! If they want to go further, then you can say, "well after checking, if I found only one file, I simply restore that, if required, then recover the file off the logs". Then deeper if the corruption is worse. Getting tight down to a full restore/full recovery only as a last resort, clarifying tech details only as required. I got caught out once at an interview, years ago. "Reports coming in about prod database down, what would you do?", I started banging on about alert logs, trace files and recovery and the interviewer turned round and said "Well actually, the help desk only got two calls from a 3,000 user base. A simple check on the PCs first, would have uncovered that their network cables had just been pulled by accident by a cleaner, vacuuming.". Rgds -----Original Message----- From: Prabhu, K [mailto:prabhu_adam@hotmail.com] Sent: 24 Sep 2005 17:24 To: oracle-l@freelists.org Subject: Oracle Complete Recovery. All, In an interview I'm asked this question that, how will you do complete recovery for a database which is running in archivelog mode. I answered as first I'll restore all the backups then I'll mount the database, then I'll start the recovery by using command alter database revocery. But my interviewer was not statisfied with my answer and he asked me is there any other way you can recover the database without using alter database command. As the interviewer said is there any other way we can do that ? your help is deeply appreciated. Thanks. Prabhu -- http://www.freelists.org/webpage/oracle-l **************************************************************************** This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as an invitation or offer to buy or sell any securities or related financial instruments. GAM operates in many jurisdictions and is regulated or licensed in those jurisdictions as required. **************************************************************************** -- http://www.freelists.org/webpage/oracle-l