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

 

How to change DNS records in Exadata cell nodes

Login to 1st exadata cell  node:-

[root@itscceladm01 ~]# cellcli
CellCLI: Release 18.1.9.0.0 - Production on Fri Jan 31 17:17:50 IST 2020

Copyright (c) 2007, 2016, Oracle and/or its affiliates. All rights reserved.

CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

Steps to change sysman password in Oracle Enterprise Manager 12c

Stop oms . Do not include '-all' as the Admin Server needs to be up during this operation. cd /u01/app/oracle/product/MiddlewareR5/oms/bin/ [oracle@em bin]$ ./emctl stop oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Stopping WebTier... WebTier Successfully Stopped Stopping Oracle Management Server... Oracle Management Server Successfully Stopped Oracle Management Server is Down

Modify the SYSMAN password:- emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <repository sys user password> -new_pwd <new sysman repository password> Example:- [oracle@em bin]$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd welcome1  -new_pwd welcome2# Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Changing passwords in backend ... Passwords changed in backend successfully. Updating repository password in Credential Store... Successfully updated Repository password in Credential Store. Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'. Successfully changed repository password. [oracle@em bin]$

Stop the admin server on OMS machine [oracle@em bin]$ ./emctl stop oms -all Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Stopping WebTier... WebTier Successfully Stopped Stopping Oracle Management Server... Oracle Management Server Already Stopped AdminServer Successfully Stopped Oracle Management Server is Down

Start the OMS [oracle@em bin]$ ./emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Starting Oracle Management Server... Starting WebTier... WebTier Successfully Started Oracle Management Server Successfully Started Oracle Management Server is Up Check OMS status [oracle@em bin]$ ./emctl status oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. WebTier is Up Oracle Management Server is Up