在 rac运行维护过程中，我们通常按照之前操作系统用于新环境， 近一次对rac19c集群操作时发现，相关参数命令有了很大的变化，rac12c以后更注重参数和操作的安全，命名方式更规范了。 我们已srvctl 命令为参考。
 
 #### rac 19c
 ``` shell
# 集群注册数据库服务为例
[grid@rac19c ~]$ srvctl add database -help

Adds a database configuration to the Oracle Clusterware.

Usage: srvctl add database -db <db_unique_name> -oraclehome <oracle_home> [-dbtype {RACONENODE | RAC | SINGLE} [-server "<server_list>"] [-instance <inst_name>] [-timeout <timeout>]] [-domain <domain_name>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption <start_options>] [-stopoption <stop_options>] [-startconcurrency <start_concurrency>] [-stopconcurrency <stop_concurrency>] [-dbname <db_name>] [-policy {AUTOMATIC | MANUAL | NORESTART | USERONLY}] [-serverpool "<serverpool_list>" [-pqpool <pq_server_pools>]] [-node <node_name>] [-diskgroup "<diskgroup_list>"] [-acfspath "<acfs_path_list>"] [-eval] [-fixed] [-css_critical {YES | NO}] [-cpucount <cpu_count>] [-memorytarget <memory_target>] [-maxmemory <max_memory>] [-defaultnetnum <network_number>] [-verbose]
    -db <db_unique_name>           Unique name for the database
    -oraclehome <path>             Oracle home path
    -dbtype <type>                 Type of database: RAC One Node, RAC, or Single Instance
    -server "<server_list>"        Candidate server list for RAC One Node database
    -instance <inst_name>          Instance name prefix for administrator-managed RAC One Node database (default first 12 characters of <db_unique_name>)
    -timeout <timeout>             Online relocation timeout in minutes
    -node <node_name>              Node name (for single-instance databases)
    -domain <domain_name>          Domain for database. Must be set if database has DB_DOMAIN set.
    -spfile <spfile>               Server parameter file path
    -pwfile <password_file_path>   Password file path
    -role <role>                   Role of the database (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, SNAPSHOT_STANDBY, FAR_SYNC)
    -startoption <start_options>   Startup options for the database. Examples of startup options are OPEN, MOUNT, or "READ ONLY".
    -stopoption <stop_options>     Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -dbname <db_name>              Database name (DB_NAME), if different from the unique name given by the -db option
    -policy <dbpolicy>             Management policy for the database (AUTOMATIC, MANUAL, NORESTART or USERONLY)
    -serverpool "<serverpool_list>" Comma separated list of database server pool names
    -pqpool "<pq_pool_list>"       Comma separated list of parallel query server pool names
    -diskgroup "<diskgroup_list>"  Comma separated list of disk group names
    -acfspath "<acfs_path_list>"   Comma separated list of ACFS paths where database's dependency will be set
    -startconcurrency <start_concurrency> Number of instances to be started simultaneously (or 0 for empty start_concurrency value)
    -stopconcurrency <stop_concurrency> 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 <cpu_count>          Number of workload CPUs
    -memorytarget <memory_target>          Target memory, in MB, used by the resource
    -maxmemory <max_memory>          Maximum memory, in MB, used by the resource
    -defaultnetnum <network_number> Default network number for database services
    -verbose                       Verbose output
    -help                          Print usage
```

#### rac11g
 ``` shell
 ##集群注册数据库服务为例
 [oracle@myasm ~]$ srvctl add database -help

Adds a database configuration to be managed by Oracle Restart.

Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-i <inst_name>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a "<diskgroup_list>"]
    -d <db_unique_name>      Unique name for the database
    -o <oracle_home>         ORACLE_HOME path
    -m <domain>              Domain for database. Must be set if database has DB_DOMAIN set.
    -p <spfile>              Server parameter file path
    -r <role>                Role of the database (primary, physical_standby, logical_standby, snapshot_standby)
    -s <start_options>       Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'.
    -t <stop_options>        Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -n <db_name>             Database name (DB_NAME), if different from the unique name given by the -d option
    -i <inst_name>           Instance name
    -y <dbpolicy>            Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)
    -a "<diskgroup_list>"    Comma separated list of disk groups
    -h                       Print usage
 ```
 
 通过以上我们可以发现，在19c中，''-db'' 后边跟数据库唯一名，11g是'-d'跟数据库唯一名，以此类推，而且19c参数多了很多，权限、资源管理也更加细化。

ITPub博客

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

最新文章