Since OS on both Exadata and OCI is Linux, why don’t use Dataguard Standby
based migration approach and stop worrying about object-level mismatch ?
The Dataguard replication works on binary level, so the object level sync
is guaranteed.
https://docs.oracle.com/en/solutions/reduce-database-migration-downtime/learn-migrating-oracle-data-guard1.html
thanks,
Albert
On Sun, Apr 14, 2024 at 5:28 AM Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
wrote:
Hello,
An exadata database server onpremise will be migrated to OCI As Is to the
same Oracle version (12.x).
I would like to know what else would have to be validated at OCI to ensure
that the migration was successful.
I thought I would check:
- dba_users
- dba_objects (and each object type separately)
- dba_tab_privs
- dba_sys_privs
- dba_roles
- dba_synonym
- dba_extents (in order to check the volumn)
- count the number of lines for each table, or to check at the dba_tables
numrows if the statistics are updated.
I guess that the number of lines migrated are enough to accept to
content of the table
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?
Regards
Eriovaldo