Clone Oracle Grid Infrastructure Home Using Golden Images oracledna RAC March 1, 2026 Instead of doing fresh installation of Grid Infrastructure Home with respective patches, we can clone the existing GI home using Golden Image method. By using this Golden Image, we can install GI home in another server with already applied patches. 1. Create directory at OS level to store the Golden Images. [grid@racnode1 ~]$ mkdir -p /u01/app/grid/GoldImage 2. Create the Golden Image of 19c GI home, from GI home execute the below command. [grid@racnode1 ~]$ cd /u01/app/19.0.0/grid [grid@racnode1 grid]$ ./gridSetup.sh -createGoldImage -destinationLocation /u01/app/grid/GoldImage -silentLaunching Oracle Grid Infrastructure Setup Wizard… Successfully Setup Software.Gold Image location: /u01/app/grid/GoldImage/grid_home_2026-03-01_02-01-26PM.zip 3. Verify whether the golden Image created or not. [grid@racnode1 ~]$ cd /u01/app/grid/GoldImage [grid@racnode1 GoldImage]$ ls -lrttotal 2802444-rw-r–r– 1 grid oinstall 2869701449 Mar 1 14:05 grid_home_2026-03-01_02-01-26PM.zi Disclaimer: Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment. Popular Posts Clone Oracle Grid Infrastructure Home Using Golden Images Enabling Flash Recovery Area In Oracle RAC 19c Database Restore OCR from backup in Oracle RAC 19c Downgrade Oracle Database from 19c to 11g by using dbdowngrade (Non CDB) Upgrade Oracle Database from 11g to 19c by DBUA (Non CDB) Categories ASM (2) DataGuard (2) News (1) Oracle Standalone Database (8) Patching (1) RAC (3)
Enabling Flash Recovery Area In Oracle RAC 19c Database
Enabling Flash Recovery Area In Oracle RAC 19c Database oracledna RAC February 14, 2026 This post is to demonstrate enabling Flash Recovery Area In Oracle RAC 19c Database. 1. Before enabling the fast recovery area, check the status of FRA. SQL> show parameter db_recovery; NAME TYPE VALUE———————————— ———– ——————————db_recovery_file_dest stringdb_recovery_file_dest_size big integer 0 2. Enable the FRA. SQL> alter system set db_recovery_file_dest_size=20G scope=both sid=’*’;System altered. SQL> alter system set DB_RECOVERY_FILE_DEST=’+DATA’ scope=both sid=’*’;System altered. 3. Verify the FRA status from all RAC nodes. SQL> show parameter db_recovery; NAME TYPE VALUE———————————— ———– ——————————db_recovery_file_dest string +DATAdb_recovery_file_dest_size big integer 20G 4. Check the FRA utilization and occupant details. set linesize 300col NAME for a20select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) “Allocated Space(GB)”, round(SPACE_USED/1024/1024/1024,2) “Used Space(GB)”,round(SPACE_RECLAIMABLE/1024/1024/1024,2) “SPACE_RECLAIMABLE (GB)” ,(select round(ESTIMATED_FLASHBACK_SIZE/1024/1024/1024,2) from V$FLASHBACK_DATABASE_LOG) “Estimated Space (GB)”from V$RECOVERY_FILE_DEST; NAME Allocated Space(GB) Used Space(GB) SPACE_RECLAIMABLE (GB) Estimated Space (GB)——————– ——————- ————– ———————- ——————–+DATA 20 .81 0 — SQL> select * from v$flash_recovery_area_usage; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID———————– —————— ————————- ————— ——–CONTROL FILE .09 0 1 0REDO LOG 3.93 0 4 0ARCHIVED LOG 0 0 0 0BACKUP PIECE 0 0 0 0IMAGE COPY 0 0 0 0FLASHBACK LOG 0 0 0 0FOREIGN ARCHIVED LOG 0 0 0 0AUXILIARY DATAFILE COPY 0 0 0 0 8 rows selected. Disclaimer: Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment. Popular Posts Enabling Flash Recovery Area In Oracle RAC 19c Database Restore OCR from backup in Oracle RAC 19c Downgrade Oracle Database from 19c to 11g by using dbdowngrade (Non CDB) Upgrade Oracle Database from 11g to 19c by DBUA (Non CDB) Downgrade Oracle Database from 19c (19.3) to 11g (11.2.0.4) manually Categories ASM (2) DataGuard (2) News (1) Oracle Standalone Database (8) Patching (1) RAC (2)
Restore OCR from backup in Oracle RAC 19c
Restore OCR from backup in Oracle 19c oracledna RAC January 27, 2026 In this scenario, OCR located in ASM and we lost OCR, backup of OCR file is available.Lets learn how to retore OCR from backup OCR file. 1. List the nodes of cluster [root@racnode1 ~]# olsnodesracnode1racnode2 2. If OCR is located in ASM disk group, stop the Oracle Clusterware on all nodes by root user. [root@racnode1 ~]# crsctl stop crsCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘racnode1’CRS-2673: Attempting to stop ‘ora.crsd’ on ‘racnode1’CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server ‘racnode1’CRS-2673: Attempting to stop ‘ora.qosmserver’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.racdb.db’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.chad’ on ‘racnode1’CRS-2677: Stop of ‘ora.racdb.db’ on ‘racnode1’ succeededCRS-33673: Attempting to stop resource group ‘ora.asmgroup’ on server ‘racnode1’CRS-2673: Attempting to stop ‘ora.OCRVOTEDISK.dg’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.cvu’ on ‘racnode1’CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.DATA.dg’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.racnode1.vip’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.scan3.vip’ on ‘racnode1’CRS-2677: Stop of ‘ora.OCRVOTEDISK.dg’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.asm’ on ‘racnode1’CRS-2677: Stop of ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.chad’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.racnode1.vip’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.scan3.vip’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.scan2.vip’ on ‘racnode1’CRS-2677: Stop of ‘ora.asm’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘racnode1’CRS-2677: Stop of ‘ora.scan2.vip’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.cvu’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.qosmserver’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.asmnet1.asmnetwork’ on ‘racnode1’CRS-2677: Stop of ‘ora.asmnet1.asmnetwork’ on ‘racnode1’ succeededCRS-33677: Stop of resource group ‘ora.asmgroup’ on server ‘racnode1’ succeeded.CRS-2672: Attempting to start ‘ora.qosmserver’ on ‘racnode2’CRS-2672: Attempting to start ‘ora.scan2.vip’ on ‘racnode2’CRS-2672: Attempting to start ‘ora.scan3.vip’ on ‘racnode2’CRS-2672: Attempting to start ‘ora.cvu’ on ‘racnode2’CRS-2672: Attempting to start ‘ora.racnode1.vip’ on ‘racnode2’CRS-2676: Start of ‘ora.racnode1.vip’ on ‘racnode2’ succeededCRS-2676: Start of ‘ora.scan2.vip’ on ‘racnode2’ succeededCRS-2676: Start of ‘ora.scan3.vip’ on ‘racnode2’ succeededCRS-2672: Attempting to start ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode2’CRS-2672: Attempting to start ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode2’CRS-2676: Start of ‘ora.cvu’ on ‘racnode2’ succeededCRS-2676: Start of ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode2’ succeededCRS-2676: Start of ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode2’ succeededCRS-2676: Start of ‘ora.qosmserver’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.ons’ on ‘racnode1’CRS-2677: Stop of ‘ora.ons’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.net1.network’ on ‘racnode1’CRS-2677: Stop of ‘ora.net1.network’ on ‘racnode1’ succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘racnode1’ has completedCRS-2677: Stop of ‘ora.crsd’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.asm’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.crf’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘racnode1’CRS-2677: Stop of ‘ora.crf’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.mdnsd’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.asm’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘racnode1’CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.ctssd’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.evmd’ on ‘racnode1’CRS-2677: Stop of ‘ora.ctssd’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.evmd’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.cssd’ on ‘racnode1’CRS-2677: Stop of ‘ora.cssd’ on ‘racnode1’ succeededCRS-2673: Attempting to stop ‘ora.gipcd’ on ‘racnode1’CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘racnode1’CRS-2677: Stop of ‘ora.gipcd’ on ‘racnode1’ succeededCRS-2677: Stop of ‘ora.gpnpd’ on ‘racnode1’ succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘racnode1’ has completedCRS-4133: Oracle High Availability Services has been stopped. — [root@racnode2 ~]# crsctl stop crsCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘racnode2’CRS-2673: Attempting to stop ‘ora.crsd’ on ‘racnode2’CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server ‘racnode2’CRS-2673: Attempting to stop ‘ora.racdb.db’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.qosmserver’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.chad’ on ‘racnode2’CRS-2677: Stop of ‘ora.racdb.db’ on ‘racnode2’ succeededCRS-33673: Attempting to stop resource group ‘ora.asmgroup’ on server ‘racnode2’CRS-2673: Attempting to stop ‘ora.OCRVOTEDISK.dg’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.cvu’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.racnode1.vip’ on ‘racnode2’CRS-2677: Stop of ‘ora.racnode1.vip’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.chad’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.OCRVOTEDISK.dg’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.DATA.dg’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.asm’ on ‘racnode2’CRS-2677: Stop of ‘ora.LISTENER_SCAN1.lsnr’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.LISTENER_SCAN2.lsnr’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.LISTENER_SCAN3.lsnr’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.scan1.vip’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.scan2.vip’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.scan3.vip’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.racnode2.vip’ on ‘racnode2’CRS-2677: Stop of ‘ora.scan2.vip’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.scan1.vip’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.cvu’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.scan3.vip’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.racnode2.vip’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.asm’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘racnode2’CRS-2677: Stop of ‘ora.ASMNET1LSNR_ASM.lsnr’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.asmnet1.asmnetwork’ on ‘racnode2’CRS-2677: Stop of ‘ora.asmnet1.asmnetwork’ on ‘racnode2’ succeededCRS-33677: Stop of resource group ‘ora.asmgroup’ on server ‘racnode2’ succeeded.CRS-2677: Stop of ‘ora.qosmserver’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.ons’ on ‘racnode2’CRS-2677: Stop of ‘ora.ons’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.net1.network’ on ‘racnode2’CRS-2677: Stop of ‘ora.net1.network’ on ‘racnode2’ succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on ‘racnode2’ has completedCRS-2677: Stop of ‘ora.crsd’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.asm’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.crf’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.mdnsd’ on ‘racnode2’CRS-2677: Stop of ‘ora.crf’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.mdnsd’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.asm’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.cluster_interconnect.haip’ on ‘racnode2’CRS-2677: Stop of ‘ora.cluster_interconnect.haip’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.ctssd’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.evmd’ on ‘racnode2’CRS-2677: Stop of ‘ora.ctssd’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.evmd’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.cssd’ on ‘racnode2’CRS-2677: Stop of ‘ora.cssd’ on ‘racnode2’ succeededCRS-2673: Attempting to stop ‘ora.gipcd’ on ‘racnode2’CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘racnode2’CRS-2677: Stop of ‘ora.gpnpd’ on ‘racnode2’ succeededCRS-2677: Stop of ‘ora.gipcd’ on ‘racnode2’ succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘racnode2’ has completedCRS-4133: Oracle High Availability Services has been stopped. — If, above command returns any error, stop the Oracle Clusterware with force option by below command. crsctl stop crs -f 3.