Oracle GoldenGate can be a good addition to a lot of upgrade and migration projects to decrease the downtime to a bare minimum, or even zero in some cases.
But before you consider Oracle GoldenGate as THE solution to decrease your downtime you may evaluate if your database is ready for OGG. For this purpose you can download scripts from MyOracle Support (MOS) to check exactly this.
Complete Database Profile OGG readiness check for Classic Extract
MOS Note:1298562.1:
Oracle GoldenGate database Complete Database Profile check script for Oracle DB (All Schemas) Classic Extract
This script is intended to query all of the non default database users to identify current configuration and identify any unsupported data types or types that may need special considerations for Oracle GoldenGate in an Oracle environment.
Check OGG readiness for Schema Only
MOS Note: 1296168.1
Oracle GoldenGate database Schema Profile check script for Oracle DB
This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for Oracle GoldenGate in an Oracle environment.
Difference and Execution
The main difference between the two scripts is the amount of data being processed. The Schema Script is more targeted and therefore should return fewer items that need additional checking.
Log into sqlplus as sysdba and run the script:
SQL> @full-DB_CheckOracle_15092015.sql
SQL> @full-schemaCheckOracle_15092015.sql
Review the output.
–Mike
Link to the White Paper is 404.
Thanks – had a %.. character at the end 🙂
It’s corrected now 🙂
Cheers!!!
Mike
Hi Mike,
Looks like note 1296168.1 is not available anymore. I added it to my favorites but that also does not work. Can you check that ?
Regards,
Ron.
Hi Ron,
it is under review – the folks have done an update to it. Once the review has been completed, it will be public again.
MOS unfortunately no mechanism to tell you what’s going on 🙁
Instead you don’t see the note anymore 🙁
Sorry, Mike