RE: Migration validation to OCI
Date: Sun, 14 Apr 2024 09:29:40 -0400
Message-ID: <151301da8e6f$ce961fb0$6bc25f10$_at_rsiz.com>
A fairly standard minimum is the number of rows in each user table and the sum of the values of numeric columns in each table. The CDP exam circa 1982 called these “control totals.”
A more aggressive verification is to also pipe the text fields through a hasher and compare the hash values.
A reverse migration of all the data back to the original machine (even one user table at a time if space is a problem) with a full row by row, column by column comparison is comprehensive, but the cost versus the benefit does need to be considered. (This can also be done between OCI and the existing machine, but usually the network latency doing things row by row makes a back load of the data more performant.)
Good luck,
mwf
PS: I presume your OCI means Oracle Cloud Infrastructure, not Oracle Call Interface
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eriovaldo Andrietta
Sent: Sunday, April 14, 2024 8:28 AM
The goal is to check only in the context of objects and not configuration (v$parameters, tablespaces, resource manager and other structures).
What else could be validated?
To: ORACLE-L
Subject: Migration validation to OCI
Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Apr 14 2024 - 15:29:40 CEST