From oracle-l-bounce@freelists.org Sat Sep 24 18:27:41 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8ONRfXN000368 for ; Sat, 24 Sep 2005 18:27:41 -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 j8ONRb6H000358 for ; Sat, 24 Sep 2005 18:27:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4D341EF1AB; Sat, 24 Sep 2005 18:27:35 -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 21995-08; Sat, 24 Sep 2005 18:27:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 125171EEF66; Sat, 24 Sep 2005 18:27:35 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=cMWrEMDs/Ii7CGH2BU90wo9YggMQwwicOVysGDmLYMRpCzRkaalZVN8XUV05qzL0sXZTxvKgeX+DJH4vJXzPaRrEVQOOJWrBNv4lhLvPppFPp1CX/E8ok45OIsYGp76HxM/TgBIUHaCAUiTL5KqcsPcM66Dl3JTA2HAdYRl7+jA= Message-ID: <910046b4050924162516d41239@mail.gmail.com> Date: Sat, 24 Sep 2005 19:25:36 -0400 From: Paul Drake To: prabhu_adam@hotmail.com Subject: Re: Oracle Complete Recovery. Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18865_15972773.1127604336128" References: X-archive-position: 25861 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bdbafh@gmail.com Precedence: normal Reply-To: bdbafh@gmail.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=-3.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_18865_15972773.1127604336128 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/24/05, Prabhu, K wrote: > > 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 > > Did you ask him back "what version? (African of European?) Did you ask him if the online redo logs were available? (a requirement for complete recovery) Did you ask him if a copy of the current controlfile was available? SQL> set autorecovery on SQL> recover database; and you should see something along the lines of "media recovery complete". SQL> alter database open noresetlogs; statement processed. such material is covered in the "user managed backup/recovery" docs on otn. Pd ------=_Part_18865_15972773.1127604336128 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 9/24/05, Prabhu, K <prabhu_adam@hotmail.com> wrote:
All,

In an interview I'm asked this question that, how will you do c= omplete
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
r= evocery.

But my interviewer was not statisfied with my answer and he= asked me is
there any other way you can recover the database without us= ing alter
database command.

As the interviewer said is there any other way= we can do that ?

your help is deeply appreciated.

Thanks.Prabhu


Did you ask him back "what versio= n? (African of European?)
Did you ask him if the online redo logs were available?
(a requirement for complete recovery)
Did you ask him if a copy of the current controlfile was available?

SQL> set autorecovery on
SQL> recover database;

and you should see something along the lines of "media recovery comple= te".

SQL> alter database open noresetlogs;
statement processed.

such material is covered in the "user managed backup/recovery" do= cs on otn.

Pd



------=_Part_18865_15972773.1127604336128-- -- http://www.freelists.org/webpage/oracle-l