cancel
Showing results for 
Search instead for 
Did you mean: 

how to ensure data integrity

terry123
Regular Advisor

how to ensure data integrity

hi All,

may i know how can i ensure the data integrity under HPUX?

since i need to migrate data from VA to EVA, after the data migration, anyway to ensure/check the data integrity?

thx.

b.r.
terrytse
6 REPLIES
Patrick Wallek
Honored Contributor

Re: how to ensure data integrity

How are you migrating the data?

One option is to generate a check sum (using 'cksum' or 'md5sum' if you have installed) for each file before you migrate. Once the migration is done, you generate the check sum again and then compare.

If the data you are migrating are database files, and you are migrating the data while the database is up, then this may not work as DB files are always changing.

If you migrate the data with a DB down, then the check sum method should work fine.
terry123
Regular Advisor

Re: how to ensure data integrity

thx Partick,

but do i need to make a checksum comparison file by file?

b.r.
terrytse
Dennis Handly
Acclaimed Contributor

Re: how to ensure data integrity

>do i need to make a checksum comparison file by file?

Yes, cksum only works on a file, unless you tar up a bunch of files and you cksum that.

What did you want to do?
terry123
Regular Advisor

Re: how to ensure data integrity

hi Dennis,

since i will migrate my Oracle Data File from VA to EVA, would like to make sure the data integrity after the files movement.

thx.

b.r.
terrytse
Patrick Wallek
Honored Contributor

Re: how to ensure data integrity

How are you going to migrate the data?

Are you going to shut down the Oracle DB(s) and copy the files? Or are you going to migrate while the DB is up and running?
terry123
Regular Advisor

Re: how to ensure data integrity

hi Patrick,

Database will be shutdown, then copy the data file from VA to EVA.

thx.

terrytse