oracle runc n m,19cRAC增删节点

由于测试环境打19c补丁失败，导致节点2  d2 crs无法启动！打补丁没有有效备份，亲人两行泪

先删再加节点。

一、删除节点

1.1 删除实例

参考

https://www.cnblogs.com/binliubiao/p/11996092.html

Deleting a Cluster Node on Linux and UNIX Systems

https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/

adding-and-deleting-cluster-nodes.html#GUID-8ADA9667-EC27-4EF9-9F34-C8F65A757F2A

删除可以参考上述博客,添加节点建议参考MOS文档

Oracle E-Business Suite Release 12.2: Adding or Deleting 11gR2 or 12c1 Oracle RAC Nodes (Doc ID 1570554.1)

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

测试环境RAC2节点,打补丁2节点安装失败,因此对节点2进行删除后,再添加。

删除实例，1.1都在正常的节点1执行操作

【由于节点2集群crs无法启动,因此删除操作在节点1执行]srvctl stop instance -db db_unique_name -node node_name

srvctl relocate server -servers "server_name_list" -serverpool Free

srvctl config database -db db_unique_name

oracle$

srvctl config database -db orcl

dbca -silent -deleteInstance -nodeList d2 -gdbName orcl -instanceName orcl2 -sysDBAUserName sysdba -sysDBAPassword oracle

--删除实例需要本地实例已启动！

[FATAL] [DBT-11502] The instance (orcl1) is not running on the local node.

CAUSE: A locally running instance is required to perform the selected operation.

ACTION: Specify a locally running database, or execute DBCA on a node where the database instance is running.

$ srvctl start instance -d orcl -instance orcl1

$ dbca -silent -deleteInstance -nodeList d2 -gdbName orcl -instanceName orcl2Prepare for db operation

40% complete

Deleting instance

48% complete

52% complete

56% complete

60% complete

64% complete

68% complete

72% complete

76% complete

80% complete

Completing instance management.

100% complete

$ srvctl stop database -d orcl

本次测试环境3套DB

均为启动存活的节点1实例,进行删除实例操作。

SQL> alter system set enable_ddl_logging=true;

$ dbca -silent -deleteInstance -nodeList d2 -gdbName abc -instanceName abc2--观察DB Alert日志,并没有ddl操作,而是上次了实例2的redo and undo，并且RAC相关参数设置了一下！

2020-04-15T06:57:54.304305+08:00

Deleted Oracle managed file +DATA/ABC/ONLINELOG/group_3.309.1036713505

Deleted Oracle managed file +DATA/ABC/ONLINELOG/group_4.310.1036713537

Deleted Oracle managed file +DATA/ABC/DATAFILE/undotbs2.308.1036712911

2020-04-15T06:57:55.090943+08:00

ALTER SYSTEM RESET undo_tablespace SCOPE=SPFILE SID='abc2';

2020-04-15T06:57:55.098168+08:00

ALTER SYSTEM RESET instance_number SCOPE=SPFILE SID='abc2';

2020-04-15T06:57:55.107884+08:00

ALTER SYS