Online DBA

<<Back to Oracle DataGuard Main Page When License Oracle Active Dataguard (ADG) feature You can use Oracle Data Guard as long as you are holding license for EE (DG license is included in Oracle Database Enterprise Edition). However Active Data Guard feature requires additional license on top. You need ADG license if you are using any or all of the features from the list below. Using BCT (Block Change Tracking) at standby Running redo apply services while an User PDB is open in read only Running Multi Instance redo apply -RAC Rolling Upgrade Using Active Data Guard Automatic Block Repair Global Data Services Real-Time Cascading (transferring the redo to the cascaded destination without waiting for the redo to be archived to a standby redo log file.) Active Data Guard Far Sync Starting from 18c (At least I test with 18c) you can have PDB$SEED and CDB$ROOT in read only without having ADG license.  Lets have a quick test: At Standby Database   set...

<<Back to DB Administration Main Page How to Patch oracle 18c/19c Non RAC (Single Instance) database NOTE: Starting from 18c Oracle calls Patch Set Update (PSU), as Release Update (RU). S tep1> Download the Patch Download the patch to be applied from oracle support Step2> Transfer the patch on the sever and unzip it using unzip utility Note: I am using OCT2019 PSU(RU) together with OJVM patch p30112122_180000_Linux-x86-64.zip  <= OCT DB PSU (DB RU) p30133603_180000_Linux-x86-64.zip  <= OCT JAVA Patch $unzip p30112122_180000_Linux-x86-64.zip -d /OCT_2019_PSU/ $unzip p30133603_180000_Linux-x86-64.zip -d /OCT_2019_PSU/ Step3> Verify Utility the Opatch version OPatch Utility: You must use the OPatch utility version as described in README file for the patch. Oracle recommends that you use the latest released OPatch version for 18c, which is available for download from My Oracle Support patch 6880880 by selecting the 18.0.0.0.0 release. $export P...