Re: point in time recovery when there is no backup ?

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 2 Feb 2011 12:00:11 -0800 (PST)
Message-ID: <7556.11759.qm_at_web65414.mail.ac4.yahoo.com>

You cannot in this circumstance as you have no starting point from which to apply older logs. It doesn't matter that you have the logs available, the database has long since left any earlier starting point in the dust without a backup from that time.  

David Fitzjarrell  

---

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> To: TESTAJ3_at_nationwide.com
Cc: Oracle-L Freelists <oracle-l_at_freelists.org>; oracle-l-bounce_at_freelists.org Sent: Wed, February 2, 2011 1:50:34 PM
Subject: Re: point in time recovery when there is no backup ?

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_at_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, <TESTAJ3_at_nationwide.com> 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 <sjaffarhussain_at_gmail.com>
>>To: Oracle-L Freelists <oracle-l_at_freelists.org>
>>Date: 02/02/2011 02:43 PM
>>Subject: point in time recovery when there is no backup ?
>>Sent by: oracle-l-bounce_at_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
>>
>>
>
      

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

Received on Wed Feb 02 2011 - 14:00:11 CST