OraEasy

Introduction: We are going to configure a GoldenGate setup between Windows to Linux Oracle database environments. We will use Oracle GoldenGate 21c Microservice version. In this article, we will install the GoldenGate software and prepare the database for replication. Prerequisites: Below are the minimum requirements for GoldenGate setup. Databases should be installed & running in source & target. Connectivity between source & target servers. Free Disk space (approx. 15GB) for GoldenGate binary on both servers. Working TNS entry in tnsnames.ora file for database in both servers. Software Download: Oracle GoldenGate 21c on Linux/Windows. Environment: Server Source Target Hostname/IP LAPTOP-JO563L1O.oraeasy.com ogg21.oraeasy.com OS Windows 11 OEL 8.5 Database Version 19.28 19.28 Database Name ...

Introduction: A Refreshable Clone PDB is a special type of Pluggable Database introduced in Oracle Database 12.2 that allows you to periodically synchronize a cloned PDB with its source by applying redo data. In this article, we will configure the Refreshable Clone PDB. Refresh Mode : Automatic Refresh Mode : This refresh mode is a configuration of a refreshable clone PDB in Oracle Database where the clone is automatically synchronized with its source PDB at fixed, predefined time intervals. The refresh occurs based on the interval specified in the REFRESH MODE EVERY n MINUTES clause during creation or modification of the clone. Manual Refresh Mode : This refresh mode is a configuration of a refreshable clone PDB in Oracle Database where synchronization with the source PDB occurs only when explicitly initiated by the DBA. The clone is created using the REFRESH MODE MANUAL clause and refreshed on demand using the ALTER PLUGGABLE DATABASE pdb_name REFRESH co...

Introduction: Oracle Logical Standby Database can be used for write opeartion if required to do reports and test any statement. Although if the same transaction got executed on Primary then it will create conflict and SQL apply got abrupt on Standby, hence it will result in out of sync between Primary & Standby. In this article, we will see how to resolve such issue by skipping the transaction. Prerequisites: Logical standby should be configured and in sync. Environment: Server Primary Standby Hostname drdb.oraeasy.com dcdb.oraeasy.com OS OEL 9 OEL 9 SID ORADBDR ORADBDC Service Name ORADBDR ORADBDC Now proceed to create the issue scenario and its resolution step by step: 1. Check the sync between Primary and Standby. ==> Primary: SQL> select name,db_unique_name,databas...

Introduction: AWR (Automatic Workload Repository) is an Oracle performance monitoring feature that collects, processes, and stores database performance statistics. These statistics are used for problem diagnosis and self-tuning of the database. The collected data can be viewed through database views or generated as HTML or text reports, helping DBAs analyze the current performance state of the database in detail. Background Processes for AWR: MMON : Collects AWR statistics. MMNL : Writes ASH and AWR data to disk. Data Collected by AWR: AWR captures a wide range of performance related metrics, including: Object Statistics: Access and usage statistics of database segments. Time Model Statistics: Data from V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views. System and Session Statistics: Selected statistics from V$SYSSTAT and V$SESSTAT views. Active Session History (ASH) statistics. High-load SQL statements contributing significantly to database w...