Re: HDR and onunload

In article <341de777.12830974@10.209.30.200>, Jason Harris <jharris@westpac.com.au> writes >Dear All, > >DSA 7.14 on NCR running HDR. > >We are trying to do onunload on our secondary read-only server but >find the data to be corrupted when we onload it to our test box. No >errors are reported during the onunload. > Remember that onunload is a BINARY copy of the data. You must have a) Same versions of Online on both machines b) Same OS and OS version on both machines c) Same hardware on both machines Are you sure that the secondary server is not say a Intel CPU and the test server a Sparc CPU? Try doing a straight unload to "file" select * from <table> and see if that looks ok and loads ok. >I cannot find anything in the manual but believe there is a problem >with this, and possibly other, utilites when run on a secondary. > >Basically onunload usually has an exclusive lock on the database that >is being unloaded. On the secondary server this is not possible as >there could be changes made on the primary that affect the database. >These happen via the log buffers so the onunload may not be aware of >changes to the database while it is unloading pages. > >Anyone had similar experiences or know anything about this? > >Regards, > >Jason > -- David Williams