Received: (qmail 15390 invoked from network); 2 Feb 2011 13:52:58 -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:52:46 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64F84D64D69; Wed, 2 Feb 2011 14:52:16 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1296676336; bh=I6dxU2dwt/fz+cS4FIz0LTNYqleLKTLIjVVMybR/ KOA=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-Type:Sender:Reply-To:List-help:List-unsubscribe: List-Id:List-subscribe:List-owner:List-post:List-archive; b=ZSu6d7 Ys0Ux5yuv8qpCz9pqRdKOf8HDM6OXNpQL4qvC207WRCR6dSdKRsTPQEdpaEeDgjhsrZ g9SY9S5OCLLA+3cG5IX8tfSvc/oj04dGoHk8WpMzOamrTST1gpnU+xMWEGGVafHLof7 pmjfDE8Zqc7sybbTSY8neOshwVDavoo= 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 gbGqSzRRhf17; Wed, 2 Feb 2011 14:52:16 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22CDDD64D49; Wed, 2 Feb 2011 14:51:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Feb 2011 14:50:50 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 88A9FD64CDC; Wed, 2 Feb 2011 14:50:50 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@gmail.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 9LMLSe0YOpCj; Wed, 2 Feb 2011 14:50:50 -0500 (EST) Received: from mail-iy0-f179.google.com (mail-iy0-f179.google.com [209.85.210.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 020A7D64C80; Wed, 2 Feb 2011 14:50:47 -0500 (EST) Received: by iye19 with SMTP id 19so317403iye.10 for ; Wed, 02 Feb 2011 11:50:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=x7O9EA4jsTxH5kImf3lnEXqBaFl5o3DSkvBA8qsUAO8=; b=FDfAxFZkuwh4Nt11GEalzlC2ysOvemk+oVOFyKMfTUdWZf6PS04Q6N1/64bPJFHKPX OZT7GcBtBjH7RhKt9R0RhrLdJikBpB+tbER4qmeixDrjPHStP9KQb6cou/3UhbZowhp7 G/5U5svVXXCm/x4bktYiiKOssOh88/lzS9U9o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=usydzQqYDwbE710XvE53m/4V2+NgqCwkDCTvazrCkXPwHpyneIobxkdMThkIv/ozRw 0Bcz095+yhIAOLNvGagDNXrN1YDTocrQkfVxMbU9oHH8LJIEnJ6ZT5MnefazMxxd0hzD 9WBOE8oQaFwNZAyRXS6j9k+P5JLi/Zrhgwr+o= MIME-Version: 1.0 Received: by 10.231.35.5 with SMTP id n5mr10522412ibd.159.1296676234787; Wed, 02 Feb 2011 11:50:34 -0800 (PST) Received: by 10.231.40.2 with HTTP; Wed, 2 Feb 2011 11:50:34 -0800 (PST) In-Reply-To: References:

Date: Wed, 2 Feb 2011 22:50:34 +0300 Message-ID: Subject: Re: point in time recovery when there is no backup ? From: Syed Jaffar Hussain To: TESTAJ3@nationwide.com Cc: Oracle-L Freelists , oracle-l-bounce@freelists.org Content-Type: multipart/alternative; boundary=00032555ce965cfe06049b51f69c X-archive-position: 34094 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: sjaffarhussain@gmail.com Precedence: normal Reply-To: sjaffarhussain@gmail.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 --00032555ce965cfe06049b51f69c Content-Type: text/plain; charset=ISO-8859-1 Just to make the point clear. Neither there is any prior backup nor any flashback feature is enabled. The db is in archive log mode and fortunately all the archive logs are available. I need to duplicate this database to back in time, probably a day before. Regards, On Wed, Feb 2, 2011 at 10:48 PM, Syed Jaffar Hussain < sjaffarhussain@gmail.com> wrote: > I do agree with you. Just trying out for my luck if any one would come to > my (actually my friend's) rescue in this context. > > > On Wed, Feb 2, 2011 at 10:45 PM, wrote: > >> >> 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 >> >> > --00032555ce965cfe06049b51f69c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Just to make the point clear. Neither there is any prior b= ackup nor any flashback feature is enabled. The db is in archive log mode a= nd fortunately all the archive logs are available. I need to duplicate this= database to back in time, probably a day before.

Regards,

On Wed, Feb 2, 20= 11 at 10:48 PM, Syed Jaffar Hussain <sjaffarhussain@gmail.com> wrote:

I do agree with you. =A0Ju= st trying out for my luck if any one would come to my (actually my friend&#= 39;s)=A0rescue in this context.

On Wed= , Feb 2, 2011 at 10:45 PM, <TESTAJ3@nationwide.com> wr= ote:

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 rewi= nding 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@gma= il.com>
To: Oracle-L Freelists <oracle-l@freelists.or= g>
Date: 02/02/2011 02:43 PM
Subject: point in time recovery when t= here is no backup ?
Sent by: oracle-l-bounce@freelists.org

Dear List,

I have an Oracle database configured in Archivelog mod= e 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

--00032555ce965cfe06049b51f69c-- -- http://www.freelists.org/webpage/oracle-l