Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to restore a full database backup of a database in noarchivelog, but not the last backup. How can I select the full backup to restore?

share|improve this question

migrated from Jun 19 '10 at 2:18

This question came from our site for professional and enthusiast programmers.

If you have a proper backup, you can specify the point in time of the restore as follows:

     SET UNTIL SCN 1000;    
     # Alternatives:
     # SET UNTIL TIME 'Nov 15 2004 09:00:00';
     # SET UNTIL SEQUENCE 9923;  

Look into Oracle documentation at for your specific Oracle version for more details.


share|improve this answer
In NOARCHIVELOG mode you can't do a point in time recovery - where are the archive logs to get you there? – Gaius Oct 24 '10 at 13:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.