Oracle Rac -- rac 命令

srvctl 命令

add Add a database or instance

config List the configuration for the database or instance

getenv List the environment variables in the SRVM configuration

modify Modify the instance configuration

remove Remove the database or instance

setenv Set the environment variable in the SRVM configuration

start Start the database or instance

status Status of the database or instance

stop Stop the database or instance

unsetenv Set the environment variable in the SRVM configuration to unspecified

database (db) Operation refers to objects for the database

instance (inst) Operation refers to objects for the instances

-h Help

-i instance

-n node

-f force

-d Database name

-h Print usage

-i Comma-separated list of instance names for the operation

-n Node name or comma separated node list

srvctl add database -d database_name [-m domain_name] -o oracle_home [-s spfile]
srvctl add instance -d database_name -i instance_name -n node_name

To add a new database:

srvctl add database -d mydb -o /ora/ora9 注册实例

To add named instances to a database:

srvctl add instance -d mydb -i mydb01 -n gm01
srvctl add instance -d mydb -i mydb02 -n gm02
srvctl add instance -d mydb -i mydb03 -n gm03

Displays a list of configured databases.

srvctl config database -d database_name 查看数据库配置信息

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 mydb 查看环境变量

srvctl modify instance -d database_name -i instance_name -n node_name

srvctl modify instance -d mydb -n my_new_node

srvctl remove database -d database_name [-f]
srvctl remove instance -d database_name -i instance_name [-f]

srvctl remove database -d mydb 移除实例

srvctl remove instance -d mydb -i mydb01
srvctl remove instance -d mydb -i mydb02
srvctl remove instance -d mydb -i mydb03

srvctl setenv database -d database_name -t name=value [,name=value,...]
srvctl setenv instance -d database_name [-i instance_name] -t name=value
[,name=value,...]

srvctl setenv database -d mydb -t LANG=en

srvctl start database -d database_name [-o start_options] [-c connect_string]
srvctl start instance -d database_name -i instance_name [,instance_name-list]
[-o start_options] [-c connect_string]

To start the database and all enabled instances: 启动实例

srvctl start database -d mydb

To start instances:

srvctl start instance -d mydb -i mydb1,mydb4

srvctl status database -d database_name 数据库状态
srvctl status instance -d database_name -i instance_name [,instance_name-list]

Status of the database and all instances:

srvctl status database -d mydb

Status of named instances:

srvctl status instance -d mydb -i mydb1,mydb2

srvctl stop database -d database_name [-o stop_options] [-c connect_string]
srvctl stop instance -d database_name -i instance_name [,instance_name_list] [-o
stop_options][-c connect_string]

Stop the database all instances:

srvctl stop database -d mydb

Stop named instances:

srvctl stop instance -d mydb -i mydb1

9i RAC 安装