Author

Oracle GoldenGate 19c: How to install

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

dbaascli patch db prereq failing with: [FATAL] [DBAAS-31009]

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

How To Recover Tables to a Specified Point in Time

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

How To fix: PDB in restricted

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

How To Analyze wait: ‘enq: HW – contention’

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

df vs. du: why so much difference?

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

ORA-16191: Primary log shipping client not logged on standby

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

RMAN: HOW TO REFRESH a DB from backup

Lets suppose you have been requested to refresh a TEST/DEV Database and you don’t have access to the source DB, just access to the backups someone created. In this case, this is a Windows environment and we are going to assume the following information: DB and Archive log backups located under: “D:\RMAN\Backup\”Control file backup to... » read more