11gr2 单机 asm 操作命令(不断更新)

来源：互联网发布：linux修改eth0ip命令编辑：程序博客网时间：2024/06/08 11:59

grid

/home/grid&crsctl -h
Usage: crsctl add - add a resource, type or other entity
crsctl check - check a service, resource or other entity
crsctl config - output autostart configuration
crsctl debug - obtain or modify debug state
crsctl delete - delete a resource, type or other entity
crsctl disable - disable autostart
crsctl discover - discover DHCP server
crsctl enable - enable autostart
crsctl get - get an entity value
crsctl getperm - get entity permissions
crsctl lsmodules - list debug modules
crsctl modify - modify a resource, type or other entity
crsctl query - query service state
crsctl pin - pin the nodes in the node list
crsctl relocate - relocate a resource, server or other entity
crsctl replace - replaces the location of voting files
crsctl release - release a DHCP lease
crsctl request - request a DHCP lease
crsctl setperm - set entity permissions
crsctl set - set an entity value
crsctl start - start a resource, server or other entity
crsctl status - get status of a resource or other entity
crsctl stop - stop a resource, server or other entity
crsctl unpin - unpin the nodes in the node list
crsctl unset - unset an entity value, restoring its default
P550:/home/grid&

P550:/home/grid&srvctl -h
Usage: srvctl [-V]
Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-i <inst_name>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a "<diskgroup_list>"]
Usage: srvctl config database [-d <db_unique_name> [-a]] [-v]
Usage: srvctl start database -d <db_unique_name> [-o <start_options>]
Usage: srvctl stop database -d <db_unique_name> [-o <stop_options>] [-f]
Usage: srvctl status database -d <db_unique_name> [-f] [-v]
Usage: srvctl enable database -d <db_unique_name>

crsctl stop res -all

$ crs_start -all --启动所有的crs服务
$ crs_stop -all --停止所有的crs服务
crsctl check crs
$ crsctl start crs --启动crs服务
$ crsctl stop crs --停止crs服务

[grid@asm ~]$ crsctl stat res -t

--修改IP后：
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.100.253.x0)(PORT=1521))))' SCOPE=MEMORY SID='sgerp5';

ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.100.253.xx)(PORT=1521))))' SCOPE=MEMORY SID='+ASM';

crsctl check crs
crsctl stop crs
crsctl stop has
ocrcheck
crs_stat -p ora.cssd

crsctl start resource ora.cssd
crsctl stat res -t
crsctl start res -all

crs_stat -t
crs_stat -p ora.LISTENER.lsnr
crs_stop ora.LISTENER.lsnr
crs_unregister ora.LISTENER.lsnr
crs_register ora.LISTENER.lsnr
crs_getperm

crs_setperm
结合着crs_register遗留的owner等不一致问题，我们来看crs_getperm，
crs_getperm可以把resource详细的owner、group以及权限都可以取出来：
[root@node2 profile]# crs_getperm ora.node1.LISTENER_NODE1.lsnr
[root@node2 profile]# crs_setperm ora.node2.LISTENER_NODE2.lsnr -g oinstall
[root@node2 profile]# crs_setperm ora.node2.LISTENER_NODE2.lsnr -o oracle
[root@node2 profile]# crs_setperm ora.node2.LISTENER_NODE2.lsnr -u pgrp:oinstall:rwx
[root@node2 profile]# crs_stat -ls

&crs_stat -ls
Name Owner Primary PrivGrp Permission
-----------------------------------------------------------------
ora.DATA.dg grid oinstall rwxrwxr--
ora....ER.lsnr grid dba rwxr-xr--
ora.asm grid oinstall rwxrwxr--
ora.cssd grid oinstall rwxrwxr--
ora.diskmon grid oinstall rwxrwxr--
ora.evmd grid oinstall rw-rw-r--
ora.ons grid oinstall rwxrwxr--
ora.sgcrm5.db grid asmdba rwxr-xr--
P550:/g01/app/grid_home/bin&

ora.asmdb.db的AUTO_START值是1，disable之后看看结果：
[oracle@node2 ~]$ srvctl disable database -d sgcrm5
[oracle@node2 ~]$ crs_stat -p ora.sgcrm5.db

将css 和diskmon设置为自启动：

crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"

sh -x /u01/app/oracle/product/11.2.0/grid/bin/crsctl check has

asmcmd中spcopy/spbackup/spset/spget都是操作spfile的，cp是专门处理数据库相关文件(controlfile/redolog/datafile)的拷贝用的

oracle

$srvctl -h

Usage: srvctl [-V]
Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-i <inst_name>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a "<diskgroup_list>"]
Usage: srvctl config database [-d <db_unique_name> [-a]] [-v]
Usage: srvctl start database -d <db_unique_name> [-o <start_options>]
Usage: srvctl stop database -d <db_unique_name> [-o <stop_options>] [-f]
Usage: srvctl status database -d <db_unique_name> [-f] [-v]
Usage: srvctl enable database -d <db_unique_name>
Usage: srvctl disable database -d <db_unique_name>
Usage: srvctl modify database -d <db_unique_name> [-n <db_name>] [-i <inst_name>] [-o <oracle_home>] [-u <oracle_user>] [-m <domain>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a "<diskgroup_list>"|-z] [-f]
Usage: srvctl remove database -d <db_unique_name> [-f] [-y] [-v]
Usage: srvctl getenv database -d <db_unique_name> [-t "<name_list>"]
Usage: srvctl setenv database -d <db_unique_name> {-t <name>=<val>[,<name>=<val>,...] | -T <name>=<val>}
Usage: srvctl unsetenv database -d <db_unique_name> -t "<name_list>"
Usage: srvctl upgrade database -d <db_unique_name> -o <oracle_home>
Usage: srvctl downgrade database -d <db_unique_name> -o <oracle_home> -t <to_version>
Usage: srvctl add service -d <db_unique_name> -s <service_name> [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z <failover_retries>] [-w <failover_delay>] [-t <edition>] [-f]
Usage: srvctl config service -d <db_unique_name> [-s <service_name>] [-v]
Usage: srvctl start service -d <db_unique_name> [-s "<service_name_list>"] [-o <start_options>]
Usage: srvctl stop service -d <db_unique_name> [-s "<service_name_list>"] [-f]
Usage: srvctl status service -d <db_unique_name> [-s "<service_name_list>"] [-f] [-v]
Usage: srvctl enable service -d <db_unique_name> -s "<service_name_list>"
Usage: srvctl disable service -d <db_unique_name> -s "<service_name_list>"
Usage: srvctl modify service -d <db_unique_name> -s <service_name> [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <integer>] [-w <integer>] [-t <edition>]
Usage: srvctl remove service -d <db_unique_name> -s <service_name> [-f]
Usage: srvctl add asm [-l <lsnr_name>] [-p <spfile>] [-d <asm_diskstring>]
Usage: srvctl config asm [-a]
Usage: srvctl start asm [-o <start_options>]
Usage: srvctl stop asm [-o <stop_options>] [-f]
Usage: srvctl status asm [-a] [-v]
Usage: srvctl enable asm
Usage: srvctl disable asm
Usage: srvctl modify asm [-l <lsnr_name>] [-p <spfile>] [-d <asm_diskstring>]
Usage: srvctl remove asm [-f]
Usage: srvctl getenv asm [-t <name>[, ...]]
Usage: srvctl setenv asm -t "<name>=<val> [,...]" | -T "<name>=<value>"
Usage: srvctl unsetenv asm -t "<name>[, ...]"
Usage: srvctl start diskgroup -g <dg_name>
Usage: srvctl stop diskgroup -g <dg_name> [-f]
Usage: srvctl status diskgroup -g <dg_name> [-a] [-v]
Usage: srvctl enable diskgroup -g <dg_name>
Usage: srvctl disable diskgroup -g <dg_name>
Usage: srvctl remove diskgroup -g <dg_name> [-f]
Usage: srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-o <oracle_home>]
Usage: srvctl config listener [-l <lsnr_name>]
Usage: srvctl start listener [-l <lsnr_name>]
Usage: srvctl stop listener [-l <lsnr_name>] [-f]
Usage: srvctl enable listener [-l <lsnr_name>]
Usage: srvctl disable listener [-l <lsnr_name>]
Usage: srvctl modify listener [-l <lsnr_name>] [-o <oracle_home>] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"]
Usage: srvctl remove listener [-l <lsnr_name> | -a] [-f]
Usage: srvctl getenv listener [-l <lsnr_name>] [-t <name>[, ...]]
Usage: srvctl setenv listener [-l <lsnr_name>] -t "<name>=<val> [,...]" | -T "<name>=<value>"
Usage: srvctl unsetenv listener [-l <lsnr_name>] -t "<name>[, ...]"
Usage: srvctl start home -o <oracle_home> -s <state_file>
Usage: srvctl stop home -o <oracle_home> -s <state_file> [-t <stop_options>] [-f]
Usage: srvctl status home -o <oracle_home> -s <state_file>
Usage: srvctl add ons [-e <em-port>] [-l <ons-local-port>] [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
Usage: srvctl remove ons [-f] [-v]
Usage: srvctl enable ons [-v]
Usage: srvctl disable ons [-v]
Usage: srvctl modify ons [-e <em-port>] [-l <ons-local-port>] [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
Usage: srvctl config ons
Usage: srvctl status ons [-v]
Usage: srvctl start ons [-v]
Usage: srvctl stop ons [-v]
P550:/orabak$