Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Jun 19 '10 at 2:18

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

1 Answer 1

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

 RUN
 { 
     SET UNTIL SCN 1000;    
     # Alternatives:
     # SET UNTIL TIME 'Nov 15 2004 09:00:00';
     # SET UNTIL SEQUENCE 9923;  
     RESTORE DATABASE;
     RECOVER DATABASE;
  }

Look into Oracle documentation at http://tahiti.oracle.com for your specific Oracle version for more details.

IC.

share|improve this answer
1  
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

 
discard

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.