【RAC】Oracle RAC12c+ srvctl操作命令变化(参数更严谨了)

在 rac运行维护过程中,我们通常按照之前操作系统用于新环境, 近一次对rac19c集群操作时发现,相关参数命令有了很大的变化,rac12c以后更注重参数和操作的安全,命名方式更规范了。 我们已srvctl 命令为参考。

rac 19c

# 集群注册数据库服务为例
[grid@rac19c ~]$ srvctl add database -help
Adds a database configuration to the Oracle Clusterware.
Usage: srvctl add database -db  -oraclehome  [-dbtype {RACONENODE | RAC | SINGLE} [-server ""] [-instance ] [-timeout ]] [-domain ] [-spfile ] [-pwfile ] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption ] [-stopoption ] [-startconcurrency ] [-stopconcurrency ] [-dbname ] [-policy {AUTOMATIC | MANUAL | NORESTART | USERONLY}] [-serverpool "" [-pqpool ]] [-node ] [-diskgroup ""] [-acfspath ""] [-eval] [-fixed] [-css_critical {YES | NO}] [-cpucount ] [-memorytarget ] [-maxmemory ] [-defaultnetnum ] [-verbose]
    -db            Unique name for the database
    -oraclehome              Oracle home path
    -dbtype                  Type of database: RAC One Node, RAC, or Single Instance
    -server ""        Candidate server list for RAC One Node database
    -instance           Instance name prefix for administrator-managed RAC One Node database (default first 12 characters of )
    -timeout              Online relocation timeout in minutes
    -node               Node name (for single-instance databases)
    -domain           Domain for database. Must be set if database has DB_DOMAIN set.
    -spfile                Server parameter file path
    -pwfile    Password file path
    -role                    Role of the database (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, SNAPSHOT_STANDBY, FAR_SYNC)
    -startoption    Startup options for the database. Examples of startup options are OPEN, MOUNT, or "READ ONLY".
    -stopoption      Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -dbname               Database name (DB_NAME), if different from the unique name given by the -db option
    -policy              Management policy for the database (AUTOMATIC, MANUAL, NORESTART or USERONLY)
    -serverpool "" Comma separated list of database server pool names
    -pqpool ""       Comma separated list of parallel query server pool names
    -diskgroup ""  Comma separated list of disk group names
    -acfspath ""   Comma separated list of ACFS paths where database's dependency will be set
    -startconcurrency  Number of instances to be started simultaneously (or 0 for empty start_concurrency value)
    -stopconcurrency  Number of instances to be stopped simultaneously (or 0 for empty stop_concurrency value )
    -eval                          Evaluates the effects of event without making any changes to the system
    -fixed                         Sets the HOSTING_MEMBERS attribute instead of the SERVER_POOLS attribute for a Single-Instance database(SIDB).
    -css_critical {YES | NO}          Define whether the database or service is CSS critical
    -cpucount           Number of workload CPUs
    -memorytarget           Target memory, in MB, used by the resource
    -maxmemory           Maximum memory, in MB, used by the resource
    -defaultnetnum  Default network number for database services
    -verbose                       Verbose output
    -help                          Print usage

rac11g

 ##集群注册数据库服务为例
 [oracle@myasm ~]$ srvctl add database -help
Adds a database configuration to be managed by Oracle Restart.
Usage: srvctl add database -d  -o  [-m ] [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s ] [-t ] [-n ] [-i ] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a ""]
    -d       Unique name for the database
    -o          ORACLE_HOME path
    -m               Domain for database. Must be set if database has DB_DOMAIN set.
    -p               Server parameter file path
    -r                 Role of the database (primary, physical_standby, logical_standby, snapshot_standby)
    -s        Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'.
    -t         Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -n              Database name (DB_NAME), if different from the unique name given by the -d option
    -i            Instance name
    -y             Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)
    -a ""    Comma separated list of disk groups
    -h                       Print usage

通过以上我们可以发现,在19c中,’’-db’’ 后边跟数据库唯一名,11g是’-d’跟数据库唯一名,以此类推,而且19c参数多了很多,权限、资源管理也更加细化。

请使用浏览器的分享功能分享到微信等