Oracle 11g rac add node

./addNode.sh -pre CLUSTER_NEW_NODES={sde1} CLUSTER_NEW_VIRTUAL_HOSTNAMES={sde1-vip}
cluvfy stage -post nodeadd -n sde1,sde2
./addNode.sh -silent "CLUSTER_NEW_NODES={sde1}"
initsde1.ora
alter system set instance_number=2 scope=spfile sid='sde1';
alter database add logfile thread 1 group 1('+DATA/sde/onlinelog/group_1') size 500M;
alter database add logfile thread 1 group 6('+DATA/sde/onlinelog/group_6') size 500M;
create undo tablespace UNDOTBS1 datafile '+DATA/sde/DATAFILE/UNDOTBS1';
srvctl status database -d sde -v
srvctl add instance -d sde -i sde1 -n sde1
srvctl config database -d sde
srvctl start instance -d sde -i sde1

node1:
568 ls
569 ./addNode.sh -silent "CLUSTER_NEW_NODES={sde1}"
570 sqlplus '/ as sysdba'
571 pwd
572 cd ..
573 ls
574 cd ..
575 ls
576 cd dbs
577 ls
578 cat init.ora
579 pwd
580 id
581 export DISPLAY=135.129.252.39:0.0
582 dbca
583 pwd
584 ls
585 vi initsde1.ora
586 pwd
587 ls
588 ls -lart
589 sqlplus '/ as sysdba'
590 ps -ef |grep ora_
591 echo $ORACLE_SID
592 export ORACLE_SID=sde1
593 sqlplus '/ as sysdba'
594 history
[oracle@sde1 dbs]$

node2:
921 tail -f alertsde2.log
922 vi alertsde2.log
923 exit
924 crsctl status res -t
925 ssh sde1
926 cat /etc/hosts
927 pwd
928 ls
929 cd ..
930 ls
931 cd grid
932 ls
933 cd ..
934 ls
935 cd ..
936 ls
937 cd /u01
938 ls
939 cd app
940 ls -lart
941 cd oracle
942 ls
943 ls -lart
944 pwd
945 ls
946 cat /etc/hosts
947 ssh sde1-priv
948 exit
949 crsctl status res -t
950 cat /etc/hosts
951 crsctl status res -t
952 asmcmd
953 crsctl status res -t
954 srvctl status database -d sde -v
955 srvctl add instance -d sde -i sde1 -n sde1
956 crsctl status res -t
957 srvctl status database -d sde -v
958 srvctl config database -d sde
959 srvctl status database -d sde -v
960 crsctl status res -t
961 srvctl start instance -d sde -i sde1
962 crsctl status res -t
963 history
[grid@sde2 ~]$

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 0 524288000 512 1 YES UNUSED 0 0
3 2 13 536870912 512 2 YES INACTIVE 11835996 17-AUG-15 11855999 17-AUG-15
4 2 14 536870912 512 2 YES INACTIVE 11855999 17-AUG-15 1.4384E+13 20-AUG-15
7 2 15 536870912 512 2 NO CURRENT 1.4384E+13 20-AUG-15 2.8147E+14
8 2 12 536870912 512 2 YES INACTIVE 11813076 17-AUG-15 11835996 17-AUG-15

SQL> alter database add logfile thread 1 group 2('+DATA/sde/onlinelog/group_21') size 500M;

Database altered.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 0 524288000 512 1 YES UNUSED 0 0
2 1 0 524288000 512 1 YES UNUSED 0 0
3 2 13 536870912 512 2 YES INACTIVE 11835996 17-AUG-15 11855999 17-AUG-15
4 2 14 536870912 512 2 YES INACTIVE 11855999 17-AUG-15 1.4384E+13 20-AUG-15
7 2 15 536870912 512 2 NO CURRENT 1.4384E+13 20-AUG-15 2.8147E+14
8 2 12 536870912 512 2 YES INACTIVE 11813076 17-AUG-15 11835996 17-AUG-15

6 rows selected.

SQL> alter database add logfile thread 1 group 3('+DATA/sde/onlinelog/group_3') size 500M;
alter database add logfile thread 1 group 3('+DATA/sde/onlinelog/group_3') size 500M
*
ERROR at line 1:
ORA-01184: logfile group 3 already exists

SQL> alter database add logfile thread 1 group 5('+DATA/sde/onlinelog/group_5') size 500M;

Database altered.

SQL> alter database add logfile thread 1 group 6('+DATA/sde/onlinelog/group_6') size 500M;

Database altered.

SQL> SQL> SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 0 524288000 512 1 YES UNUSED 0 0
2 1 0 524288000 512 1 YES UNUSED 0 0
3 2 13 536870912 512 2 YES INACTIVE 11835996 17-AUG-15 11855999 17-AUG-15
4 2 14 536870912 512 2 YES INACTIVE 11855999 17-AUG-15 1.4384E+13 20-AUG-15
5 1 0 524288000 512 1 YES UNUSED 0 0
6 1 0 524288000 512 1 YES UNUSED 0 0
7 2 15 536870912 512 2 NO CURRENT 1.4384E+13 20-AUG-15 2.8147E+14
8 2 12 536870912 512 2 YES INACTIVE 11813076 17-AUG-15 11835996 17-AUG-15

8 rows selected.

SQL>
SQL>
SQL>
SQL> alter database enable public thread 1;

Database altered.

SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_gc_undo_affinity boolean FALSE
_highthreshold_undoretention integer 50000
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL>
SQL>
SQL> select instance_number,instance_name,status from gv$instance;

INSTANCE_NUMBER INSTANCE_NAME STATUS
--------------- ---------------- ------------
2 sde2 OPEN
1 sde1 OPEN

SQL>
SQL>
SQL>
SQL>

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13750068/viewspace-1777854/，如需轉載，請註明出處，否則將追究法律責任。

Oracle 11g rac add node

相關文章