Oracle 12c - DG - ORA-16598: Oracle Data Guard broker detected a mismatch in configuration
Preliminary information:
AIX OS
Oracle 12.2 GI infrastructure
Oracle 12.1 Database as Primary with two instances as RAC
AIX OS
Oracle 12.1 Database as Physical Standby database with a single instance on Oracle Restart - ASM
This is what customer consider as an option for DR and I am not going to comment!
Error:
ORA-16598: Oracle Data Guard broker detected a mismatch in configuration
DGMGRL> VALIDATE DATABASE verbose "TESTDBS";
Database Role: Physical standby database
Primary Database: TESTDB
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Capacity Information:
Database Instances Threads
TESTDB 2 2
TESTDBS 1 2
Warning: the target standby has fewer instances than the
primary database, this may impact application performance
Temporary Tablespace File Information:
TESTDB TEMP Files: 4
TESTDBS TEMP Files: 1
Flashback Database Status:
TESTDB: On
TESTDBS: On
Data file Online Move in Progress:
TESTDB: No
TESTDBS: No
Standby Apply-Related Information:
Apply State: Running
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Delay: 0 minutes
Transport-Related Information:
Transport On: Yes
Gap Status: No Gap
Transport Lag: 0 seconds (computed 0 seconds ago)
Transport Status: Success
Log Files Cleared:
TESTDB Standby Redo Log Files: Cleared
TESTDBS Online Redo Log Files: Cleared
TESTDBS Standby Redo Log Files: Available
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDB) (TESTDBS)
0 190 0 Insufficient SRLs <---- this is the issue
Warning: standby redo logs not configured for thread 0 on TESTDBS
1 3 4 Sufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDBS) (TESTDB)
0 190 0 Insufficient SRLs <---- this is the issue
Warning: standby redo logs not configured for thread 0 on TESTDB
1 3 4 Sufficient SRLs
Current Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(TESTDB) (TESTDBS)
1 1024 MBytes 1024 MBytes
Future Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(TESTDBS) (TESTDB)
1 1024 MBytes 1024 MBytes
Apply-Related Property Settings:
Property TESTDB Value TESTDBS Value
DelayMins 0 0
ApplyParallel AUTO AUTO
Transport-Related Property Settings:
Property TESTDB Value TESTDBS Value
LogXptMode ASYNC ASYNC
RedoRoutes <empty> <empty>
Dependency <empty> <empty>
DelayMins 0 0
Binding optional optional
MaxFailure 0 0
MaxConnections 1 1
ReopenSecs 300 300
NetTimeout 30 30
RedoCompression DISABLE DISABLE
LogShipping ON ON
Automatic Diagnostic Repository Errors:
Error TESTDB TESTDBS
No logging operation NO NO
Control file corruptions NO NO
SRL Group Unavailable NO NO
System data file missing NO NO
System data file corrupted NO NO
System data file offline NO NO
User data file missing NO NO
User data file corrupted NO NO
User data file offline NO NO
Block Corruptions found NO NO
DGMGRL>
As you can see there are Thread 0 with Status Insufficient SRLs
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDB) (TESTDBS)
0 190 0 Insufficient SRLs
Warning: standby redo logs not configured for thread 0 on TESTDBS
1 3 4 Sufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDBS) (TESTDB)
0 190 0 Insufficient SRLs
Warning: standby redo logs not configured for thread 0 on TESTDB
1 3 4 Sufficient SRLs
There are not such things like Thread 0
SQL> select THREAD#,STATUS,ENABLED,CON_ID from gv$THREAD;
THREAD# STATUS ENABLED CON_ID
---------- ------ -------- ----------
1 OPEN PUBLIC 0
2 OPEN PUBLIC 0
1 OPEN PUBLIC 0
2 OPEN PUBLIC 0
I try to drop primary and standby redo logs groups but without success and finally, I find one Very useful Metalink note
Known issues when using "Validate database" DGMGRL command (Doc ID 2300040.1)
1. Bug 20582405 dgmgrl "validate database" shows warning "standby redo logs not configured for thread 0"
DGMGRL command "validate database" output may show "Warning: standby redo logs not configured for thread 0" in "Current Log File Groups Configuration" section.
DGMGRL> validate database verbose 'boston';
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(Chicago) (Boston)
0 2 0 Insufficient SRLs
Warning: standby redo logs not configured for thread 0 on Boston
1 2 3 Sufficient SRLs
Version confirmed as being affected: 12.1.0.2 (Server Patch Set)
The fix for 20582405 is first included in 12.2.0.1 (Base Release), but there are several one-off patches available for release 12.1.0.2
Reference :- Bug 20582405 - dgmgrl "validate database" shows warning "standby redo logs not configured for thread 0"
2. The issue is reported in Unpublished Bug 14674237 VALIDATE DATABASE from BROKER incorrectly reports on standby redo log files
3. Incorrect ADR Errors reported
4. Incorrect number of tempfiles reported
5. Warning reported for property RedoRoutes
Our bug is number one from the list as per the Metalink
Download Patch 20582405
Upload file on db Server
--- extract zip file
bash-3.2$ unzip p20582405_12102170418ProactiveBP_AIX64-5L.zip
Archive: p20582405_12102170418ProactiveBP_AIX64-5L.zip
creating: 20582405/
inflating: 20582405/README.txt
creating: 20582405/files/
creating: 20582405/files/lib/
creating: 20582405/files/lib/libserver12.a/
inflating: 20582405/files/lib/libserver12.a/rfrdb.o
creating: 20582405/etc/
creating: 20582405/etc/config/
inflating: 20582405/etc/config/actions.xml
inflating: 20582405/etc/config/inventory.xml
inflating: PatchSearch.xml
bash-3.2$ cd 20582405/
bash-3.2$
--- check for conflicts
bash-3.2$ /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/orainstall/20582405
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-20-47AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
bash-3.2$
We dont have conflicts which means that we can apply
- first we have to apply on Physical Standby Database
- Stop Database
bash-3.2$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 21 05:21:00 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shu immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
-- apply patch 20582405
bash-3.2$ /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-21-45AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 20582405
Do you want to proceed? [y|n]
y
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/12.1.0.2/home_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '20582405' to OH '/u01/app/oracle/product/12.1.0.2/home_1'
Patching component oracle.rdbms, 12.1.0.2.0...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ld: 0711-415 WARNING: Symbol ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol lnxadd is already exported.
ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
ld: 0711-415 WARNING: Symbol lnxmin is already exported.
ld: 0711-415 WARNING: Symbol lnxmul is already exported.
ld: 0711-415 WARNING: Symbol lnxnur is already exported.
ld: 0711-415 WARNING: Symbol lnxren is already exported.
ld: 0711-415 WARNING: Symbol lnxsca is already exported.
ld: 0711-415 WARNING: Symbol lnxshift is already exported.
ld: 0711-415 WARNING: Symbol lnxsni is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//liboraolap12.a[sxstime.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libgeneric12.a[sdbgrfu.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdopp.o], imported symbol ksptblblksizexp2_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdopp.o], imported symbol ksptblblksizemod_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdutl.o], imported symbol ksudbrmseccnt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdrcnc.o], imported symbol mdrcnccmt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 256000 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-786 WARNING: TLS overflow. TLS size: 232176 Maximum size: 65536
Extra instructions are being generated for some direct references
to TLS symbols.
Patch 20582405 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-21-45AM_1.log
OPatch completed with warnings.
bash-3.2$
-- the above warnings are expected on AIX system
-- check inventory
bash-3.2$ /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-22-49AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/lsinv/lsinventory2018-08-21_05-22-49AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: HOSTNAME
ARU platform id: 212
ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (5) :
Patch 20582405 : applied on Tue Aug 21 05:22:03 PET 2018 <<< --- this is out patch
Unique Patch ID: 21223264
Created on 25 Apr 2017, 07:28:59 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27502420 : applied on Wed Jun 27 07:43:58 PET 2018
Unique Patch ID: 22181504
Created on 11 May 2018, 07:02:47 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27314206 : applied on Wed Jun 27 07:42:18 PET 2018
Unique Patch ID: 22045742
Created on 6 Apr 2018, 08:12:15 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27475603 : applied on Wed Jun 27 06:23:29 PET 2018
Unique Patch ID: 22006612
Patch description: "Database PSU 12.1.0.2.180417, Oracle JavaVM Component (APR2018)"
Created on 6 Mar 2018, 15:42:54 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27338029 : applied on Wed Jun 27 06:11:14 PET 2018
Unique Patch ID: 22064709
Patch description: "Database Bundle Patch : 12.1.0.2.180417 (27338029)"
Created on 28 Mar 2018, 05:55:24 hrs PST8PDT
Sub-patch 26925263; "Database Bundle Patch : 12.1.0.2.180116 (26925263)"
Sub-patch 26717470; "Database Bundle Patch : 12.1.0.2.171017 (26717470)"
Sub-patch 26609798; "DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)"
Sub-patch 25869760; "DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)"
Sub-patch 25397136; "DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)"
Sub-patch 24732088; "DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)"
Sub-patch 24340679; "DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)"
Sub-patch 23144544; "DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)"
Sub-patch 22806133; "DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)"
Sub-patch 21949015; "DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)"
Sub-patch 21694919; "DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)"
Sub-patch 21125181; "DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)"
Sub-patch 20594149; "DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)"
Sub-patch 20075921; "DATABASE BUNDLE PATCH: 12.1.0.2.4 (20075921)"
Bugs fixed:
----- cut ---
OPatch succeeded.
bash-3.2$
-- startup database
bash-3.2$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 21 05:23:06 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.7180E+10 bytes
Fixed Size 3804952 bytes
Variable Size 8422162664 bytes
Database Buffers 8589934592 bytes
Redo Buffers 163966976 bytes
Database mounted.
SQL>
---- check DataGuard Configuration
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected as SYSDG.
DGMGRL> show configuration
Configuration - TESTDB_DG_CONFIG
Protection Mode: MaxPerformance
Members:
TESTDB - Primary database
TESTDBS - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 1534847029 seconds ago)
DGMGRL>
--- uhoooo we have success
--- let's validate the standby database
DGMGRL> VALIDATE DATABASE verbose "TESTDBS";
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDB) (TESTDBS)
0 190 0 Insufficient SRLs <---- this is because we have to apply on the primary database
Warning: standby redo logs not configured for thread 0 on TESTDBS
1 3 4 Sufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDBS) (TESTDB)
1 3 4 Sufficient SRLs <<<--- this is the correct status
2 3 4 Sufficient SRLs
DGMGRL>
--- Stop primary database - instance 2
--- Patch the second instance as the first one
bash-3.2$ srvctl stop instance -d TESTDB -i TESTDB2
--- check for conflicts
bash-3.2$ /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/orainstall/RDBMS/20582405
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory2
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-44-31AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
--- Apply patch on primary database instance 2
bash-3.2$ /u01/orainstall/RDBMS/20582405> /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory2
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-44-42AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 20582405
Do you want to proceed? [y|n]
y
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/12.1.0.2/home_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '20582405' to OH '/u01/app/oracle/product/12.1.0.2/home_1'
Patching component oracle.rdbms, 12.1.0.2.0...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ld: 0711-415 WARNING: Symbol ldxdts is already exported.
ld: 0711-415 WARNING: Symbol ldxsto is already exported.
ld: 0711-415 WARNING: Symbol lnxadd is already exported.
ld: 0711-415 WARNING: Symbol lnxcopy is already exported.
ld: 0711-415 WARNING: Symbol lnxmin is already exported.
ld: 0711-415 WARNING: Symbol lnxmul is already exported.
ld: 0711-415 WARNING: Symbol lnxnur is already exported.
ld: 0711-415 WARNING: Symbol lnxren is already exported.
ld: 0711-415 WARNING: Symbol lnxsca is already exported.
ld: 0711-415 WARNING: Symbol lnxshift is already exported.
ld: 0711-415 WARNING: Symbol lnxsni is already exported.
ld: 0711-415 WARNING: Symbol sldxgd is already exported.
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//liboraolap12.a[sxstime.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libgeneric12.a[sdbgrfu.o], imported symbol timezone
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdopp.o], imported symbol ksptblblksizexp2_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdopp.o], imported symbol ksptblblksizemod_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdutl.o], imported symbol ksudbrmseccnt_
Symbol was expected to be local. Extra instructions
are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u01/app/oracle/product/12.1.0.2/home_1/lib//libordsdo12.a[mdrcnc.o], imported symbol mdrcnccmt_
Symbol was expected to be local. Extra instructions are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 256008 Maximum size: 65536
Extra instructions are being generated for each reference to a TOC
symbol if the symbol is in the TOC overflow area.
ld: 0711-786 WARNING: TLS overflow. TLS size: 232176 Maximum size: 65536
Extra instructions are being generated for some direct references
to TLS symbols.
Patch 20582405 successfully applied.
OPatch Session completed with warnings.
Logfile location: /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-44-42AM_1.log
OPatch completed with warnings.
--- the above warnings are expected
--- check inventory
bash-3.2$ /u01/app/oracle/product/12.1.0.2/home_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.12
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/home_1
Central Inventory : /u01/app/oraInventory2
from : /u01/app/oracle/product/12.1.0.2/home_1/oraInst.loc
OPatch version : 12.2.0.1.12
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/opatch2018-08-21_05-45-29AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/home_1/cfgtoollogs/opatch/lsinv/lsinventory2018-08-21_05-45-29AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: HOSTNAME
ARU platform id: 212
ARU platform description:: IBM_AIX
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (5) :
Patch 20582405 : applied on Tue Aug 21 05:44:56 PET 2018
Unique Patch ID: 21223264
----- cut ---
Patch 27502420 : applied on Wed Jun 27 07:43:42 PET 2018
Unique Patch ID: 22181504
Created on 11 May 2018, 07:02:47 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27314206 : applied on Wed Jun 27 07:42:10 PET 2018
Unique Patch ID: 22045742
Created on 6 Apr 2018, 08:12:15 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27475603 : applied on Wed Jun 27 07:28:54 PET 2018
Unique Patch ID: 22006612
Patch description: "Database PSU 12.1.0.2.180417, Oracle JavaVM Component (APR2018)"
Created on 6 Mar 2018, 15:42:54 hrs PST8PDT
Bugs fixed:
----- cut ---
Patch 27338029 : applied on Wed Jun 27 07:25:28 PET 2018
Unique Patch ID: 22064709
Patch description: "Database Bundle Patch : 12.1.0.2.180417 (27338029)"
Created on 28 Mar 2018, 05:55:24 hrs PST8PDT
Sub-patch 26925263; "Database Bundle Patch : 12.1.0.2.180116 (26925263)"
Sub-patch 26717470; "Database Bundle Patch : 12.1.0.2.171017 (26717470)"
Sub-patch 26609798; "DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)"
Sub-patch 25869760; "DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)"
Sub-patch 25397136; "DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)"
Sub-patch 24732088; "DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)"
Sub-patch 24340679; "DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)"
Sub-patch 23144544; "DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)"
Sub-patch 22806133; "DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)"
Sub-patch 21949015; "DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)"
Sub-patch 21694919; "DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)"
Sub-patch 21125181; "DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)"
Sub-patch 20594149; "DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)"
Sub-patch 20075921; "DATABASE BUNDLE PATCH: 12.1.0.2.4 (20075921)"
Bugs fixed:
----- cut ---
OPatch succeeded.
bash-3.2$
-- start database instance 2
bash-3.2$ srvctl start instance -d TESTDB -i TESTDB2
--- check the status of instance 2
bash-3.2$ srvctl status database -d TESTDB
Instance TESTDB1 is running on node node1
Instance TESTDB2 is running on node node2
bash-3.2$
-- now have to patch instance 1
-- once you are ready with instance 1 we can check DG configuration
bash-3.2$ /u01/orainstall/20582405> srvctl status database -d TESTDB
Instance TESTDB1 is running on node node1
Instance TESTDB2 is running on node node2
--- check DG configuration
bash-3.2$ dgmgrl
DGMGRL for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected as SYSDG.
DGMGRL> VALIDATE DATABASE verbose "TESTDBS";
Database Role: Physical standby database
Primary Database: TESTDB
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Capacity Information:
Database Instances Threads
TESTDB 2 2
TESTDBS 1 2
Warning: the target standby has fewer instances than the
primary database, this may impact application performance
Temporary Tablespace File Information:
TESTDB TEMP Files: 2
TESTDBS TEMP Files: 1
Flashback Database Status:
TESTDB: On
TESTDBS: On
Data file Online Move in Progress:
TESTDB: No
TESTDBS: No
Standby Apply-Related Information:
Apply State: Running
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Delay: 0 minutes
Transport-Related Information:
Transport On: Yes
Gap Status: No Gap
Transport Lag: 0 seconds (computed 0 seconds ago)
Transport Status: Success
Log Files Cleared:
TESTDB Standby Redo Log Files: Cleared
TESTDBS Online Redo Log Files: Cleared
TESTDBS Standby Redo Log Files: Available
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDB) (TESTDBS)
1 3 4 Sufficient SRLs << --- this is correct
2 3 4 Sufficient SRLs << --- this is correct
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDBS) (TESTDB)
1 3 4 Sufficient SRLs << --- this is correct
2 3 4 Sufficient SRLs << --- this is correct
Current Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(TESTDB) (TESTDBS)
1 1024 MBytes 1024 MBytes
2 1024 MBytes 1024 MBytes
Future Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(TESTDBS) (TESTDB)
1 1024 MBytes 1024 MBytes
2 1024 MBytes 1024 MBytes
Apply-Related Property Settings:
Property TESTDB Value TESTDBS Value
DelayMins 0 0
ApplyParallel AUTO AUTO
Transport-Related Property Settings:
Property TESTDB Value TESTDBS Value
LogXptMode ASYNC ASYNC
RedoRoutes <empty> <empty>
Dependency <empty> <empty>
DelayMins 0 0
Binding optional optional
MaxFailure 0 0
MaxConnections 1 1
ReopenSecs 300 300
NetTimeout 30 30
RedoCompression DISABLE DISABLE
LogShipping ON ON
Automatic Diagnostic Repository Errors:
Error TESTDB TESTDBS
No logging operation NO NO
Control file corruptions NO NO
SRL Group Unavailable NO NO
System data file missing NO NO
System data file corrupted NO NO
System data file offline NO NO
User data file missing NO NO
User data file corrupted NO NO
User data file offline NO NO
Block Corruptions found NO NO
DGMGRL>
--- as you can see the issue has been fixed
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDB) (TESTDBS)
1 3 4 Sufficient SRLs << --- this is correct
2 3 4 Sufficient SRLs << --- this is correct
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(TESTDBS) (TESTDB)
1 3 4 Sufficient SRLs << --- this is correct
2 3 4 Sufficient SRLs << --- this is correct
have fun