手工增加一个节点信息

郑全

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