Oracle Enterprise Database12.2 to 19c
My database is primarily an application data repository that receives ODBC connections from a few different applications on our network. I want to establish a 19c database on upgraded hardware, and then have the 19c and 12.2 databases mirror each other, migrating an application, testing it, and moving the next, until everything is running on 19c and we can shut 12.2 down. What are my options for accomplishing this?
- Changes on either database will have to be reflected to it's partner fairly quickly. Seconds or minutes at most for replication. Real-time is not necessary but would be ideal.
- One user will be testing their application against the upgraded database while others use the old version. Changes on either database should be visible to everyone, so changes should be a two-way street.