Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Complete Recovery.

RE: Oracle Complete Recovery.

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Mon, 26 Sep 2005 09:11:53 +0100
Message-ID: <>

        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.".


-----Original Message-----

From: Prabhu, K [] Sent: 24 Sep 2005 17:24
Subject: Oracle Complete Recovery.


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.



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.

-- Received on Mon Sep 26 2005 - 03:14:05 CDT

Original text of this message