环境准备

1 设定初始化参数

使用pfile的修改init.ora文件，使用spfile的通过alter system命令修改spile文件。主、从数据库分别执行如下的语句：

以下是引用片段：

Sqlplus / as sysdba

alter system set aq_tm_processes=2 scope=both;

alter system set global_names=true scope=both;

alter system set job_queue_processes=10 scope=both;

alter system set parallel_max_servers=20 scope=both;

alter system set undo_retention=3600 scope=both;

alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile;

alter system set streams_pool_size=25M scope=spfile;

alter system set utl_file_dir='*' scope=spfile;

alter system set open_links=4 scope=spfile;

2 将数据库置为归档模式

主数据库：

SQL> alter system set log_archive_dest_1='LOCATION=/arch' scope=both;

SQL> alter system set log_archive_format='cow_%t_%s_%r.arc' scope=spfile;

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

验证是否归档：

SQL> archive log list;

从数据库:

SQL> alter system set log_archive_format='demodb_%t_%s_%r.arc' scope=spfile;

SQL> alter system set log_archive_dest_1='LOCATION=/arch';

SQL> shutdown immediate;

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open;

验证是否归档：

SQL> archive log list;

ITPub博客

Oracle Stream实战(2)—测试环境准备（一）