Oracle Database Upgrade from 12c to 19c using DBUA

Oracle database can be upgraded directly to the new release from the following releases:

• 11.2.0.4
• 12.1.0.2
• 12.2.0.1
• 18

If your current Oracle Database is a release earlier than 11.2.0.4, then you cannot directly upgrade your Oracle Database

to the latest release. In this case, you are required to upgrade to an intermediate release before upgrading to 

Oracle Database 19c.

How to install Oracle 19.1.0.0.4 GoldenGate on Linux 7

Installing Oracle 19.1.0.0.4 GoldenGate on Linux 7

Step 1:- unzip the software

[oracle@oel7 u01]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip

[oracle@oel7 u01]$ ls -ltr

total 543540

-rw-r--r-- 1 oracle oinstall      1413 May 29  2019 OGG-19.1.0.0-README.txt

drwxr-xr-x 3 oracle oinstall        19 Oct 18  2019 fbo_ggs_Linux_x64_shiphome

-rw-r--r-- 1 oracle oinstall    332523 Oct 21  2019 OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf

-rw-r--r-- 1 oracle oinstall 556240981 May 11 18:58 191004_fbo_ggs_Linux_x64_shiphome.zip

Step:2 Create the  directory where goldengate would be installed

How to apply RUR Patch in Dataguard Environment in 19c

Applying RUR(Release Update Revision) Patch in a dataguard (Physical Standby) environment.

Here is a brief explanation on how to apply RUR (Release Update Revision) in a dataguard environment

Here I will be  applying RUR 19.5.1.0 on the Primary and standby databases.

Primary database Server : primary

Standby database Server : standby

Primary db_unique_name : orclcdb

Standby db_unique_name : orclstd

How To Clone A Pluggable Database from a Existing PDB in 19C

How To Clone A Pluggable Database from a Existing PDB

Step 1. 

Put PDB in read only mode , which would be cloned.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORCLPDB1                       READ WRITE NO

Rolling Forward Standby Database When Archive log is missing in Primary DB

Problem statement :- standby database goes out of sync as the archive logs are missing from primary site.

Environment:

Primary:

Primary database node     : primary.soumya.com

Database name              : orclcdb

Primary DB UNIQUE NAME     : orclcdb

Primary database instances : orclcdb

DB Version: 19.0.0 

Standby:

Standby database node     : standby.soumya.com

Database name              : orclcdb

Standby DB UNIQUE NAME     : orclstd

Standby database instances : orclcdb

DB Version: 19.0.0 

ORA-16698 member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set

In primary DATABASE:-

Primary DB:- orclcdb

Standby DB:- orclstd

oracle@primary flashback]$ dgmgrl sys/admin123#@orclcdb

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Mon Apr 13 19:05:31 2020

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected to "orclcdb"

Connected as SYSDBA.

DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS orclcdb CONNECT IDENTIFIER IS orclcdb;

How to create physical standby database on Oracle 19c

OS Version:-Oracle Linux 7

Oracle version:- Oracle Database 19c Enterprise Edition Release 19.3.0 64bit

System Configuration

primary server:-

edit the following files

cat /etc/hosts

[oracle@primary ~]$ cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.110   primary.soumya.com      primary

192.168.0.120   standby.soumya.com      standby