Received: (qmail 22402 invoked from network); 3 Mar 2010 09:45:23 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2010 09:45:20 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 96B61CD7A08; Wed, 3 Mar 2010 10:45:16 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PpzUSImPbjbV; Wed, 3 Mar 2010 10:45:16 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 97098CD79D7; Wed, 3 Mar 2010 10:44:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2010 10:43:53 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1144CD7908 for ; Wed, 3 Mar 2010 10:43:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nNZHa1ujXU4a for ; Wed, 3 Mar 2010 10:43:52 -0500 (EST) Received: from sbg01.cronos.be (mx.cronos.be [94.143.184.53]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 90D29CD7948 for ; Wed, 3 Mar 2010 10:43:52 -0500 (EST) X-AuditID: ac1effb5-b7bc6ae000000c4c-aa-4b8e83b6b801 Received: from ws03-exch07.iconos.be (Unknown_Domain [10.0.10.69]) by sbg01.cronos.be (Cronos AntiSpam Gateway) with SMTP id 75.F4.03148.6B38E8B4; Wed, 3 Mar 2010 16:43:50 +0100 (CET) Received: from ws03-exch07.iconos.be ([10.0.10.69]) by ws03-exch07.iconos.be ([10.0.10.69]) with mapi; Wed, 3 Mar 2010 16:43:50 +0100 From: D'Hooge Freek To: "pobrien@controller.state.nv.us" , ORACLE-L Date: Wed, 3 Mar 2010 16:44:13 +0100 Subject: RE: flash it back then roll it forward(pitr) Thread-Topic: flash it back then roll it forward(pitr) Message-ID: <4814386347E41145AAE79139EAA398980DC8495D7F@ws03-exch07.iconos.be> References: <4B8E0FC4.83D7.0016.3@controller.state.nv.us> In-Reply-To: <4B8E0FC4.83D7.0016.3@controller.state.nv.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis MIME-Version: 1.0 X-Brightmail-Tracker: AAAAAA== X-archive-position: 26248 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Freek.DHooge@uptime.be Precedence: normal Reply-To: Freek.DHooge@uptime.be List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l I know you can recover a flashed back database as long as you did not open it in read write. So, it seems locial that you can specify an until time during the recovery.   Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@uptime.be tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer ________________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Patrick O'Brien Sent: woensdag 3 maart 2010 16:29 To: ORACLE-L Subject: flash it back then roll it forward(pitr) Hello Oracle users,   is it possible to flashback a database then turn around and roll it forward using a pitr process?   thank you!     -- http://www.freelists.org/webpage/oracle-l