Migration validation to OCI

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 14 Apr 2024 09:27:43 -0300
Message-ID: <CAJdDhaMi_M6+MkR=_8bq39ureH6O16cEbgx-L2y_VmNNVvioUw_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Apr 14 2024 - 14:27:43 CEST