oracle presentation = ro,Oracle DataBase单实例迁移到Oracle RAC

5. 创建thread 2的日志和另一个节点的undo表空间

[Oracle@rac1 dbs]$ export ORACLE_SID=orcl1

[oracle@rac1 dbs]$ sqlplus / as sysdba

查看节点1的日志，创建指定的目录：

SQL> set linesize 180

SQL> col member format a50

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- -------------------------------------------------- ---

3 ONLINE /u01/app/oracle/oradata/orcl/redo03.log NO

2 ONLINE /u01/app/oracle/oradata/orcl/redo02.log NO

1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log NO

SQL> host mkdir -p /u01/app/oracle/oradata/orcl/

创建日志组和UNDO表空间，用于实例2的使用:

alter database add logfile thread 2

group 5 size 100M,

group 6 size 100M,

group 7 size 100M;

SQL> alter database add logfile thread 2

2 group 5 size 100M,

3 group 6 size 100M,

4 group 7 size 100M;

Database altered.

SQL> alter database open resetlogs;

Database altered.

SQL> alter database enable public thread 2;

Database altered.

SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATA';

Tablespace created.

SQL>

6. 将在文件系统存放的日志，迁移到+ASM

alter database add logfile thread 1

group 8 size 100M,

group 9 size 100M;

alter database drop logfile group 2;

alter database drop logfile group 3;

alter system switch logfile;

alter system checkpoint;

alter database drop logfile group 1;

alter database add logfile group 1 size 100m, group 2 size 100m, group 3 size 100m;

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- -------------------------------------------------- ---

1 ONLINE +DATA/orcl/onlinelog/group_1.412.799341123 NO

1 ONLINE +FRA/orcl/onlinelog/group_1.265.799341129 YES

2 ONLINE +DATA/orcl/onlinelog/group_2.408.799341137 NO

5 ONLINE +DATA/orcl/onlinelog/group_5.363.799340635 NO

5 ONLINE +FRA/orcl/onlinelog/group_5.290.799340641 YES

6 ONLINE +DATA/orcl/onlinelog/group_6.386.799340649 NO

6 ONLINE +FRA/orcl/onlinelog/group_6.291.799340655 YES

7 ONLINE +DATA/orcl/onlinelog/group_7.389.799340661 NO

7 ONLINE +FRA/orcl/onlinelog/group_7.275.799340667 YES

8 ONLINE +DATA/orcl/onlinelog/group_8.400.799341055 NO

8 ONLINE +FRA/orcl/onlinelog/group_8.264.799341061 YES

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- -------------------------------------------------- ---

9 ONLINE +DATA/orcl/onlinelog/group_9.413.799341067 NO

9 ONLINE +FRA/orcl/onlinelog/group_9.292.799341073 YES

2 ONLINE +FRA/orcl/onlinelog/group_2.286.799341147 YES

3 ONLINE +DATA/orcl/onlinelog/group_3.394.799341153 NO

3 ONLINE +FRA/orcl/onlinelog/group_3.287.799341161 YES

16 rows selected.

SQL>

7. 创建cluster database的视图

create cluster database specific views within the existing instance

SQL> @$ORACLE_HOME/rdbms/admin/catclust.sql

8. 迁移临时文件

SQL> alter tablespace temp add tempfile '+DATA';

SQL> alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' drop;

########################################################################

9. crs环境信息建立

在节点1操作：

[oracle@rac1 dbs]$ export ORACLE_SID=orcl1

[oracle@rac1 dbs]$ sqlplus / as sysdba

SQL> shutdown immediate

SQL> create pfile from spfile;

SQL> create spfile='+DATA/orcl/spfileorcl.ora' from pfile;

SQL> exit

[oracle@rac1 dbs]$ cd /u01/app/oracle/oracle/product/10.2.0/db_1/dbs

[oracle@rac1 dbs]$ rm spfileorcl1.ora

[oracle@rac1 dbs]$ echo "spfile='+DATA/orcl/spfileorcl.ora'" > initorcl1.ora

在节点2操作:

[oracle@rac2 dbs]$ cd /u01/app/oracle/oracle/product/10.2.0/db_1/dbs

[oracle@rac2 dbs]$ rm spfileorcl2.ora

rm: cannot remove `spfileorcl2.ora': No such file or directory

[oracle@rac2 dbs]$ echo "spfile='+DATA/orcl/spfileorcl.ora'" > initorcl2.ora

[oracle@rac2 dbs]$

10. 配置并启动RAC数据库

[oracle@rac1 dbs]$ srvctl add database -d orcl -o /u01/app/oracle/oracle/product/10.2.0/db_1

[oracle@rac1 dbs]$ srvctl add instance -d orcl -i orcl1 -n rac1

[oracle@rac1 dbs]$ srvctl add instance -d orcl -i orcl2 -n rac2

[oracle@rac1 dbs]$ srvctl modify instance -d orcl -i orcl1 -s +ASM1

[oracle@rac1 dbs]$ srvctl modify instance -d orcl -i orcl2 -s +ASM2

[oracle@rac1 dbs]$ srvctl start database -d orcl

[oracle@rac1 dbs]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.orcl.db application ONLINE ONLINE rac2

ora....l1.inst application ONLINE ONLINE rac1

ora....l2.inst application ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

ora....b.AP.cs application OFFLINE OFFLINE

ora....db1.srv application OFFLINE OFFLINE

ora....b.GL.cs application OFFLINE OFFLINE

ora....db2.srv application OFFLINE OFFLINE

ora.racdb.db application OFFLINE OFFLINE

ora....b1.inst application OFFLINE OFFLINE

ora....b2.inst application OFFLINE OFFLINE

[oracle@rac1 dbs]$

##############################################

11. tnsnames.ora 网络配置文件

在两个节点的tnsnames.ora文件中操作

[oracle@rac1 dbs]$ cd $ORACLE_HOME/network/admin

[oracle@rac1 admin]$ vi tnsnames.ora

添加：

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

ORCL1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

(INSTANCE_NAME = orcl1)

)

)

ORCL2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

(INSTANCE_NAME = orcl2)

)

)

LISTENERS_ORCL =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

12. 验证

[oracle@rac1 admin]$ sqlplus system/oracle@orcl

SQL> col inst_name format a50

SQL> select * from v$active_instances;

INST_NUMBER INST_NAME

----------- --------------------------------------------------

1 rac1.localdomain:orcl1

2 rac2.localdomain:orcl2

SQL> col host_name format a20

SQL> select instance_name, host_name, archiver, thread#, status from gv$instance;

INSTANCE_NAME HOST_NAME ARCHIVE THREAD# STATUS

---------------- -------------------- ------- ---------- ------------

orcl1 rac1.localdomain STARTED 1 OPEN

orcl2 rac2.localdomain STARTED 2 OPEN

SQL>