In order to handle database server migration for existing resources. We need to make sure the below back-ups are taken before changing the database server.
- MRS backup.
- Catalog Service backup.
In MRS Database only the Catalog Service Metadata is stored for the resources. Once the backup is migrated, then we can change the connection string and database schema details for MRS in Admin Console and restore the MRS contents from the backup which we have taken.
Once the MRS restore is done, eventually we can restore the LDM contents from the backup contents.
In this way, we can handle database server migration.
Note: Starting from EDC 10.4, we do support Oracle 19c for MRS database and Domain Database.
Go through the Upgrade Planner for EDC 10.4.1