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

Oracle Database 19c Installation On Oracle Linux 7

Oracle Database 19c Installation On Oracle Linux 7 

• Download Software

Oracle Database 19c (19.3) Software (64-bit)

 Add hosts entry in hosts file

[root@oel7 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.118.128 oel7.soumya.com oel7

 

 

Install the "oracle-database-preinstall-19c" package to perform all the prerequisite setup

# yum install -y oracle-database-preinstall-19c