Soumya's Database Blog : 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

patch-Database Release Update Revision 19.5.1.0.200114

High Level steps for applying the Patch

Disable REDO transport on Primary.
Shutdown Standby Database and Listener
Apply PSU patch on Standby database
Shutdown Primary Database and Listener
Apply PSU patch on primary database
Start the primary site, re-enable log shipping on primary.
Execute Post installation Scripts (datapatch)
Monitor the redo apply from Primary to Standby

Primary Server:

[oracle@primary ~]$ sqlplus sys/admin123#@orclcdb as sysdba

SQL> select status,instance_name,database_role from v$database,v$instance;

STATUS INSTANCE_NAME DATABASE_ROLE

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

OPEN orclcdb PRIMARY

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 ORCLPDB1 READ WRITE NO

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)

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

Standby server:-

SQL> select status,instance_name,database_role from v$database,v$instance;

STATUS INSTANCE_NAME DATABASE_ROLE

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

MOUNTED orclcdb PHYSICAL STANDBY

SQL> select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)

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

Step 1:

Disable REDO transport from primary to standby

[oracle@primary dbs]$ dgmgrl sys/admin123#@orclcdb

DGMGRL> show database verbose orclcdb

Database - orclcdb

Role: PRIMARY

Intended State: TRANSPORT-ON

Instance(s):

orclcdb

Properties:

DGConnectIdentifier = 'orclcdb'

ObserverConnectIdentifier = ''

FastStartFailoverTarget = ''

PreferredObserverHosts = ''

LogShipping = 'ON'

RedoRoutes = ''

LogXptMode = 'ASYNC'

DelayMins = '0'

Binding = 'optional'

MaxFailure = '0'

ReopenSecs = '300'

NetTimeout = '30'

RedoCompression = 'DISABLE'

PreferredApplyInstance = ''

ApplyInstanceTimeout = '0'

ApplyLagThreshold = '30'

TransportLagThreshold = '30'

TransportDisconnectedThreshold = '30'

ApplyParallel = 'AUTO'

ApplyInstances = '0'

StandbyFileManagement = ''

ArchiveLagTarget = '0'

LogArchiveMaxProcesses = '0'

LogArchiveMinSucceedDest = '0'

DataGuardSyncLatency = '0'

LogArchiveTrace = '0'

LogArchiveFormat = ''

DbFileNameConvert = ''

LogFileNameConvert = ''

ArchiveLocation = ''

AlternateLocation = ''

StandbyArchiveLocation = ''

StandbyAlternateLocation = ''

InconsistentProperties = '(monitor)'

InconsistentLogXptProps = '(monitor)'

LogXptStatus = '(monitor)'

SendQEntries = '(monitor)'

RecvQEntries = '(monitor)'

HostName = 'primary.soumya.com'

StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary.soumya.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclcdb_DGMGRL)(INSTANCE_NAME=orclcdb)(SERVER=DEDICATED)))'

TopWaitEvents = '(monitor)'

SidName = '(monitor)'

Log file locations:

Alert log : /u01/app/oracle/diag/rdbms/orclcdb/orclcdb/trace/alert_orclcdb.log

Data Guard Broker log : /u01/app/oracle/diag/rdbms/orclcdb/orclcdb/trace/drcorclcdb.log

Database Status:

SUCCESS

DGMGRL> edit database orclcdb set state='LOG-TRANSPORT-OFF';

Succeeded.

Step 2.

Shutdown Standby Database and Listener

[oracle@standby dbs]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-MAY-2020 22:06:24

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=standby.soumya.com)(PORT=1521)))

The command completed successfully

[oracle@standby dbs]$

$ sqlplus / as sysdba

SQL> shut immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> exit

Step 3.

Apply PSU patch on Standby database

Before applying the patch , we would check the opatch version

add OPatch in PATH .bash_profile

export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@primary OPatch]$ opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

Its recommended to have latest opatch version installed. We already have a latest version installed, so we will skip the

opatch installation part.

Now transfer the PSU into the standby server where it would be applied first.

As a good practice, take Backup of ORACLE_HOME (both primary & Standby side) before applying the patch.

Now once backup is done, start the patch apply.

On Standby :-

Determine whether any currently installed interim patches conflict with the patch being installed, 30446054

[oracle@standby ~]$ cd /u01/patch/30446054/

[oracle@primary 30446054]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17

PREREQ session

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.17

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-08_22-56-07PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@standby 30446054]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.17

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-08_22-30-44PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 30446054

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Applying interim patch '30446054' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...

Patch 30446054 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30446054].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-08_22-30-44PM_1.log

OPatch succeeded.

Now start listener and standby database

[oracle@standby 30446054]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 8 22:47:06 2020

Version 19.5.1.0.0

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1644164416 bytes

Fixed Size 9135424 bytes

Variable Size 1392508928 bytes

Database Buffers 234881024 bytes

Redo Buffers 7639040 bytes

Database mounted.

[oracle@standby 30446054]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-MAY-2020 22:59:10

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/standby/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby.soumya.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=standby.soumya.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 08-MAY-2020 22:59:11

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/standby/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby.soumya.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "orclstd_DGMGRL" has 1 instance(s).

Instance "orclcdb", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

Step 4.

Shutdown Primary Database and Listener

On primary:-

[oracle@primary ~]$ lsnrctl stop

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-MAY-2020 22:53:58

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=primary.soumya.com)(PORT=1521)))

The command completed successfully

[oracle@primary ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 8 22:54:02 2020

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Step 5.

Apply PSU patch on primary database

[oracle@primary ~]$ cd /u01/patch/30446054/

[oracle@primary 30446054]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

Oracle Home : /u01/app/oracle/product/19.0.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from : /u01/app/oracle/product/19.0.0/dbhome_1/oraInst.loc

OPatch version : 12.2.0.1.17

OUI version : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-08_22-57-33PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 30446054

Do you want to proceed? [y|n]

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.0.0/dbhome_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

Applying interim patch '30446054' to OH '/u01/app/oracle/product/19.0.0/dbhome_1'

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.util, 19.0.0.0.0...

Patching component oracle.assistants.acf, 19.0.0.0.0...

Patching component oracle.assistants.deconfig, 19.0.0.0.0...

Patching component oracle.assistants.server, 19.0.0.0.0...

Patching component oracle.buildtools.rsf, 19.0.0.0.0...

Patching component oracle.ctx, 19.0.0.0.0...

Patching component oracle.ldap.rsf, 19.0.0.0.0...

Patching component oracle.network.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.sdo, 19.0.0.0.0...

Patching component oracle.sqlplus, 19.0.0.0.0...

Patching component oracle.network.client, 19.0.0.0.0...

Patching component oracle.sdo.locator, 19.0.0.0.0...

Patching component oracle.duma, 19.0.0.0.0...

Patching component oracle.rdbms.crs, 19.0.0.0.0...

Patching component oracle.rdbms.drdaas, 19.0.0.0.0...

Patching component oracle.rdbms.rman, 19.0.0.0.0...

Patching component oracle.ctx.atg, 19.0.0.0.0...

Patching component oracle.install.deinstalltool, 19.0.0.0.0...

Patching component oracle.rdbms.scheduler, 19.0.0.0.0...

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...

Patching component oracle.dbjava.ucp, 19.0.0.0.0...

Patching component oracle.ctx.rsf, 19.0.0.0.0...

Patching component oracle.dbdev, 19.0.0.0.0...

Patching component oracle.xdk.parser.java, 19.0.0.0.0...

Patching component oracle.xdk, 19.0.0.0.0...

Patching component oracle.ons, 19.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...

Patching component oracle.dbjava.ic, 19.0.0.0.0...

Patching component oracle.dbjava.jdbc, 19.0.0.0.0...

Patching component oracle.ovm, 19.0.0.0.0...

Patching component oracle.rdbms.deconfig, 19.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...

Patching component oracle.xdk.rsf, 19.0.0.0.0...

Patching component oracle.odbc, 19.0.0.0.0...

Patching component oracle.network.listener, 19.0.0.0.0...

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...

Patching component oracle.oracore.rsf, 19.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...

Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0...

Patching component oracle.ldap.owm, 19.0.0.0.0...

Patching component oracle.rdbms.dv, 19.0.0.0.0...

Patching component oracle.rdbms.oci, 19.0.0.0.0...

Patching component oracle.sqlplus.ic, 19.0.0.0.0...

Patching component oracle.ldap.security.osdt, 19.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...

Patching component oracle.precomp.lang, 19.0.0.0.0...

Patching component oracle.precomp.common, 19.0.0.0.0...

Patching component oracle.jdk, 1.8.0.201.0...

Patch 30446054 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30446054].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-08_22-57-33PM_1.log

OPatch succeeded.

Step 6.

Start the primary site, re-enable log shipping on primary.

On primary:-

[oracle@primary 30446054]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-MAY-2020 23:09:13

Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/primary/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary.soumya.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=primary.soumya.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 08-MAY-2020 23:09:13

Uptime 0 days 0 hr. 0 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/primary/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary.soumya.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "orclcdb_DGMGRL" has 1 instance(s).

Instance "orclcdb", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@primary 30446054]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 8 23:09:18 2020

Version 19.5.1.0.0

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1644164416 bytes

Fixed Size 9135424 bytes

Variable Size 1409286144 bytes

Database Buffers 218103808 bytes

Redo Buffers 7639040 bytes

Database mounted.

Database opened.

Enable log shipping:-

[oracle@primary 30446054]$ dgmgrl sys/admin123#@orclcdb

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri May 8 23:12:42 2020

Version 19.5.1.0.0

Welcome to DGMGRL, type "help" for information.

Connected to "orclcdb"

Connected as SYSDBA.

DGMGRL> edit database orclcdb set state='ONLINE';

Step 7.

Execute Post installation Scripts (datapatch). Make sure all the pdbs are in open state before starting this phase.

On Primary:-

[oracle@primary 30446054]$ datapatch -verbose

SQL Patching tool version 19.5.1.0.0 Production on Fri May 8 23:19:02 2020

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_19741_2020_05_08_23_19_02/sqlpatch_invocation.log

Connecting to database...OK

Gathering database info...done

Note: Datapatch will only apply or rollback SQL fixes for PDBs

that are in an open state, no patches will be applied to closed PDBs.

Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

(Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of interim SQL patches:

No interim patches found

Current state of release update SQL patches:

Binary registry:

19.5.1.0.0 Release_Update_Revision 191213225930: Installed

PDB CDB$ROOT:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-APR-20 09.47.26.750371 AM

PDB ORCLPDB1:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-APR-20 09.56.54.827686 AM

PDB PDB$SEED:

Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 03-APR-20 09.56.54.827686 AM

Adding patches to installation queue and performing prereq checks...done

Installation queue:

For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB1

No interim patches need to be rolled back

Patch 30446054 (Database Release Update Revision : 19.5.1.0.200114 (30446054)):

Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.5.1.0.0 Release_Update_Revision 191213225930

No interim patches need to be applied

Installing patches...

Patch installation complete. Total patches installed: 3

Validating logfiles...done

Patch 30446054 apply (pdb CDB$ROOT): SUCCESS

......

Step 8.

Monitor the redo apply from Primary to Standby

On Standby:-

SQL> select process,status,sequence# from v$managed_standby;

PROCESS STATUS SEQUENCE#

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

ARCH CLOSING 73

DGRD ALLOCATED 0

ARCH CLOSING 74

ARCH CONNECTED 0

ARCH CLOSING 75

ARCH CONNECTED 0

ARCH CLOSING 76

ARCH CONNECTED 0

ARCH CLOSING 77

PROCESS STATUS SEQUENCE#

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

ARCH CONNECTED 0

ARCH CLOSING 78

ARCH CONNECTED 0

ARCH CLOSING 79

ARCH CONNECTED 0

ARCH CLOSING 80

ARCH CONNECTED 0

ARCH CLOSING 81

ARCH CONNECTED 0

PROCESS STATUS SEQUENCE#

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

ARCH CONNECTED 0

MRP0 APPLYING_LOG 82

PROCESS STATUS SEQUENCE#

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

RFS IDLE 0

RFS IDLE 82

RFS IDLE 0

37 rows selected.

On primary:-

SQL> select PATCH_ID,ACTION_TIME,STATUS,DESCRIPTION from registry$sqlpatch;

PATCH_ID ACTION_TIME STATUS DESCRIPTION

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

29517242 03-APR-20 09.47.26.750371 AM SUCCESS Database Release Update : 19.3.0.0.190416 (29517242)

30446054 08-MAY-20 11.48.04.477197 PM SUCCESS Database Release Update Revision : 19.5.1.0.200114 (30446054)

[oracle@primary 30446054]$ opatch lsinventory|grep 30446054

Patch 30446054 : applied on Fri May 08 23:01:13 IST 2020

Patch description: "Database Release Update Revision : 19.5.1.0.200114 (30446054)"

Run utlrp.sql to validate the invalid objects if found after execution of datapatch.

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> @utlrp.sql

This concludes the patching activity in Dataguard Environment in 19c.

Soumya's Database Blog

How to apply RUR Patch in Dataguard Environment in 19c

No comments:

Post a Comment