The only thing I can think of is, if it has been enabled, with flashback database. To verify if flashback database has been enabled query the v$database view for the column flashback_on. If is has been enabled you can query v$flashback_database_log for the oldest time to which you can flash back. Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer --- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain Sent: woensdag 2 februari 2011 20:41 To: Oracle-L Freelists Subject: point in time recovery when there is no backup ? 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 -- //www.freelists.org/webpage/oracle-l