In one scenario, the database needs to be migrated from Solaris SPARC to Linux x86-64, while the database version is upgraded from the original Oracle 9i (9.2.0.5) to 11g (11.2.0.4)
With Ogg's data synchronization feature, the amount of downtime is largely dependent on the switching time between the old application disconnects and the new application providing access to the outside.
The upgrade steps are as follows:
1. Install the Oracle 11.2.0.4 software on the target machine and configure the corresponding tablespace and database parameters according to the DB settings on the source side, note that some parameters in 9i have been discarded or changed in 11g; deploy to a new platform
2. Install Ogg software on the source and target server, using the Ogg 11.1.1.1.4 for Oracle 9i and the target end using Ogg 11.2.1.0.3 for 11g;
3. Open the additional log switch on the source-side database; Use the OGG command: Add Trandata and add schematrandata to open the additional log at the table level;
4. Enable DDL synchronization on the source side;
5. Configure the Ogg manager process on the source and target side;
6. The source side creates the extraction and transfer process; the target side creates the delivery process;
7. Start the Ogg extraction and transfer process at the source end;
8. Based on the SCN number, export the source data to the target database, verify that all errors are resolved, and complete the initialization of the target data;
9. Start the REPLICAT process on the target side based on the SCN number;
10. Confirm that the data in the REPLICAT process has been flat, stop the source application and point the portal of the business user to the application platform of 11g;
11. Stop the Ogg process on the source side and target side, and the migration is complete.
Description of the Platform migration and Database Upgrade (9i->11g) steps using Goldengate