DBLOG
» WTF
Toggle navigation
DBLOG
主页
1、用户
2、各种方案
3、备份恢复
4、表空间相关
5、OGG
6、文件管理
7、常见故障分析
8、DG
9、集群相关
About Me
归档
标签
4、向grid添加集群资源
无
2025-08-29 00:10:08
3
0
0
admin
###向grid添加集群资源 ``` srvctl add database -d slyystd -o /u01/app/oracle/product/19.3.0/db -n slyy -p '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilejgdb1.ora' -s open -t immediate -y AUTOMATIC 选项列表: -d <db_unique_name> Unique name for the database -o <oracle_home> ORACLE_HOME path -c <type> Type of database: RAC One Node, RAC, or Single Instance -e <server_list> Candidate server list for RAC One Node database -i <inst_name> Instance name prefix for administrator-managed RAC One Node database -w <timeout> Online relocation timeout in minutes -x <node_name> Node name. -x option is specified for single-instance databases -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 -y <dbpolicy> Management policy for the database (AUTOMATIC, MANUAL, or NORESTART) -g "<serverpool_list>" Comma separated list of database server pool names -a "<diskgroup_list>" Comma separated list of disk groups -j "<acfs_path_list>" Comma separated list of ACFS paths where database's dependency will be set -h Print usage 添加实例 srvctl add instance -d slyydg -i slyy1 -n dm01dbadm01 srvctl add instance -d slyydg -i slyy2 -n dm01dbadm02 查看资源并启动数据库 srvctl config database -d slyydg srvctl start database -d slyydg ``` ``` srvctl add database -d jgdb -o /u01/app/oracle/product/11.2.0/dbhome_1 -n jgdb -p '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilejgdb1.ora' -s open -t immediate -y AUTOMATIC srvctl add database -d jgdb -o /u01/app/oracle/product/11.2.0/dbhome_1 -n jgdb -p '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilejgdb2.ora' -s open -t immediate -y AUTOMATIC srvctl add instance -d jgdb -i jgdb1 -n jg-dbserv01 srvctl add instance -d jgdb -i jgdb2 -n jg-dbserv02 ```
上一篇:
4、undo tablespace管理
下一篇:
4、缩表、去重、杀会话
0
赞
3 人读过
新浪微博
微信
腾讯微博
QQ空间
人人网