반응형
기존 상태 확인
[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 845M 31G 3% /dev/shm
tmpfs 32G 17M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/mapper/vg00-root 9.6G 2.9G 6.2G 32% /
/dev/sda2 488M 237M 216M 53% /boot
/dev/mapper/vg00-var 5.7G 156M 5.3G 3% /var
/dev/mapper/vg00-home 960M 2.7M 891M 1% /home
/dev/mapper/vg00-var_log 3.8G 19M 3.6G 1% /var/log
/dev/mapper/vg00-opt 39G 1.9G 36G 6% /opt
/dev/mapper/vg00-var_log_audit 1.9G 13M 1.8G 1% /var/log/audit
/dev/sda1 128M 7.5M 121M 6% /boot/efi
tmpfs 32G 4.0K 32G 1% /var/tmp
tmpfs 32G 256K 32G 1% /tmp
/dev/sdh 196G 33G 154G 18% /u01
tmpfs 6.3G 0 6.3G 0% /run/user/102
tmpfs 6.3G 0 6.3G 0% /run/user/1000
/dev/asm/commonstore-62 10G 329M 9.7G 4% /opt/oracle/dcs/commonstore
/dev/asm/volume1-62 10G 329M 9.7G 4% /u02
tmpfs 6.3G 0 6.3G 0% /run/user/0
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
ONLINE ONLINE one19c STABLE
ora.DATA.VOLUME1.advm
ONLINE ONLINE one19c STABLE
ora.LISTENER.lsnr
ONLINE ONLINE one19c STABLE
ora.chad
ONLINE ONLINE one19c STABLE
ora.data.commonstore.acfs
ONLINE ONLINE one19c mounted on /opt/orac
le/dcs/commonstore,S
TABLE
ora.data.volume1.acfs
ONLINE ONLINE one19c mounted on /u02,STAB
LE
ora.net1.network
ONLINE ONLINE one19c STABLE
ora.ons
ONLINE ONLINE one19c STABLE
ora.proxy_advm
ONLINE ONLINE one19c STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE one19c Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.cvu
1 ONLINE ONLINE one19c STABLE
ora.one19c.vip
1 ONLINE ONLINE one19c STABLE
ora.one19c_icn153.db
1 ONLINE ONLINE one19c Open,HOME=/u01/app/o
racle/product/19.0.0
.0/dbhome_1,STABLE
ora.qosmserver
1 ONLINE ONLINE one19c STABLE
ora.scan1.vip
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ acfsutil info fs
/u02
ACFS Version: 19.0.0.0.0
on-disk version: 49.0
compatible.advm: 19.0.0.0.0
ACFS compatibility: 19.0.0.0.0
flags: MountPoint,Available,KiloSnap
creation time: Tue Sep 27 14:39:52 2022
mount time: Wed Sep 28 08:59:50 2022
mount sequence number: 0
number of nodes: 1
allocation unit: 4096
metadata block size: 4096
volumes: 1
total size: 10737418240 ( 10.00 GB )
total free: 10392436736 ( 9.68 GB )
file entry table allocation: 262144
primary volume: /dev/asm/volume1-62
label:
state: Available
major, minor: 251, 31746
logical sector size: 512
size: 10737418240 ( 10.00 GB )
free: 10392436736 ( 9.68 GB )
metadata read I/O count: 2090
metadata write I/O count: 10
total metadata bytes read: 8560640 ( 8.16 MB )
total metadata bytes written: 40960 ( 40.00 KB )
ADVM diskgroup: DATA
ADVM resize increment: 67108864
ADVM redundancy: unprotected
ADVM stripe columns: 8
ADVM stripe width: 1048576
number of snapshots: 0
snapshot space usage: 0 ( 0.00 )
replication status: DISABLED
compression status: DISABLED
/opt/oracle/dcs/commonstore
ACFS Version: 19.0.0.0.0
on-disk version: 49.0
compatible.advm: 19.0.0.0.0
ACFS compatibility: 19.0.0.0.0
flags: MountPoint,Available,KiloSnap
creation time: Mon Sep 26 09:59:48 2022
mount time: Wed Sep 28 08:59:50 2022
mount sequence number: 1
number of nodes: 1
allocation unit: 4096
metadata block size: 4096
volumes: 1
total size: 10737418240 ( 10.00 GB )
total free: 10392502272 ( 9.68 GB )
file entry table allocation: 262144
primary volume: /dev/asm/commonstore-62
label:
state: Available
major, minor: 251, 31745
logical sector size: 512
size: 10737418240 ( 10.00 GB )
free: 10392502272 ( 9.68 GB )
metadata read I/O count: 2111
metadata write I/O count: 10
total metadata bytes read: 8646656 ( 8.25 MB )
total metadata bytes written: 40960 ( 40.00 KB )
ADVM diskgroup: DATA
ADVM resize increment: 67108864
ADVM redundancy: unprotected
ADVM stripe columns: 8
ADVM stripe width: 1048576
number of snapshots: 0
snapshot space usage: 0 ( 0.00 )
replication status: DISABLED
compression status: DISABLED
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 262144 236248 0 236248 0 Y DATA/
MOUNTED EXTERN N 512 512 4096 4194304 262144 257020 0 257020 0 N RECO/
[grid@one19c ~]$
[grid@one19c ~]$ crsctl status res ora.data.volume1.acfs -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.data.volume1.acfs
ONLINE ONLINE one19c mounted on /u02,STAB
LE
--------------------------------------------------------------------------------
[grid@one19c ~]$
[grid@one19c ~]$ sqlplus "/as sysasm"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 28 09:24:08 2022 Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0
SQL> col volume_name for a20
SQL> col volume_device for a50
SQL> set linesize 150
SQL> SELECT volume_name, volume_device FROM V$ASM_VOLUME;
VOLUME_NAME VOLUME_DEVICE
-------------------- --------------------------------------------------
COMMONSTORE /dev/asm/commonstore-62
VOLUME1 /dev/asm/volume1-62
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.16.0.0.0
[grid@one19c ~]$
[grid@one19c ~]$ACFS 삭제
--ACFS FIlesystem Resources 중지
[grid@one19c ~]$ srvctl stop filesystem -volume VOLUME1 -diskgroup DATA
--ACFS Filesystem Resources 삭제
[root@one19c bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]#
[root@one19c bin]#
[root@one19c bin]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c bin]# pwd
/u01/app/19.0.0.0/grid/bin
[root@one19c bin]# ./srvctl remove filesystem -volume VOLUME1 -diskgroup DATA
[root@one19c bin]# ./crsctl status res ora.data.volume1.acfs -t
CRS-2613: Could not find resource 'ora.data.volume1.acfs'.
[root@one19c bin]# ./crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
ONLINE ONLINE one19c STABLE
ora.DATA.VOLUME1.advm
ONLINE ONLINE one19c STABLE
ora.LISTENER.lsnr
ONLINE ONLINE one19c STABLE
ora.chad
ONLINE ONLINE one19c STABLE
ora.data.commonstore.acfs
ONLINE ONLINE one19c mounted on /opt/orac
le/dcs/commonstore,S
TABLE
ora.net1.network
ONLINE ONLINE one19c STABLE
ora.ons
ONLINE ONLINE one19c STABLE
ora.proxy_advm
ONLINE ONLINE one19c STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE one19c Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE one19c STABLE
ora.cvu
1 ONLINE ONLINE one19c STABLE
ora.one19c.vip
1 ONLINE ONLINE one19c STABLE
ora.one19c_icn153.db
1 ONLINE ONLINE one19c Open,HOME=/u01/app/o
racle/product/19.0.0
.0/dbhome_1,STABLE
ora.qosmserver
1 ONLINE ONLINE one19c STABLE
ora.scan1.vip
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[root@one19c bin]#
[root@one19c bin]#
[root@one19c bin]# ./asmcmd lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 262144 236248 0 236248 0 Y DATA/
MOUNTED EXTERN N 512 512 4096 4194304 262144 257020 0 257020 0 N RECO/
[root@one19c bin]#
--ACFS Volume 삭제
[grid@one19c ~]$ id
uid=102(grid) gid=1001(oinstall) groups=1001(oinstall),1002(dbaoper),1004(asmadmin),1005(asmoper),1006(asmdba)
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd volinfo --all
Diskgroup Name: DATA
Volume Name: COMMONSTORE
Volume Device: /dev/asm/commonstore-62
State: ENABLED
Size (MB): 10240
Resize Unit (MB): 64
Redundancy: UNPROT
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /opt/oracle/dcs/commonstore
Volume Name: VOLUME1
Volume Device: /dev/asm/volume1-62
State: ENABLED
Size (MB): 10240
Resize Unit (MB): 64
Redundancy: UNPROT
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /u02
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd voldelete -G DATA VOLUME1
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd volinfo --all
Diskgroup Name: DATA
Volume Name: COMMONSTORE
Volume Device: /dev/asm/commonstore-62
State: ENABLED
Size (MB): 10240
Resize Unit (MB): 64
Redundancy: UNPROT
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /opt/oracle/dcs/commonstore
[grid@one19c ~]$
[grid@one19c ~]$ asmcmd lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 262144 246492 0 246492 0 Y DATA/
MOUNTED EXTERN N 512 512 4096 4194304 262144 257020 0 257020 0 N RECO/
[grid@one19c ~]$
[grid@one19c ~]$ exit
logout
[root@one19c /]# id
uid=0(root) gid=0(root) groups=0(root)
[root@one19c /]# rm -rf /u02
[root@one19c /]#
반응형