Rac 常用管理命令 二

提供给公司开发人员的Rac 常用管理命令 二

srvctl add命令详细选项

-m　　 数据库域名　格式如”luda.domain.com”

-m 选项指定的数据库域名必须匹配数据库INIT.ORA或者SPFILE中DB_DOMAIN 和DB_NAME参数。在增加数据库时，-d指定的数据库名必须与DB_NAME参数匹配

-n　　 实例节点名

-o　　 $ORACLE_HOME（用来确定lsnrctl和Oracle等命令路径）

-s　　 SPFILE 文件名

实例：添加一个新的数据库

srvctl add　database　-d ldrac -o /oracle/product/10.2.1

实例：向数据库添加实例

srvctl add instance -d ldrac -i　ldrac1 -n node1

srvctl add instance -d ldrac -i　ldrac2 -n node2

srvctl Config

显示保存在SRVM配置文件中的配置信息

srvctl config database

ORACLE@node1:/home/oracle/>srvctl config database
ldrac
　　
显示数据库配置列表

srvctl config database -d ldrac

数据库配置信息显示的格式：

ORACLE@node1:/home/oracle/>srvctl config database -d ldrac
node1 ldrac1 /oracle/product/10.2.0/db_1
node2 ldrac2 /oracle/product/10.2.0/db_1

实例：显示数据库配置信息

srvctl config database -d ldrac1

srvctl Getenv

getenv操作用来从SRVM配置文件中获取与显示环境变量

srvctl getenv database -d database_name [-t name[，name，……]]

srvctl getenv instance -d database_name -i instance_name [-t name[，name，……]]

实例：列出数据库的所有环境变量

srvctl getenv database -d ldrac

srvctl Modify

详细的操作命令可以通过srvctl -h 查询

srvctl add/delete .. 添加删除资源
srvctl status .. 资源状态监测
srvctl start/stop .. 资源启、止
srvctl modify .. 修改资源属性

显示节点应用状态：
srvctl status nodeapps –n ldrac1
添加应用 如为节点添加vip：
srvctl add nodeapps –n node1 –o /oracle/product/10.2.1 –A ‘10.10.10.23/255.255.255.0’
当用户需要改变已有节点的虚拟地址时，先将该节点的应用程序停止，再删除，再添加。
启动/停止/移除 组件
srvctl start/stop/remove nodeapps –n node1

srvctl config –显示数据库
srvctl config database –d ldrac —-显示实例名
srvctl status database –d ldrac —-显示实例状态
srvctl remove database –d ldrac —-删除库信息
重新创建基本配置： -d database –o oracle_home -i instance –n node
srvctl add database –d rac –o /oracle/product/10.2.1
srvctl add instance –d rac –i ldrac1 –n node1
srvctl add instance –d rac –i ldrac2 –n node2

srvctl status asm –n node1
srvctl add asm –n rac –I +ASM1 –o /oracle/product/10.2.1 —-添加ASM实例
srvctl modify instance –d rac –i –ldrac1 –s +ASM1 —-创建数据与ASM实例的关联
-s 表示两者之间的关联
关闭实例
srvctl stop instance –d rac –I ldrac1 –o immediate
srvctl disable instance –d rac –I ldrac1
srvctl stop asm –n node1 –I +ASM1 –o immediate
srvctl disable asm –n node1 –I +ASM1
启动实例
srvctl enable instance –d rac –I ldrac1
srvctl start instance –d rac –I ldrac1 –o immediate
srvctl enable asm –n node1 –I +ASM1
srvctl start asm –n node1 –I +ASM1 –o immediate
srvctl stop database –d rac
srvctl disable database –d rac

管理服务
srvctl config services –d rac –s luda —-显示服务状态
srvctl add service –d rac –s luda –r ldrac2 –a ldrac1 -P NONE —-创建服务
srvctl start service –d rac —启动服务
–s luda –r 首选实例 -a 可用实例 –p 故障切换策略（none,basic,preconnect）
–未将服务添加到tnsnames.ora中
srvctl add service –d rac –s luda –u –a ldrac3 —-将ldrac3对luda改为可用
srvctl modify service –d rac –s luda –i ldrac3 –r —-将ldrac3在luda中可用改为首选运行，服务重启后生效

ORACLE@node1:/home/oracle/>srvctl -h

Usage: srvctl [-V]
Usage: srvctl add database -d -o [-m ] [-p ] [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s ] [-n ] [-y {AUTOMATIC | MANUAL}]
Usage: srvctl add instance -d -i -n
Usage: srvctl add service -d -s -r “” [-a ““] [-P ]
Usage: srvctl add service -d -s -u {-r “” | -a ““}
Usage: srvctl add nodeapps -n -o -A /netmask[/if1[|if2|…]]
Usage: srvctl add asm -n -i -o [-p ]
Usage: srvctl config database
Usage: srvctl config database -d [-a] [-t]
Usage: srvctl config service -d [-s ] [-a] [-S ]
Usage: srvctl config nodeapps -n [-a] [-g] [-o] [-s] [-l]
Usage: srvctl config asm -n
Usage: srvctl config listener -n
Usage: srvctl disable database -d
Usage: srvctl disable instance -d -i “”
Usage: srvctl disable service -d -s “” [-i ]
Usage: srvctl disable asm -n [-i ]
Usage: srvctl enable database -d
Usage: srvctl enable instance -d -i “”
Usage: srvctl enable service -d -s “” [-i ]
Usage: srvctl enable asm -n [-i ]
Usage: srvctl getenv database -d [-t ““]
Usage: srvctl getenv instance -d -i [-t ““]
Usage: srvctl getenv service -d -s [-t ““]
Usage: srvctl getenv nodeapps -n [-t ““]
Usage: srvctl modify database -d [-n ] [-m ] [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s ] [-y {AUTOMATIC | MANUAL}]
Usage: srvctl modify instance -d -i -n
Usage: srvctl modify instance -d -i {-s | -r}
Usage: srvctl modify service -d -s -i -t [-f]
Usage: srvctl modify service -d -s -i -r [-f]
Usage: srvctl modify service -d -s -n -i [-a ] [-f]
Usage: srvctl modify asm -n -i -p
Usage: srvctl relocate service -d -s -i -t [-f]
Usage: srvctl remove database -d [-f]
Usage: srvctl remove instance -d -i [-f]
Usage: srvctl remove service -d -s [-i ] [-f]
Usage: srvctl remove nodeapps -n “” [-f]
Usage: srvctl remove asm -n [-i ] [-f]
Usage: srvctl setenv database -d {-t =[,=,…] | -T =}
Usage: srvctl setenv instance -d [-i ] {-t “=[,=,…]” | -T “=“}
Usage: srvctl setenv service -d [-s ] {-t “=[,=,…]” | -T “=“}
Usage: srvctl setenv nodeapps -n {-t “=[,=,…]” | -T “=“}
Usage: srvctl start database -d [-o ] [-c | -q]
Usage: srvctl start instance -d -i “” [-o ] [-c | -q]
Usage: srvctl start service -d [-s “” [-i ]] [-o ] [-c | -q]
Usage: srvctl start nodeapps -n
Usage: srvctl start asm -n [-i ] [-o ] [-c | -q]
Usage: srvctl start listener -n [-l ]
Usage: srvctl status database -d [-f] [-v] [-S ]
Usage: srvctl status instance -d -i “” [-f] [-v] [-S ]
Usage: srvctl status service -d [-s ““] [-f] [-v] [-S ]
Usage: srvctl status nodeapps -n
Usage: srvctl status asm -n
Usage: srvctl stop database -d [-o ] [-c | -q]
Usage: srvctl stop instance -d -i “” [-o ] [-c | -q]
Usage: srvctl stop service -d [-s “” [-i ]] [-c | -q] [-f]
Usage: srvctl stop nodeapps -n
Usage: srvctl stop asm -n [-i ] [-o ] [-c | -q]
Usage: srvctl stop listener -n [-l ]
Usage: srvctl unsetenv database -d -t “”
Usage: srvctl unsetenv instance -d [-i ] -t “”
Usage: srvctl unsetenv service -d [-s ] -t “”
Usage: srvctl unsetenv nodeapps -n -t ““