在 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参数多了很多,权限、资源管理也更加细化。