In this activity we are going to assume we have GoldenGate software already installed, if not, you can follow these steps here: Oracle GoldenGate 19c: How to install We are are going to replicate schema HR from/to these server: SOURCE (PDB): TARGET (NON CDB): hostname: racnode1 hostname: standbyracnode IP: 192.168.24.1 IP: 192.168.24.3 RDBMS: 19c RDBMS:... » read more
This is going to be a guide for how to install GoldenGate on your source/target servers, just the installation of the software. For the configuration and setting up and running, please check this: Oracle GoldenGate 19c: How to configure Integrated EXTRACT/REPLICAT First of all make sure you have the GoldenGate version that matches your DB.... » read more
While trying to reinstall Oracle Grid Infrastructure 19c on my lab, I was facing this error: The hint here is the CRS-1705: Found 0 configured voting files In this environment I was replacing OCR dg for RECO dg so lets check what each node see: Somehow I did miss to do a scan on node... » read more
Cloud tools are not known to provide huge amount of details when you have an error.In this case we were running patching prechecks which were failing with: Checking log, se can see error was given while trying to execute “select status from pdb_plug_in_violations where type = ‘ERROR’ and status = ‘PENDING’ order by name, time;”... » read more
Starting from 12c, RMAN allows to perform a Table Point In Time Recovery (PITR).On earlier releases, this was only possible by manually creating a point in time clone of the database and extracting the data via datapump.With this “new” feature, life gets easier. SETUP:For this task we are assuming you have your DB/ARCHIVE log backups... » read more
This is a weird case we had for a Customer where DB/PDB’s were running fine and after a restart, one of the PDB’s went to restricted YES.We don’t know why it went to restricted mode because there hasn’t been a patching activity for a while and DB had few restarts in the past with no... » read more
This wait can have an impact to production and deteriorate performance on a DB, so lets investigate… Lets see the output from a AWR report where this event is 23% of the total wait time: As per “Analyzing ‘enq: HW – contention’ Wait Event (Doc ID 740075.1)”, this can be generated by multiple sessions fighting... » read more
This is an easy one that will save you going through alert logs.
Sometimes you might get an incident for high usage on a filesystem. You check and yes, filesystem usage is high, but ‘du’ (disk usage) if different. why? Some explanations might say: they don’t use the same methods or metrics to calculate what they are reporting.Yes, that’s true, but pretty much outputs should be the same.If... » read more
This error usually is because of password file mismatch: someone updated in primary and forgot to pass across to standby nodes, missed a node… but what if password file in primary and standby is the same? In this case, password files are correct so PRIMARY should not have issues sending logs,right? But no, instead it... » read more