Guille Asked: 2010-06-19 08:20:33 +0800 CST2010-06-19 08:20:33 +0800 CST 2010-06-19 08:20:33 +0800 CST Oracle RMAN Full Database Recovery 772 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? oracle rman 1 Answers Voted fairwaywood 2010-06-19T14:38:25+08:002010-06-19T14:38:25+08:00 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.
If you have a proper backup, you can specify the point in time of the restore as follows:
Look into Oracle documentation at http://tahiti.oracle.com for your specific Oracle version for more details.
IC.