ITPub博客

首页 > 数据库 > Oracle > srvctl commands

srvctl commands

原创 Oracle 作者:yuanqc 时间:2015-06-26 14:12:06 0 删除 编辑

CRS RESOURCE STATUS

 

srvctl status database -d [-f] [-v] [-S ]

srvctl status instance -d -i >[,]

 [-f] [-v] [-S ]

srvctl status service -d -s [,]

 [-f] [-v] [-S ]

srvctl status nodeapps [-n ]

srvctl status asm -n

 

 

 

EXAMPLES:

Status of the database, all instances and all services.

 srvctl status database -d ORACLE -v

Status of named instances with their current services.

 srvctl status instance -d ORACLE -i RAC01, RAC02 -v

Status of a named services.

srvctl status service -d ORACLE -s ERP -v

Status of all nodes supporting database applications.

srvctl status nodeapps

 

 

 

 

START CRS RESOURCES

 

srvctl start database -d [-o < start-options>]

 [-c | -q]

srvctl start instance -d -i

 [,] [-o ] [-c | -q]

srvctl start service -d [-s [,]]

 [-i ] [-o ] [-c | -q]

srvctl start nodeapps -n

srvctl start asm -n [-i ] [-o ]

 

 

 

EXAMPLES:

Start the database with all enabled instances.

 srvctl start database -d ORACLE

Start named instances.

 srvctl start instance -d ORACLE -i RAC03, RAC04

Start named services. Dependent instances are started as needed.

srvctl start service -d ORACLE -s CRM

Start a service at the named instance.

srvctl start service -d ORACLE -s CRM -i RAC04

Start node applications.

srvctl start nodeapps -n myclust-4

 

 

 

 

 

STOP CRS RESOURCES

 

srvctl stop database -d [-o ]

 [-c | -q]

srvctl stop instance -d -i [,]

 [-o ][-c | -q]

srvctl stop service -d [-s [,]]

 [-i ][-c | -q] [-f]

srvctl stop nodeapps -n

srvctl stop asm -n [-i ] [-o ]

 

 

 

EXAMPLES:

Stop the database, all instances and all services.

 srvctl stop database -d ORACLE

Stop named instances, first relocating all existing services.

 srvctl stop instance -d ORACLE -i RAC03,RAC04

Stop the service.

srvctl stop service -d ORACLE -s CRM

Stop the service at the named instances.

 srvctl stop service -d ORACLE -s CRM -i RAC04

Stop node applications. Note that instances and services also stop.

srvctl stop nodeapps -n myclust-4

 

 

 

 

 

 

ADD CRS RESOURCES

 

srvctl add database -d -o [-m ] [-p ]

 [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}]

 [-s ] [-n ]

srvctl add instance -d -i -n

srvctl add service -d -s -r

 [-a ] [-P ] [-u]

srvctl add nodeapps -n -o

 [-A /netmask[/if1[|if2|...]]]

srvctl add asm -n -i -o

 

OPTIONS:

 

-A vip range, node, and database, address specification. The format of

 address string is:

[]//[/

 host interface2 |..]>] [,] []//

[/]

-a for services, list of available instances, this list cannot include

 preferred instances

-m domain name with the format “us.mydomain.com”

-n node name that will support one or more instances

-o $ORACLE_HOME to locate Oracle binaries

-P for services, TAF preconnect policy - NONE, PRECONNECT

-r for services, list of preferred instances, this list cannot include

 available instances.

-s spfile name

-u updates the preferred or available list for the service to support the

 specified instance. Only one instance may be specified with the -u

 switch. Instances that already support the service should not be

 included.

 

 

 

EXAMPLES:

Add a new node:

srvctl add nodeapps -n myclust-1 -o $ORACLE_HOME –A

 139.184.201.1/255.255.255.0/hme0

Add a new database.

 srvctl add database -d ORACLE -o $ORACLE_HOME

Add named instances to an existing database.

 srvctl add instance -d ORACLE -i RAC01 -n myclust-1

srvctl add instance -d ORACLE -i RAC02 -n myclust-2

srvctl add instance -d ORACLE -i RAC03 -n myclust-3

Add a service to an existing database with preferred instances (-r) and

available instances (-a). Use basic failover to the available instances.

srvctl add service -d ORACLE -s STD_BATCH -r RAC01,RAC02 -a RAC03,RAC04

Add a service to an existing database with preferred instances in list one and

available instances in list two. Use preconnect at the available instances.

srvctl add service -d ORACLE -s STD_BATCH -r RAC01,RAC02 -a RAC03,RAC04 -P PRECONNECT

 

 

 

 

 

REMOVE CRS RESOURCES

 

srvctl remove database -d

srvctl remove instance -d [-i ]

srvctl remove service -d -s [-i ]

srvctl remove nodeapps -n

 

 

 

EXAMPLES:

Remove the applications for a database.

 srvctl remove database -d ORACLE

Remove the applications for named instances of an existing database.

 srvctl remove instance -d ORACLE -i RAC03

 srvctl remove instance -d ORACLE -i RAC04

Remove the service.

srvctl remove service -d ORACLE -s STD_BATCH

Remove the service from the instances.

srvctl remove service -d ORACLE -s STD_BATCH -i RAC03,RAC04

Remove all node applications from a node.

srvctl remove nodeapps -n myclust-4

 

 

 

 

 

MODIFY CRS RESOURCES

 

 

srvctl modify database -d [-n ] [-m ]

 [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}]

 [-s ]

srvctl modify instance -d -i -n

srvctl modify instance -d -i {-s | -r}

srvctl modify service -d -s -i

 -t [-f]

srvctl modify service -d -s -i

 -r [-f]

srvctl modify nodeapps -n [-A ] [-x]

 

OPTIONS:

 

-i -t the instance name (-i) is replaced by the

 instance name (-t)

-i -r the named instance is modified to be a preferred instance

-A address-list for VIP application, at node level

-s add or remove ASM dependency

 

 

 

EXAMPLES:

Modify an instance to execute on another node.

srvctl modify instance -d ORACLE -n myclust-4

Modify a service to execute on another node.

srvctl modify service -d ORACLE -s HOT_BATCH -i RAC01 -t RAC02

Modify an instance to be a preferred instance for a service.

srvctl modify service -d ORACLE -s HOT_BATCH -i RAC02 –r

 

 

 

 

 

RELOCATE SERVICES

 

 

srvctl relocate service -d -s [-i ]-t [-f]

 

 

 

EXAMPLES:

Relocate a service from one instance to another

srvctl relocate service -d ORACLE -s CRM -i RAC04 -t RAC01

 

 

 

ENABLE CRS RESOURCES (The resource may be up or down to use this function)

 

 

srvctl enable database -d

srvctl enable instance -d -i [,]

srvctl enable service -d -s ] [, ] [-i ]

 

 

 

EXAMPLES:

Enable the database.

 srvctl enable database -d ORACLE

Enable the named instances.

 srvctl enable instance -d ORACLE -i RAC01, RAC02

Enable the service.

 srvctl enable service -d ORACLE -s ERP,CRM

Enable the service at the named instance.

srvctl enable service -d ORACLE -s CRM -i RAC03

 

 

 

 

 

DISABLE CRS RESOURCES (The resource must be down to use this function)

 

 

srvctl disable database -d

srvctl disable instance -d -i [,]

srvctl disable service -d -s ] [,] [-i ]

 

 

 

EXAMPLES:

Disable the database globally.

 srvctl disable database -d ORACLE

Disable the named instances.

 srvctl disable instance -d ORACLE -i RAC01, RAC02

Disable the service globally.

 srvctl disable service -d ORACLE -s ERP,CRM

Disable the service at the named instance.

srvctl disable service -d ORACLE -s CRM -i RAC03,RAC04


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10973950/viewspace-1713081/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: crsctl commands
请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    49
  • 访问量
    114267