Tuesday 4 July 2023

Oracle Grid Installation/ASM Storage for Single Instance Database

 


  • Download Grid Infrastructure software 19c with latest patch set (19.19)
  • 100 GB space required for 19c Grid Binaries
  • Grid Instance for ASM -> need to install Grid Infrastructure for Standalone Server 
  • Disk Space required for ASM Disk group as below.


Set ASM disks

# oracleasm configure -i

Create ASM disks

oracleasm createdisk OCR  /dev/ASM/LV_OCR

oracleasm createdisk DATA_DG1 /dev/ASM/LV_EASYDB_DATA

oracleasm createdisk FRA_DG1 /dev/ASM/LV_EASYDB_FRA

oracleasm createdisk REDO_DG1 /dev/ASM/LV_EASYDB_REDO1

oracleasm createdisk REDO_DG2 /dev/ASM/LV_EASYDB_REDO2

oracleasm createdisk BKP_DG1 /dev/ASM/LV_EASYDB_BKP


100 G =  OCR Disk   High Redundancy

3TB  = Archive log    External Redundancy

50 TB = Datafiles     External Redundancy   

100 G = redolog1    External Redundancy 

100 G = redolog2    External Redundancy 

1TB  = For BKP Dump External Redundancy 


Oracle ASM Storage Limits

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

Oracle ASM provides near unlimited capacity for future growth, but does have some storage limits. 

For example, Oracle ASM has the following limits on the number of disk groups, disks, and files:


• 63 disk groups in a storage system

• 10,000 Oracle ASM disks in a storage system

• 1 million files for each disk group


Without any Oracle Exadata Storage, Oracle ASM has these storage limits:


• 2 terabytes (TB) maximum storage for each Oracle ASM disk

• 20 petabytes (PB) maximum for the storage system


Value of COMPATIBLE.ASM must always be greater than or equal to the value of COMPATIBLE.RDBMS.  

It means Grid Home Version equal to RDBMS version or greater than RDBMS.


No comments:

Post a Comment