Query the cluster active patchlevel in the OCR backup
May 4, 2020 Leave a comment
To identify OCR backup where the cluster active patch level matches, you need to run the following:
Identify cluster active patch level:
[root@rac1 ~]# crsctl query crs activeversion -f Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [2701864972].
If backup is located on diskgroup:
[root@rac1 ~]# ocrdump -stdout -keyname SYSTEM.version.activeversion.patchlevel -backupfile +GRID:/marirac/OCRBACKUP/backup_20200425_171539.ocr.266.1038676539 04/26/2020 12:28:20 +GRID:/marirac/OCRBACKUP/backup_20200425_171539.ocr.266.1038676539 /u01/app/19.3.0/grid/bin/ocrdump.bin -stdout -keyname SYSTEM.version.activeversion.patchlevel -backupfile +GRID:/marirac/OCRBACKUP/backup_20200425_171539.ocr.266.1038676539 [SYSTEM.version.activeversion.patchlevel] UB4 (10) : 2701864972 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}
If backup is located on filesystem:
[root@rac1 ~]# ocrdump -stdout -keyname SYSTEM.version.activeversion.patchlevel -backupfile /tmp/backup_07_13_47_25 04/26/2020 12:26:57 /tmp/backup_07_13_47_25 /u01/app/19.3.0/grid/bin/ocrdump.bin -stdout -keyname SYSTEM.version.activeversion.patchlevel -backupfile /tmp/backup_07_13_47_25 [SYSTEM.version.activeversion.patchlevel] UB4 (10) : 2701864972 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root}