-
Hi,
I tried this time based recovery stuff and it dint work.
i needed to recover using a cold backup till 15:45
so i gave the command
RECOVER DATABASE UNTIL TIME '2002-09-02:15:45:00';
AND IT GAVE ME THIS ERROR!
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF'
Now I want to recover data only till this time, but I thought some data associated with this would be in the next log file.
But the system gave me error for each log file , asking for the next logfile, and in the end giving me the latest data , while I needed the data till the specified time.
Can anyone help me with this , as to where i might have gone wrong?
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|