RE: Oracle Complete Recovery.

  • From: "Johnson, George" <GJohnson@xxxxxxx>
  • To: "'prabhu_adam@xxxxxxxxxxx'" <prabhu_adam@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 26 Sep 2005 09:11:53 +0100

        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 [mailto:prabhu_adam@xxxxxxxxxxx] 
Sent: 24 Sep 2005 17:24
To: oracle-l@xxxxxxxxxxxxx
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 

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.


Other related posts: