Here are a couple of handy commands, especially if you are on an ODA
As root, you can see what space is being used by what database:
[root@sodax6-1 datastore]# oakcli show dbstorage
All the DBs with DB TYPE as non-CDB share the same volumes
DB_NAMES DB_TYPE Filesystem Size Used Available AutoExtend Size DiskGroup
------- ------- ------------ ------ ----- --------- ---------------- --------
JDEPROD, JDETEST non-CDB /u01/app/oracle/oradata/datastore 31G 16.26G 14.74G 3G REDO
/u02/app/oracle/oradata/datastore 4496G 4346.01G 149.99G 102G DATA
/u01/app/oracle/fast_recovery_area/datastore 1370G 761.84G 608.16G 36G RECO
Of course, this is what ACFS thinks:
[grid@sodax6-1 ~]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/xvda2 57191708 14193400 40093068 27% /
tmpfs 264586120 1246300 263339820 1% /dev/shm
/dev/xvda1 471012 35731 410961 8% /boot
/dev/xvdb1 96119564 50087440 41149436 55% /u01
/dev/asm/testing-216 1048576000 601013732 447562268 58% /u01/app/sharedrepo/testing
/dev/asm/datastore-344
32505856 17050504 15455352 53% /u01/app/oracle/oradata/datastore
/dev/asm/acfsvol-49 52428800 194884 52233916 1% /cloudfs
/dev/asm/datastore-49
1436549120 798850156 637698964 56% /u01/app/oracle/fast_recovery_area/datastore
/dev/asm/testing2-216
4194304000 1575520568 2618783432 38% /u01/app/sharedrepo/testing2
/dev/asm/datastore-216
4714397696 4661989408 52408288 99% /u02/app/oracle/oradata/datastore
Now, you might want to take a look at what ASM thinks about this
[grid@sodax6-1 ~]$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 4194304 19660800 198252 983040 -392394 0 Y DATA/
MOUNTED NORMAL N 512 4096 4194304 3230720 321792 161536 80128 0 N RECO/
MOUNTED HIGH N 512 4096 4194304 762880 667144 381440 95234 0 N REDO/
A bit more detial thanks:
[grid@sodax6-1 ~]$ asmcmd volinfo -G DATA -a
Diskgroup Name: DATA
Volume Name: DATASTORE
Volume Device: /dev/asm/datastore-216
State: ENABLED
Size (MB): 4603904
Resize Unit (MB): 64
Redundancy: MIRROR
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /u02/app/oracle/oradata/datastore
Volume Name: TESTING
Volume Device: /dev/asm/testing-216
State: ENABLED
Size (MB): 1024000
Resize Unit (MB): 64
Redundancy: MIRROR
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /u01/app/sharedrepo/testing
Volume Name: TESTING2
Volume Device: /dev/asm/testing2-216
State: ENABLED
Size (MB): 4096000
Resize Unit (MB): 64
Redundancy: MIRROR
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /u01/app/sharedrepo/testing2
So now, I want to resize, as I’ve made my repo TESTING2 too big and I need some more space in my DATASTORE – so…
[grid@sodax6-1 ~]$ acfsutil size -1T /u01/app/sharedrepo/testing2
acfsutil size: new file system size: 3195455668224 (3047424MB)
and you can see that ACFS actually uses the “Auto-resize increment” to add to the FS when it’s low:
DB_NAMES DB_TYPE Filesystem Size Used Available AutoExtend Size DiskGroup
------- ------- ------------ ------ ----- --------- ---------------- --------
JDEPROD, JDETEST non-CDB /u01/app/oracle/oradata/datastore 31G 16.26G 14.74G 3G REDO
/u02/app/oracle/oradata/datastore 4598G 4446.22G 151.78G 102G DATA
/u01/app/oracle/fast_recovery_area/datastore 1370G 761.84G 608.16G 36G RECO
In my example it’ll add 102GB when low. So before I resized the /TESTING2 repo, things looked like this:
/dev/asm/datastore-216
4714397696 4661989408 52408288 99% /u02/app/oracle/oradata/datastore
After resizing
/dev/asm/datastore-216
4821352448 4662201568 159150880 97% /u02/app/oracle/oradata/datastore
So it’s seen that there is some free space (the 1TB I stole) and has given this back to the data area.
Note that I could have done this with oakcli resize repo (but I did not know that at the time).
No comments:
Post a Comment