PIT Restore
Posted in 2010
Hello,
I am testing PIT restores using different levels of the archives and do not
seem to be able to stop at my level 0 w/o altering the ixbar file. More
specifically, I am
1. level 0 archive (onbar -b -w -p -L 0)
2. change logical log and execute checkpoint
3. drop database
4. change log and issue checkpoint
5. level 1 archive (onbar -b -w -p -L 1)
6. change log and exececute checkpoint
7 restore this is where I cannot seem to stop at the level 0. I have tried
onbar -r -w -p -t using the time the level 0 archive started and onbar -r -w
-p -n log number from step 2.
My database is still gone at this point and looking at the BAR_ACT_LOG it is
clear as to why. The level 1 archive was also restored. Am I missing
something? As a side note, I can remove the level 1 info from the ixbar file
and all is well however I am trying to eliminate having to do that with the
PIT.
Thanx,
Dan