This content has been marked as final. Show 6 replies
Hello;1 person found this helpful
If you use the other based on your log piece you will not get the Control file or Spfile and you will probably have to deal with an error.
Keep in mind the until or to restore point is always an incomplete recovery.
hi, Thanks for the response. I thought same. What happens if I use time - 9:29:00 in the until clause? Will it ask more arch logs for the recovery?
I have never tried that on a duplicate.1 person found this helpful
I would assume it would prompt for archive since it would know what archive is next and RMAN does on every other recovery I try.
Since, this is a cold backup.. I believe using set until time - 09:28:58, perfectly runs the duplicate and opens the database. Do you agree? I mean presuming that it not encounters some other error, from a set until time perspective, 9:28:58 should run perfect right?
Yes, that is what I would do.
I tried to find in the docs where you could "Provide the archive RMAN needs" but so far I don't have an exact quote.
I will keep looking.
Best Regards ( and Happy New Year )
Found an interesting note comparing UNTIL TIME and UNTIL SCN
With UNITL TIME, the time gets evaluated twice for both restore and recovery. So if you are using SYSDATE (start after midnight).
Edited by: mseberg on Dec 31, 2012 7:36 PM
Kind of interesting :
The table here hints about RMAN asked for Archive.
Edited by: mseberg on Dec 31, 2012 7:40 PM
I will not be using SYSDATE, Instead, I will go with time stamp when control file auto backup finished.
Thanks for your help, Wish you a very Happy New Year too.