onbar Restore Prod to Dev
Posted in 2009
Hi All,
Just want to validate if my procedure is correct. We have a production DB and
i want to restore into a Dev environment. Backup created is through "onbar"
using "onbar -b -L 0" and "onbar -b -l". I want to restore into Dev env using
onbar utility.
Here's the procedure i'm going to do:
Assumming : the backup in Prod is available.
On Restore Server, here's i'm going to do:
1. copy the ixbar and oncfg.ifxserver into the Dev env ($INFORMIXDIR/etc).
2. backup the original files on the restore server, namely, oncfg.xxx and
ixbar.xxx
3. Since, I've already have the ixbar and oncfg.xx files into the restore
server, does the onbar utility knows the location of the files to restore? If
not, how should i know that the restore server is pointing to the correct
backup?.
4. Once the question on number 3 is ok, i will execute the "onbar -r -p" -- to
restore the physical...
5. then, i will execute "onbar -r -l" to restore the logical logs.
6. do i need to execute "onsmsync" also to sync the restore against sysmaster?
Kindly let me know if my procedure is correct.
Thanks and Regards,