标题: 手工增加一个节点信息 [打印本页] 作者: 郑全 时间: 2019-3-11 09:05 标题: 手工增加一个节点信息 1. Add additional threads of redo and standby redo logs.
Each instance in a RAC database must have it's own thread of redo. Prior to creating the RAC standby and prior to switchover we must create the additional threads of redo.
SQL> alter database
add logfile thread 1
group 1 ('+dgssd') size 200M,
group 2 ('+dgssd') size 200M,
group 3 ('+dgssd') size 200M,
group 4 ('+dgssd') size 200M;
SQL> alter database enable public thread 1;
2. Add an undo tablespace for each instance.
Each instance in a RAC database must have it's own undo tablespace. Using the following syntax to create a undo tablespace for each instance that you will have:
SQL> create undo tablespace undotbs1 datafile
'+dgssd' size 20000m autoextend on;
3. Run catclust.sql
To create RAC specific views in preparation for switchover run the catclust.sql script located in $ORACLE_HOME/rdbms/admin on the primary database:
SQL> @?/rdbms/admin/catclust.sql