From oracle-l-bounce@freelists.org Fri Jul 23 09:12:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6NEC5e07993 for ; Fri, 23 Jul 2004 09:12:16 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6NEBs607940 for ; Fri, 23 Jul 2004 09:12:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE6B872C766; Fri, 23 Jul 2004 08:50:54 -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 22112-58; Fri, 23 Jul 2004 08:50:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0638972CC89; Fri, 23 Jul 2004 08:50:31 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 23 Jul 2004 08:48:46 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C601D72C202 for ; Fri, 23 Jul 2004 08:48:42 -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 21678-13 for ; Fri, 23 Jul 2004 08:48:42 -0500 (EST) Received: from mail.abwf.com (mail.abwf.com [65.114.91.24]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF7FC72C828 for ; Fri, 23 Jul 2004 08:48:40 -0500 (EST) Received: from mail01.abwf.com [172.16.18.12] by mail.abwf.com [172.16.19.47] (CMSPraetor 5.10.4411) with ESMTP id A3C2CBFD806A493CA0C683C83F2CC290 for ; Fri, 23 Jul 2004 10:12:26 -0400 Received: by mail01.corp.abwf.com with Internet Mail Service (5.5.2655.55) id <3QA90CR4>; Fri, 23 Jul 2004 10:12:25 -0400 From: Muqthar Ahmed To: "'oracle-l@freelists.org'" Message-ID: <6362087FB073D41195B800D0B78284BE09813D61@mail01.corp.abwf.com> Subject: RE: Urgent Help - advise Date: Fri, 23 Jul 2004 10:12:23 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5852 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Muqthar.Ahmed@decoratetoday.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Sanjay, After fixing hardware on Production server, I think you can create Physical Standby Database and later switch it as Primary. Can anyone comment on this......what would you do if you get into such situation? Thanks Muqthar -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Sanjay Mishra Sent: Thursday, July 22, 2004 10:00 PM To: oracle-l@freelists.org Subject: RE: Urgent Help - advise Thanks Riyaz. I had already switchover to standby as production cannot be stopped. THe old primary is still down as sysadmin are working with HP support for the hardware support Thanks sanjay Riyaj Shamsudeen wrote: Hi Sanjay Your question was not clear. So, I am assuming you are trying to convert the former primary to current standby, so that you can switch over later. If this assumption is correct, then the answer 'it depends'. If you have switched over to the standby database gracefully, then you can restore just those four tablespaces and recover the former primary and convert it to standby. Basic premise is that 1) all the redo generated from the primary was propagated to the standby db before the switch 2) Former primary did not generate any redo by itself after the switch and so former primary is essentially a backup of the current primary. If this premise holds good, then you can restore those 4 tablespaces alone and recover them.. But, If you have kept the primary open after the switch, thereby generating redo or if you have used resetlogs to open the secondary (for some reason), then you must use the current primary (or its backup) to rebuild the standby database. Let me know if I misunderstood your question.. HTH Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Sanjay Mishra Sent: Thursday, July 22, 2004 1:27 PM To: oracle-l@freelists.org Subject: Urgent Help - advise Hello everybody I need the expert advice and direction to one of the following situation I have Oracle 9i Rel 2 with physical sstandby server. yesterday I lost one of the drive and so I switchover to standby server yesterday. today I was informed that we cannot recover the drive which contain for tablespace and so what is the best method to recover this scenario. The database is 800G and so do I need to restore the whole databasse to recover it or still I can take use the old four tablespaces from backkup and recover it. thanks for your help Sanjay --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Attached file included as plaintext by Ecartis -- -- Desc: Signature The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Yahoo! Mail - You care about security. So do we. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- * * * * * * * * * The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------