Received: (qmail 15210 invoked from network); 2 Feb 2011 13:47:47 -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; 2 Feb 2011 13:47:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 44BE2D64CD1; Wed, 2 Feb 2011 14:47:32 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1296676052; bh=uM9K0tGd3zhLzWKv12lYnm6sXf8xuna8kVABWPMu p6g=; h=In-Reply-To:References:To:Cc:MIME-Version:Subject: Message-ID:From:Date:Content-Type:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=ISmffVHSHkM3xt1Kr+sf0O6hYdM1n+QTkDlmeqm6p31iuS/ZNc l7igbnSp2gMHX2NdNmfcYrB8iZ6YbHG1BOr1QFdKU2Ey3yBsn2YhYKc9ErZD4qhvbSA ryRFXSY/NiSf+kmpD1fg8+AoDtk8nKlTAB39DXq8iXasTIHDf5iOIs= 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 mRTkY1emrPaA; Wed, 2 Feb 2011 14:47:32 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A69ECD64C98; Wed, 2 Feb 2011 14:46:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Feb 2011 14:46:07 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B747D64C48; Wed, 2 Feb 2011 14:46:07 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (512-bit key) header.i=TESTAJ3@nationwide.com 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 VPiV-gvoqSlI; Wed, 2 Feb 2011 14:46:07 -0500 (EST) Received: from blackagar.nationwide.com (blackagar.nationwide.com [155.188.232.15]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 645EFD64A1A; Wed, 2 Feb 2011 14:46:02 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nationwide.com; i=TESTAJ3@nationwide.com; l=3640; q=dns/txt; s=columbus.ohio; t=1296675965; x=1328211965; h=in-reply-to:references:to:cc:mime-version:subject: x-keepsent:x-mailer:message-id:from:date:x-mimetrack: content-type; z=In-Reply-To:=20|References:=20|To:=20sjaffarhu ssain@gmail.com|Cc:=20Oracle-L=20Freelists=20,=0D=0A=09oracle-l-bounce@freelists.org |MIME-Version:=201.0|Subject:=20Re:=20point=20in=20time =20recovery=20when=20there=20is=20no=20backup=20? |X-KeepSent:=20822973FA:1D85B4AE-8525782B:006C6C69=3B=0D =0A=20type=3D4=3B=20name=3D$KeepSent|X-Mailer:=20Lotus=20 Notes=20Release=208.0.2FP4=20SHF9=20February=2002,=202010 |Message-ID:=20|From:=20TESTAJ 3@ nationwide.com|Date:=20Wed,=Received: from sbbaws965.nwideweb.net ([10.221.148.8]) by blackagar.nationwide.com with ESMTP; 02 Feb 2011 14:45:59 -0500 Received: from ohcollbp0004.nwie.net (HELO EntDDCMail09.nwie.net) ([172.24.119.20]) by sbbaws965.nwideweb.net with ESMTP; 02 Feb 2011 14:45:59 -0500 In-Reply-To: References: To: sjaffarhussain@gmail.com Cc: Oracle-L Freelists , oracle-l-bounce@freelists.org MIME-Version: 1.0 Subject: Re: point in time recovery when there is no backup ? X-KeepSent: 822973FA:1D85B4AE-8525782B:006C6C69; type=4; name=$KeepSent Message-ID: From: TESTAJ3@nationwide.com Date: Wed, 2 Feb 2011 14:45:59 -0500 X-MIMETrack: Serialize by Router on EntDDCMail09/SRV/NWIE(Release 8.5.1FP3 HF243|July 06, 2010) at 02/02/2011 02:46:00 PM, Serialize complete at 02/02/2011 02:46:00 PM Content-Type: multipart/alternative; boundary="=_alternative 006C94588525782B_=" X-archive-position: 34091 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: TESTAJ3@nationwide.com Precedence: normal Reply-To: TESTAJ3@nationwide.com 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 --=_alternative 006C94588525782B_= Content-Type: text/plain; charset="US-ASCII" Well for all intents and purposes, point in time recovery has to have a point to start and roll forward from there, with no backup, you dont have a starting point. I say that because you can do rewinding of databases now using Flashback DB, but unless you set that up and have all of the flashback logs to where in time you want to rewind to, I think you're completely out of luck. joe _______________________________________ Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668 (Cell) 614-312-6715 From: Syed Jaffar Hussain To: Oracle-L Freelists Date: 02/02/2011 02:43 PM Subject: point in time recovery when there is no backup ? Sent by: oracle-l-bounce@freelists.org Dear List, I have an Oracle database configured in Archivelog mode running for the past couple months. Unfortunately, there is no backup has been taken so far, however, I am in need to clone the database back in time. Is this possible I can duplicate this database back in time? Any points suggestion would be a great help. Regards, Jaffar --=_alternative 006C94588525782B_= Content-Type: text/html; charset="US-ASCII"
Well for all intents and purposes, point in time recovery has to have a point to start and roll forward from there, with no backup, you dont have a starting point.

I say that because you can do rewinding of databases now using Flashback DB, but unless you set that up and have all of the flashback logs to where in time you want to rewind to,

I think you're completely out of luck.

joe

_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715


From: Syed Jaffar Hussain <sjaffarhussain@gmail.com>
To: Oracle-L Freelists <oracle-l@freelists.org>
Date: 02/02/2011 02:43 PM
Subject: point in time recovery when there is no backup ?
Sent by: oracle-l-bounce@freelists.org




Dear List,

I have an Oracle database configured in Archivelog mode running for the past couple months. Unfortunately, there is no backup has been taken so far, however, I am in need to clone the database back in time. Is this possible I can duplicate this database back in time? Any points suggestion would be a great help.

Regards,

Jaffar

--=_alternative 006C94588525782B_=-- -- http://www.freelists.org/webpage/oracle-l