Oracle 11g 单实例到单实例OGG同步操作文档-RMAN 初始化

1.环境介绍
类别 源端 目标端
数据库类型 单实例 单实例
数据库版本 11.2.0.4 11.2.0.4
Oracle_SID cndba cndba
DB_NAME cndba cndba
主机IP地址 192.168.1.85 192.168.1.86
OS版本 RedHat 6.7 RedHat 6.7
OGG版本 11.2.1.0.1 64位 11.2.1.0.1 64位
ASP站长网主机名 cndba cndba
2.安装前的准备工作
2.1.源端创建GoldenGate用户表空间
create tablespace ogg_data datafile '/u01/app/oracle/oradata/cndba/ogg01.dbf' size 100m autoextend off;
2.2.源端创建GoldenGate用户
create user ogg identified by ogg default tablespace ogg_data;
grant connect,resource,dba,create table,create sequence to ogg;
2.3.目标端创建GoldenGate用户表空间
create tablespace ogg_data datafile '/u01/app/oracle/oradata/cndba/ogg01.dbf' size 100m autoextend off;
2.4.目标端创建GoldenGate用户表空间
create user ogg identified by ogg default tablespace ogg_data;
grant connect,resource,dba,create table,create sequence to ogg;
2.5.源端创建测试用户及测试数据
SQL> create user test identified by test;
 
User created.
 
SQL> grant connect,resource to test;
 
Grant succeeded.
 
SQL> conn test/test                   
Connected.
SQL> create table test (id number(10) primary key ,name varchar(8));
 
Table created.
SQL> insert into test values(1,'zhangsan');
 
1 row created.
SQL> insert into test values(2,'lisi');
 
1 row created.
 
SQL> commit;
2.6.目标端创建测试用户及测试数据
SQL> create user test identified by test;
 
User created.
 
SQL> grant connect,resource to test;
 
Grant succeeded.
 
SQL> conn test/test                   
Connected.
SQL> create table test (id number(10) primary key ,name varchar(8));
 
Table created.
目标端不需要插入数据
2.7.源端开启归档模式、强制日志、附加日志
2.7.1.查看是否开启归档模式、强制日志、附加日志
SQL> select LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from v$database;
 
LOG_MODE     SUPPLEME FOR
------------ -------- ---
NOARCHIVELOG NO       NO
2.7.2.开启归档
[root@www.cndba.cn cndba]# mkdir -p /u01/archive
[root@www.cndba.cn cndba]# chown -R oracle:oinstall /u01/archive/
SQL> archive log list
Database log mode       No Archive Mode
Automatic archival       Disabled
Archive destination       /u01/app/oracle/product/11.2.0/db_1/dbs/arch
Oldest online log sequence     5
Current log sequence       7
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
 
Total System Global Area 1060585472 bytes
Fixed Size    2260000 bytes
Variable Size  905970656 bytes
Database Buffers  146800640 bytes
Redo Buffers    5554176 bytes
Database mounted.
SQL> alter database archivelog;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> alter system set log_archive_dest_1='location=/u01/archive';
 
System altered.
 
SQL> archive log liset
SP2-0718: illegal ARCHIVE LOG option
SQL> archive log list
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination       /u01/archive
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence       7
2.7.3.开启强制日志
SQL> alter database force logging;
Database altered.
2.7.4.开启附加日志
SQL> alter database add supplemental log data;
 
Database altered.
2.7.5.查看是否开启归档模式、强制日志、附加日志
SQL> select LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from v$database;
 
LOG_MODE     SUPPLEME FOR
------------        --------    ---
ARCHIVELOG     YES      YES
2.7.6.查看回收站是否关闭
SQL> show parameter recycle
 
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle     string
db_recycle_cache_size     big integer 0
recyclebin     string on
SQL> alter system set recyclebin=off scope=spfile;
 
System altered.
--重启数据库查看
SQL> show parameter recycle
 
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle     string
db_recycle_cache_size     big integer 0
recyclebin     string OFF