单实例和RAC打造的ORACLE STREAM（一）

主节点：
rx8640服务器
HPUX 11.23操作系统
IP地址128.199.38.32
数据库：ORACLE 10.2.0.1
ORACLE_SID：ora
Global_name：ora
 
副节点一(ORACLE RAC)：
rx8640服务器
HPUX 11.23操作系统
IP地址128.199.38.27
数据库：ORACLE 10.2.0.1
ORACLE_SID：storm1
Global_name：storm1

 

副节点二(ORACLE RAC)：
rx8640服务器
HPUX 11.23操作系统
IP地址128.199.38.28
数据库：ORACLE 10.2.0.1
ORACLE_SID：storm2
Global_name：storm2

 

ORACLE RAC全貌：

 

根据前面的介绍，此次STREAM实验以单节点数据库(sid为ora)和ORACLE RAC(sid分别为storm1和storm2)构建而成，前者为主库，后者为备库。要达到的目的是基于table级的流 (stream)复制，也就是在主库ora上面进行的操作能瞬时间同步到ORACLE RAC。下面进行具体操作过程。

 

第一步，修改主库和备库的参数文件：
主库ora：
SQL> alter system set aq_tm_processes=2 scope=both;
SQL> alter system set global_names=true scope=both;
SQL> alter system set job_queue_processes=10 scope=both;
SQL> alter system set parallel_max_servers=20 scope=both;
SQL> alter system set undo_retention=3600 scope=both;
SQL> alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile;
SQL> alter system set streams_pool_size=25M scope=spfile;
SQL> alter system set utl_file_dir='*' scope=spfile;
SQL> alter system set open_links=4 scope=spfile;

 

重启数据库。

 

备库storm1：
SQL> create pfile='/arch/pfilestorm.ora' from spfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

vi /arch/pfilestorm.ora
*.aq_tm_processes=2
*.global_names=true
*.job_queue_processes=10
*.parallel_max_servers=20
*.undo_retention=3600
*.nls_date_format='YYYY-MM-DD HH24:MI:SS'
*.streams_pool_size=25M
*.utl_file_dir='*'
*.open_links=4

 

SQL> startup pfile='/arch/pfilestorm.ora';
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1995664 bytes
Variable Size             184552560 bytes
Database Buffers          423624704 bytes
Redo Buffers                2195456 bytes
Database mounted.
Database opened.

 

SQL> create spfile from pfile='/arch/pfilestorm.ora';

File created.

 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

SQL> startup
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1995664 bytes
Variable Size             184552560 bytes
Database Buffers          423624704 bytes
Redo Buffers                2195456 bytes
Database mounted.
Database opened.

 

查看参数修改是否生效：
SQL> show parameter open_links

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     4
open_links_per_instance              integer     4

 

备库storm2：
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1995664 bytes
Variable Size             226495600 bytes
Database Buffers          381681664 bytes
Redo Buffers                2195456 bytes
Database mounted.
Database opened.

 

查看参数修改是否生效：
SQL> show parameter open_links

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_links                           integer     4
open_links_per_instance              integer     4

 

下面要开始讲主库和备库调整为归档模式。