在 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引數多了很多，許可權、資源管理也更加細化。</diskgroup_list></dbpolicy></inst_name></db_name></stop_options></start_options></role></spfile></domain></oracle_home></db_unique_name></diskgroup_list></inst_name></db_name></stop_options></start_options></spfile></domain_name></oracle_home></db_unique_name></network_number></max_memory></memory_target></cpu_count></stop_concurrency></start_concurrency></acfs_path_list></diskgroup_list></pq_pool_list></serverpool_list></dbpolicy></db_name></stop_options></start_options></role></password_file_path></spfile></domain_name></node_name></timeout></db_unique_name></inst_name></server_list></type></path></db_unique_name></network_number></max_memory></memory_target></cpu_count></acfs_path_list></diskgroup_list></node_name></pq_server_pools></serverpool_list></db_name></stop_concurrency></start_concurrency></stop_options></start_options></password_file_path></spfile></domain_name></timeout></inst_name></server_list></oracle_home></db_unique_name>

【RAC】Oracle RAC12c+ srvctl操作命令變化(引數更嚴謹了）

相關文章