node-)rmantoRAC(迁移)(七)

cluster_database_instances integer 2

创建节点2的undo 表空间

SYS@anqing1(rac1)> show parameter undo_tablespace

NAME TYPE VALUE

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

undo_tablespace string UNDOTBS1

这个是rac1上节点的信息，我们在之前的在spfile参数指定的rac2节点的undo 空间是UNDOTBS2.

所以这里我们创建该undo 表空间，并指定相关参数。

SYS@dominic(rac1)> create undo tablespace UNDOTBS2 datafile '+DATA/ANQING/datafile/undotbs02.dbf' size 500m;

SQL> create undo tablespace UNDOTBS2 datafile '+DATA_DISK/DOMINIC/datafile/undotbs02.dbf' size 500m;

Tablespace created.

SQL> show parameter undo

NAME TYPE VALUE

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

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBS1

SQL> select name from v$datafile;

NAME

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

+DATA_DISK/dominic/datafile/system.263.850855443

+DATA_DISK/dominic/datafile/sysaux.262.850855443

+DATA_DISK/dominic/datafile/undotbs1.261.850855443

+DATA_DISK/dominic/datafile/users.265.850855443

+DATA_DISK/dominic/datafile/example.264.850855443

+DATA_DISK/dominic/datafile/dominic_tbs.260.850855443

+DATA_DISK/dominic/datafile/undotbs02.dbf

ASMCMD> pwd

+data_disk/dominic/datafile

ASMCMD> ls

DOMINIC_TBS.260.850855443

EXAMPLE.264.850855443

SYSAUX.262.850855443

SYSTEM.263.850855443

UNDOTBS1.261.850855443

UNDOTBS2.269.850858531

USERS.265.850855443

undotbs02.dbf

SQL> SELECT NAME FROM V$TABLESPACE;

NAME

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

SYSTEM

SYSAUX

UNDOTBS1

USERS

TEMP

EXAMPLE

DOMINIC_TBS

UNDOTBS2

添加rac2 节点的redo 文件

SQL> alter database add logfile thread 2 group 4 ('+DATA_DISK','+LOG_DISK') SIZE 50M ;

Database altered.

SQL> alter database add logfile thread 2 group 5('+DATA_DISK','+LOG_DISK') SIZE 50M ;

Database altered.

SQL> alter database add logfile thread 2 group 6('+DATA_DISK','+LOG_DISK') SIZE 50M;

Database altered.

=========================

=================================

SQL> alter database enable thread 2;

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down. ---- 重启节点1和节点2 上的实例，使相关参数生效

=====(一下在节点2 上）

查看节点二 参数，增加参数 export ORACLE_UNQNAME=dominic

[oracle@dominic2 ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_SID=dominic2

export ORACLE_UNQNAME=dominic

export ORACLE_BASE=/dba/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

export LANG=C

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

umask 022

[oracle@dominic2 ~]$ sqlplus / as sysdba --启动节点2

SQL*Plus: Release 11