I have an 11.2.0.4 database. I want to create a 19c database, initially as a duplicate of the 11g and then keep the 19c database in synch with the 11g for a period of a few months. The existing applications will continue to use the 11g database during this period, carrying out transactions which I want to be synched to the 19c database. Other applications need to be able to connect to the 19c database for read-only access.
Is this possible with Data Guard or does it require further tools such as Golden Gate?
Thanks in advance,
John