3

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?

Improve this question

1 Answer 1

Reset to default
2

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.

Improve this answer
1
  • 1
    In NOARCHIVELOG mode you can't do a point in time recovery - where are the archive logs to get you there? Commented Oct 24, 2010 at 13:54

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.