From oracle-l-bounce@freelists.org Sun Oct 30 19:45:10 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9V1j9QF003544 for ; Sun, 30 Oct 2005 19:45:09 -0600 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 j9V1j2vX003524 for ; Sun, 30 Oct 2005 19:45:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E045212CC1; Sun, 30 Oct 2005 20:45:00 -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 27038-01; Sun, 30 Oct 2005 20:45:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 94108212BD7; Sun, 30 Oct 2005 20:44:59 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 30 Oct 2005 20:43:04 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A261212B54 for ; Sun, 30 Oct 2005 20:43:04 -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 26347-06 for ; Sun, 30 Oct 2005 20:43:03 -0500 (EST) Received: from web60715.mail.yahoo.com (web60715.mail.yahoo.com [209.73.178.218]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C8930212972 for ; Sun, 30 Oct 2005 20:43:03 -0500 (EST) Received: (qmail 45164 invoked by uid 60001); 31 Oct 2005 01:43:03 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Fl7QCTbWhrwO5GzAI5mNv9lVt/i9JCJ1tlvF6HQNLqd+KqqpA42qPRB+ugymb0vFqijdbCHOQZ+D/0jXkBtJklY6S+PjEPqS0yblfvAz5KnaiauLZL88ZDWmXIc4PsVZsrrpZKHhsMrZfMRvoTbZ+UwI3DKCnvRlstkWzwBMskY= ; Message-ID: <20051031014303.45162.qmail@web60715.mail.yahoo.com> Received: from [192.128.167.68] by web60715.mail.yahoo.com via HTTP; Sun, 30 Oct 2005 17:43:03 PST Date: Sun, 30 Oct 2005 17:43:03 -0800 (PST) From: A Joshi Subject: ** fall back backups To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-120340245-1130722983=:45112" X-archive-position: 27818 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ajoshi977@yahoo.com Precedence: normal Reply-To: ajoshi977@yahoo.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-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.8 required=5.0 tests=BAYES_00,FROM_ENDS_IN_NUMS, HTML_MESSAGE autolearn=no version=2.63 --0-120340245-1130722983=:45112 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, Now that clocks have been set back one hour (in us of a etc), it is time to bounce the databases. Since Oracle says it needs to be done (read some analyst in a TAR said it). Is it for backups? I agree time based recovery to a point in time could lead to issues. However, will it affect the regular recovery until cancel which I think goes by SCN/log #. Please correct me if I am wrong. Also once you have a couple of backups after the fall back resetting of clock is it still necessary to bounce databases and immediately take 2 backups? Apart from backups does setting the clock back affect anything else on the database? Thanks --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. --0-120340245-1130722983=:45112 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
  Now that clocks have been set back one hour (in us of a etc), it is time to bounce the databases. Since Oracle says it needs to be done (read some analyst in a TAR said it).
Is it for backups? I agree time based recovery to a point in time could lead to issues. However, will it affect the regular recovery until cancel which I think goes by SCN/log #. Please correct me if I am wrong.
Also once you have a couple of backups after the fall back resetting of clock is it still necessary to bounce databases and immediately take 2 backups?
  Apart from backups does setting the clock back affect anything else on the database? Thanks


Yahoo! FareChase - Search multiple travel sites in one click. --0-120340245-1130722983=:45112-- -- http://www.freelists.org/webpage/oracle-l