Вы здесь
Полезные запросы ASM
Опубликовано ср, 11/20/2019 - 14:20 пользователем talifa
select substr(d.name,1,4),d.group_number, sum(d.total_mb), sum(d.free_mb)
from v$asm_diskgroup dg,v$asm_disk d
where d.group_number = dg.group_number
group by substr(d.name,1,4),d.group_number;
select dg.name, d.name, d.path, d.total_mb, d.free_mb
from v$asm_diskgroup dg,
v$asm_disk d
where d.group_number = dg.group_number
order by free_mb, 1, 2;
alter tablespace SYSAUX add datafile '+DATADG' size 10G
find /app -name alert* -exec ls -l -h {} \;
find /app -mtime -10 -name "alert*.log" -exec ls -l -h {} \;
-rw-r----- 1 grid oinstall 298K Sep 5 08:37 /app/grid/product/11.2.0/grid/log/diag/asm/+asm/+ASM/trace/alert_+ASM.log
-rw-r--r-- 1 grid oinstall 70K Sep 5 11:36 /app/grid/product/11.2.0/grid/log/diag/asmcmd/user_grid/siebel-psi-db/alert/alert.log
Connected to an idle instance.
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
Connected to an idle instance.
NOTE: Discovering disks using kfod..
-rw-r--r-- 1 grid oinstall 3 Sep 5 11:52 /app/grid/product/11.2.0/grid/log/siebel-psi-db/alert_siebel-psi-db.log
/app/oracle/diag/rdbms/newsbl/newsbl/trace/alert_newsbl.log
srvctl start asm
PRCR-1070 : Failed to check if resource ora.asm is registered
Cannot communicate with crsd
crsctl start has
________________________________________________ место
/usr/sbin/oracleasm listdisks
set lin 300 pages 0
column name format a20
column path format a30
select dg.name, d.name, d.path, d.total_mb, d.free_mb
from v$asm_diskgroup dg,
v$asm_disk d
where d.group_number = dg.group_number
order by free_mb, 1, 2;
select dg.name, sum(d.total_mb), sum(d.free_mb) from v$asm_diskgroup dg, v$asm_disk d
where d.group_number = dg.group_number
group by dg.name;
NAME NAME PATH TOTAL_MB FREE_MB
-------------------- -------------------- -------------------- ---------- ----------
DATA DATAVOL1 ORCL:DATAVOL1 102399 236
DATA DATAVOL2 ORCL:DATAVOL2 102397 243
ARCH ARCHVOL1 ORCL:ARCHVOL1 51199 50983
NAME NAME PATH TOTAL_MB FREE_MB
-------------------- -------------------- -------------------- ---------- ----------
ARCH ARCHVOL1 ORCL:ARCHVOL1 51196 51136
DATA DATAVOL1 ORCL:DATAVOL1 102397 60617
DATA DATAVOL2 ORCL:DATAVOL2 102399 60619
DATA DATAVOL3 ORCL:DATAVOL3 307196 181964
FRA FRAVOL1 ORCL:FRAVOL1 204796 203587
alter diskgroup DATA add failgroup ORCL:DATAVOL3 disk 'DATAVOL3' name DATAVOL3;
create diskgroup FRA EXTERN redundancy failgroup FRAVOL1 disk '/dev/raw/raw3' name FRAVOL1;
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 EXTERN N 512 4096 1048576 51196 51136 0 51136 0 N ARCH/
MOUNTED EXTERN N 512 4096 1048576 511992 303200 0 303200 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 204796 203010 0 203010 0 N FRA/
alter diskgroup DATA add disk '/dev/rhdisk210' rebalance power 8
select group_kfdat "group #",
number_kfdat "disk #",
count(*) "# AU's"
from x$kfdat a
where v_kfdat = 'V'
and not exists (select *
from x$kfdat b
where a.group_kfdat = b.group_kfdat
and a.number_kfdat = b.number_kfdat
and b.v_kfdat = 'F')
group by GROUP_KFDAT, number_kfdat;
If no rows are returned ... the following query can also be used
select disk_number "Disk #", free_mb
from v$asm_disk
--where group_number = *** disk group number ***
order by 2;
select name ,GROUP_NUMBER from v$asm_alias;
_________________________________________________________________ добавить
sqlplus / as sysasm
DATA13
тип ридонданси
select GROUP_NUMBER,NAME,TYPE from v$asm_diskgroup;
SQL> l
1* select path,header_status from v$asm_disk
SQL> /
ORCL:DATAVOL3
PROVISIONED
ORCL:FRAVOL1
PROVISIONED
ORCL:ARCHVOL1
MEMBER
ORCL:DATAVOL1
MEMBER
ORCL:DATAVOL2
MEMBER
sqlplus “/ as sysasm”
CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK 'ORCL:FRAVOL1'
ALTER DISKGROUP DATA ADD DISK 'ORCL:DATA13' NAME DATA13 REBALANCE POWER 1;
DATA13
set lin 300 pages 0
column name format a20
column path format a20
select dg.name, d.name, d.path, d.total_mb, d.free_mb
from v$asm_diskgroup dg,
v$asm_disk d
where d.group_number = dg.group_number
order by free_mb, 1, 2;
_________________________________________________________________ валидность
select GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS,REDUNDANCY,NAME,FAILGROUP
from v$asm_diskgroup ;
select
GROUP_NUMBER,
DISK_NUMBER
from v$asm_diskgroup ;
select
GROUP_NUMBER,
DISK_NUMBER ,
MOUNT_STATUS,
HEADER_STATUS,
MODE_STATUS,
STATE ,
REDUNDANCY,
TOTAL_MB ,
FREE_MB,
NAME,
FAILGROUP,
LABEL,
PATH,
PRODUCT ,
CREATE_DATE ,
MOUNT_DATE ,
REPAIR_TIMER ,
READS,
WRITES ,
FAILGROUP_TYPE,
CON_ID
from v$asm_disk ;
select NAME, FAILGROUP, PATH from v$asm_disk ;
Menu:
source:
Post new comment