Database - 70. page

提供给公司开发人员的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 ““

autorestart 参数

在aix 5系列版本中有一个参数可以帮你在突然断电或者意外关机的情况下自动重启，这个参数就是autorestart

通过执行 lsattr -D -l sys0
可以看到该参数的默认值，在aix中这个参数的默认为false
例如：
# lsattr -D -l sys0 | grep auto
autorestart true Automatically REBOOT system after a crash Flase

通过chdev命令可以修改
# chdev -l sys0 -a autorestart=true
sys0 changed

再执行 lsattr -El sys0 | grep auto 可以看到更改后的值

# lsattr -El sys0 | grep auto
autorestart true Automatically REBOOT system after a crash True

ps：

可能你会疑问 那reboot后是调用fastboot启动呢还是这个参数起作用，其实这个不用担心，reboot操作依然是调用fastboot来启动系统的