md_backup: 将disk group中的metadata备份到文件; md_backup /tmp/backupfile -G DATAGP
md_restore: 将备份文件中的metadata恢复到disk group; md_restore -full -G data --silent /tmp/file
lsattr: 列出disk group的属性; lsattr -l -G DATAGP
setattr: 设置disk group的属性; setattr -G DATAGP compataible.asm 11.2.0.0.0
cd, cp, du, help, ls, makedir, pwd, rm
find: 查找; find --type CONTROLFILE +data/orcl *
lsct: 显示v$asm_client的信息, ASM client的信息; lsct DATAGP
lsdg: 显示disk group的信息,v$asm_diskgroup and v$asm_diskgroup_stat; lsdg DATAGP
lsof: 显示local clients的open files; lsof -G DATAGP
mkalias: 给文件取个别名; mkalias SYSAUX.235.34323 sysaux.f; ls --absolutepath可以查看
rmalias: 删除别名; rmalias sysaux.f
chdg: 修改disk group, add或drop disk; chdg DATAGP_config.xml
chkdg: check 或 repair disk group 的metadata; chkdg --repair DATAGP
dropdg: drop disk group; dropdg -r -f DATAGP
iostat: 查看I/O statics通过v$asm_disk_iostat; iostat -G DATAGP
lsdsk: list ASM disks; lsdsk -p -G DATAGP /dev/raw/* ; lsdsk --candidate -p
lsod: list open ASM disks; lsod -G DATAGP
mkdg: create disk group based on a xml file; mkdg DATAGP_config.xml
mount: mount a disk group; mount -f DATAGP; mount --restrict DATAGP; mount -a
offline: offline disks or failure groups that belong to disk group. offline -G DATAGP -F FG1
online: online disks or a failure group; online -G DATAGP -D data_0001 --power=3
rebal: rebalance a disk group; rebal --power 4 DATAGP
remap: mark blocks as unusable on the disk and relocates data; remap DATAGP data_0001 500-700
umount: dismount a disk group; unmount -f DATAGP
pwcopy: copy password file; pwcopy --asm +DG/mydir/mypwfile +DG1/mypwfile
pwcreate: create password file for sys; pwcreate --asm +DG/mdir/mypwfile 'welcome'
pwdelete: delete password file; pwdelete --asm +DG/mydir/mypwfile
pwget: get the location of password file; pwget --asm
pwmove: move password file; pwmove --asm +DG/mydir/mypwfile +DG1/mypwfile
pwset: set the location of password file; pwset -dbuniquename aime1 +DG/mydir/mypwfile
dsget: get the discovery disk string; dsget
dsset: set the discovery disk string; dsset /dev/raw/*
lsop: list current operations on disk group from v$asm_operation; lsop
shutdown: shutdown ASM instance; shut immediate
spbackup: backup ASM Spfile; spbackup +DATA/asm/asmprameterfile/register.323.234
+DATA/spf.bak
spcopy: copy spfile; spcopy +DATA/asm/asmprameterfile/register.323.234 +DATA/spf.ora
spget: get the spfile location; spget
spmove: move spfile; spmove +DATA/spf.ora +DATA1/spf.ora
spset: set the location of spfile; spset +DATA/spf.ora
startup: start up ASM instance; startup --nomount --pfile asm.ora
chtmpl:改变template的属性;chtmpl -G DATAGP --redundancy high --striping fine mytemplate
lstmpl: list templates; ls -l -G DATAGP
mktmpl: add template to disk group; mktmpl -G DATA --redundancy mirror --striping coarse
mytp
rmtmpl: remove template from disk group; rmtmpl -G DATAGP mytp
chgrp: change user group of files; chgrp asm-data +data/mydir/a.f
chmod: change permissions of files; chmod 640 a.f; ls --permission a.f
chown: change owner of files; chown user:usergroup a.f
groups: list all user groups of a user; groups DATAGP user
grpmod: add or remove OS users to ASM user group; grpmod --add fra asm_fra oracle1 oracle2
lsgrp: list all ASM user groups; lsgrp -a
lspwusr: list users from ASM password file; lspwusr
lsusr: list users in a disk group; lsusr -G DATAGP
mkgrp: create new ASM user group; mkgrp DATAGP asm_data oracle1 oracle2
mkusr: add OS user to a disk group; mkusr DATA oracle1
orapwusr: add, drop, modify ASM password file user; orapwusr --add --privilege sysdba hrusr
passwd: change password of a user; passwd oracle2
rmgrp: remove a user group from disk group; rmgrp DATAGP asm_data
rmusr: remove a OS user from disk group; rmusr DATAGP oracle2
rpusr: replace OS user1 with OS user2; rpusr DATAGP oracle1 oracle2
volcreate: create an ADVM volume in disk group; volcreate -G DATA -s 10G --width 64K --column 8 volume1
voldelete: delete an ADVM volume; voldelete -G DATAGP volume1
voldisable:
disable an ADVM volumes in mounted disk groups and remove the volume
device on the local node; voldisable -G DATAGP volume1
volenable: enable ADVM volume in mounted disk groups; volenable -G DATAGP volume1
volinfo: display information of ADVM volumes; volinfo -G DATAGP volume1
volresize: resize an ADVM volume; volresize -G DATAGP -s 20G volume1
volset: set attributes of ADVM volume; volset -G DATA --usagestring 'no file system attached' volume1
volstat: report I/O statistics of ADVM volume; volstat -G DATAGP
相关文章
关键词:
- •oracle创建表空间,数据文件,以及移动数据文件
- •oracle数据文件是recover状态
- •oracle19c grid软件安装报错:正在验证节点连接性...失败 (PRVG-1172, PRVG-11067, PRVG-11095)
- •oracle报错alter database backup controlfile
- •oracle adg备库使用archive log list显示的都是0
- •oracle adg报错ORA-17628: Oracle error 19505 returned by remote Oracle server
- •oracle报错ORA-09925: Unable to create audit trail file
- •oracle rac创建数据库时报错ASMB (ospid: 16278): terminating the instance due to error 15064
发表评论