Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing options
SQL> create pfile=\\\’/tmp/opfile.txt\\\’ from spfile=\\\’ DATA/oracledb/spfileoracledb.ora\\\’;
File created.
SQL> !vi /tmp/opfile.txt
oracledb1.__db_cache_size=60263759872oracledb1.__java_pool_size=134217728oracledb1.__large_pool_size=134217728oracledb1.__pga_aggregate_target=39728447488oracledb1.__sga_target=68719476736oracledb1.__shared_io_pool_size=0oracledb1.__shared_pool_size=7784628224oracledb1.__streams_pool_size=0*.audit_file_dest=\\\’/u01/app/oracle/admin/oracledb/adump\\\’*.audit_trail=\\\’db\\\’*.cluster_database=true*.compatible=\\\’11.2.0.0.0\\\’*.control_files=\\\’ DATA/oracledb/controlfile/current.260.798857565\\\’*.db_block_size=8192*.db_create_file_dest=\\\’ DATA\\\’*.db_domain=\\\’\\\’*.db_name=\\\’oracledb\\\’*.diagnostic_dest=\\\’/u01/app/oracle\\\’*.dispatchers=\\\'(PROTOCOL=TCP) (SERVICE=oracledbXDB)\\\’oracledb1.instance_number=1oracledb2.instance_number=2*.log_archive_dest_1=\\\’LOCATION= arch\\\’*.log_archive_format=\\\’%t_%s_%r.dbf\\\’*.open_cursors=300*.pga_aggregate_target=39625687040*.processes=5000*.remote_listener=\\\’wstrac.scan.com:1521\\\’*.remote_login_passwordfile=\\\’exclusive\\\’*.sessions=5505*.sga_target=68719476736oracledb1.thread=1oracledb2.thread=2oracledb1.undo_tablespace=\\\’UNDOTBS1\\\’oracledb2.undo_tablespace=\\\’UNDOTBS2\\\’~/tmp/opfile.txt 34L, 1103C written
上面加紅的部分是新增加的內容。
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> create spfile=\\\’ DATA/oracledb/spfileoracledb.ora\\\’ from pfile=\\\’/tmp/opfile.txt\\\’;
File created.SQL> startupORACLE instance started.
Total System Global Area 6.8413E 10 bytesFixed Size 2245480 bytesVariable Size 8053066904 bytesDatabase Buffers 6.0264E 10 bytesRedo Buffers 93609984 bytesDatabase mounted.Database opened.
增加的參數的含義也參考文章：http://space.itpub.net/23135684/viewspace-748572
4.確保創建了UNDOTBS2表空間。
SQL> select file_id,file_name from dba_data_files;
FILE_ID———-FILE_NAME——————————————————————————– 4 DATA/oracledb/datafile/users.259.798857305
3 DATA/oracledb/datafile/undotbs1.258.798857305
2 DATA/oracledb/datafile/sysaux.257.798857305
FILE_ID———-FILE_NAME——————————————————————————– 1 DATA/oracledb/datafile/system.256.798857305
5 DATA/oracledb/datafile/undotbs2.266.798863859
5.再次嘗試啟動rac1上的oracledb2實例。
SQL> startupORACLE instance started.
Total System Global Area 6.8413E 10 bytesFixed Size 2245480 bytesVariable Size 6979325080 bytesDatabase Buffers 6.1338E 10 bytesRedo Buffers 93609984 bytesORA-01618: redo thread 2 is not enabled – cannot mount 需要啟用 redo thread 2。
6.啟用redo thread 2。
以下的操作一定在現存的RAC節點實例上執行（在添加的節點上無法執行），也就是說在rac2節點的oracledb1實例上執行以下命令：
SQL> ALTER DATABASE 2 ADD LOGFILE THREAD 2 GROUP 4 3 (\\\’ DATA\\\’) SIZE 256M;
Database altered.
SQL> ALTER DATABASE 2 ADD LOGFILE THREAD 2 GROUP 5 3 (\\\’ DATA\\\’) SIZE 256M;
Database altered.
SQL> ALTER DATABASE 2 ADD LOGFILE THREAD 2 GROUP 6 3 (\\\’ DATA\\\’) SIZE 256M;
Database altered.
SQL> alter database enable thread 2;
Database altered.
要啟動thread 2，必須先為thread 2創建好日志組。
參考文章：http://space.itpub.net/7199859/viewspace-663572
7.加載rac1 oracledb2實例并打開數據庫。
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
經過以上的步驟，成功為rac1節點添加了oracledb2實例。
8.將實例信息添加到OCR中。
[root@rac1 bin]# su – oracle[oracle@rac1 ~]$ srvctl add instance -d oracledb -i oracledb2 -n rac1[oracle@rac1 ~]$ srvctl status database -d oracledbInstance oracledb2 is not running on node rac1Instance oracledb1 is running on node rac2[oracle@rac1 ~]$ srvctl start instance -d oracledb -i oracledb2[oracle@rac1 ~]$ srvctl status database -d oracledbInstance oracledb2 is running on node rac1Instance oracledb1 is running on node rac2
9.調整OCR中實例運行節點。
經過上面的添加后，rac1運行著oracledb2實例，rac2運行著oracledb1實例，執行下面的步驟，使得rac1運行oracledb1實例，rac2運行oracledb2實例。
[oracle@rac1 ~]$ srvctl stop database -d oracledb[oracle@rac1 ~]$ srvctl remove instance -d oracledb -i oracledb1Remove instance from the database oracledb? (y/[n]) y[oracle@rac1 ~]$ srvctl remove instance -d oracledb -i oracledb2Remove instance from the database oracledb? (y/[n]) y[oracle@rac1 ~]$ srvctl add instance -d oracledb -i oracledb1 -n rac1[oracle@rac1 ~]$ srvctl add instance -d oracledb -i oracledb2 -n rac2[oracle@rac1 ~]$ srvctl start database -d oracledb[oracle@rac1 ~]$ srvctl status database -d oracledbInstance oracledb1 is running on node rac1Instance oracledb2 is running on node rac2[oracle@rac1 ~]$ srvctl enable database -d oracledbPRCC-1010 : oracledb was already enabledPRCR-1002 : Resource ora.oracledb.db is already enabled[oracle@rac1 ~]$ srvctl enable instance -d oracledb -i oracledb1[oracle@rac1 ~]$ srvctl enable instance -d oracledb -i oracledb2
–end–
更多關于云服務器，域名注冊，虛擬主機的問題，請訪問三五互聯官網：m.shinetop.cn