Date: 11/2010
NV Version: All
OS Version: ALL
Plugin Version: Oracle 6.0.19
Application version: Oracle
Description: An Oracle RMAN PIT restore based on time fails with the error:
UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
Solution/Workaround.
The problem seems to be that the user is inputting a time before the actual backup was done.
For instance, if we had a backup that was done on the 10/10/2010 at 11:00AM and the selected PIT time was 10:00AM the error will occur. Instead we should put the time as 11:XX AM (not exactly at 11:00 because the backup may have finished sometimes later). In this case the DB will be restored and the archive logs will be applied. It is important that we use the time of the client hosting the Oracle database and not that of the NVBU server just in case they are in different time zone.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center