What Does ADD SCHEMATRANDATA Actually Do?
A deep dive into what Oracle GoldenGate executes under the hood when you run ADD SCHEMATRANDATA - tracing session activity to uncover the package chain and where the metadata actually lives.
Deploy. Learn. Repeat.
Exploring Oracle database technologies, GoldenGate implementations, and practical solutions to real-world deployment challenges. Learn from hands-on experience with Oracle products in production environments. And other things I have learned in life so far.
A deep dive into what Oracle GoldenGate executes under the hood when you run ADD SCHEMATRANDATA - tracing session activity to uncover the package chain and where the metadata actually lives.
Oracle GoldenGate has released an Ansible collection to automate GoldenGate Hub Platinum MAA deployment, covering 80% of the manual steps. Learn how to adapt the playbook for active-active setups without ACFS replication.
Configure RMAN deletion policies to ensure archived logs are properly deleted without being blocked by GoldenGate downstream Extract processes.
SQL statements for OEM metric extensions to monitor log shipping between Oracle Active Data Guard standby and mining databases, with testing procedures.
Steps to verify and ensure that a GoldenGate Downstream Extract is running properly