第1页 / 共8页
第2页 / 共8页
第3页 / 共8页
第4页 / 共8页
第5页 / 共8页
第6页 / 共8页
第7页 / 共8页
第8页 / 共8页
【OGG】10G 在线迁移 11G Rac.pdf
【OGG】10G 在线迁移 11G Rac
2020年4月15日
9:12
1、首先所需环境如下
项目
db 类型
db version
db 存储
ORACLE_SID
db_name
源库
10g单库
10.2.0.5
FileSystem
ora10g
ora10g
target db
rac
11.2.0.4
ASM
pro1/pro2
pro
主机IP地址：
10.6.11.9
10.6.11.11/10.6.11.12
OS版本及kernel版
OracleLinux5.11 64位，Linux
RHEL6.9 64
本
ora10g
位，2.6.32-642.el6.x86_64
2.6.39-400.215.10.el5uek
OGG版本
11.2 64位
12.2 64位
主库配置默认监听
netca
4、rac节点配置TNS
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
RAC =
(DESCRIPTION =
[root@rac2 ~]# su - oracle
[oracle@racdb2 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac -scan)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac -scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
ASM =
(DESCRIPTION =
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)
ASM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.11.11)(PORT = 1521))
(CONNECT_DATA =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.11.12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(SID_NAME = +ASM1)
)
)
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(SID_NAME = +ASM2)
)
)
测试连通性
[oracle@rac1 admin]$ sqlplus system/oracle@rac
测试连通性
[oracle@rac2 admin]$ sqlplus system/oracle@rac
SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 4 12:43:40 2019
SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 4 12:43:40 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL>
[oracle@rac1 admin]$ sqlplus sys/oracle@asm as sysdba
[oracle@rac2 admin]$ sqlplus sys/oracle@asm as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 4 12:44:41 2019
SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 4 12:44:41 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> sho parameter name
SQL> sho parameter name
TYPE
NAME
------------------------------------ ---------------------------------
VALUE
------------------------------
db_unique_name
+ASM
instance_name
+ASM1
lock_name_space
string
string
string
TYPE
NAME
------------------------------------ ---------------------------------
VALUE
------------------------------
db_unique_name
+ASM
instance_name
+ASM2
lock_name_space
string
string
string
service_names
+ASM
SQL>
string
service_names
+ASM
SQL>
string
分区 实施手册 的第 1 页
Aluphamii
2、主库配置OGG安装目录并配置环境变量
mkdir /oracle/app/ggs
添加环境变量
export PATH=/oracle/app/ggs:$PATH
export LD_LIBRARY_PATH=/oracle/app/ggs:$LD_LIBRARY_PATH
2、备库配置ACFS文件系统为OGG软件目录并配置环境变量
asmca
分区 实施手册 的第 2 页
Aluphamii
分区 实施手册 的第 3 页
Aluphamii
添加环境变量
export PATH=/ogg/ggs:$PATH
export LD_LIBRARY_PATH=/ogg/ggs:$LD_LIBRARY_PATH
3、主库OGG安装
tar xvfp fbo_ggs_Linux_x64_ora10g_64bit.tar
[oracle@ora10g ggs]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 10g on Oct 4 2011 23:50:20
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10g) 1> exit
3、备库OGG安装
unzip 122022_fbo_ggs_Linux_x64_shiphome.zip
cd cd fbo_ggs_Linux_x64_shiphome/Disk1
./runInstaller
分区 实施手册 的第 4 页
Aluphamii
[oracle@rac1 ~]$ cd /ogg/ggs/
[oracle@rac1 ggs]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF -8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac1) 1>
[oracle@rac2 ~]$ cd /ogg/ggs/
[oracle@rac2 ggs]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF -8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac2) 1>
源库调整
备库调整
开启归档
shutdown immediate;
startup mount;
alter system set log_archive_dest_1='location=/oracle/archlog/ora10g'
scope=both;
alter database archivelog;
alter database open;
alter database force logging;
alter force_logging from v$database;
开启归档
srvctl stop db -d pro
srvctl start instance -i pro1 -d pro -o mount;
sqlplus / as sysdba
alter system set log_archive_dest_1='location=+DG_DATA' scope=both;
alter database archivelog;
alter database open;
alter database force logging;
alter force_logging from v$database;
开启强制log
select force_logging from v$database;
开启强制log
select force_logging from v$database;
FORCE_LOG
---------
YES
FORCE_LOG
---------
YES
查看最小附加日志
select supplemental_log_data_min from v$database;
查看最小附加日志
select supplemental_log_data_min from v$database;
SUPPLEMENTAL_LOG_DATA_MI
------------------------
NO
开启最小附加日志
alter database add supplemental log data;
alter database add supplemental log data (primary key) columns;
alter database add supplemental log data (foreign key) columns;
alter database add supplemental log data (unique) columns
切日志生效
alter system switch logfile;
select supplemental_log_data_min from v$database;
SUPPLEMENTAL_LOG_DATA_MI
------------------------
NO
开启最小附加日志
alter database add supplemental log data;
alter database
alter database
alter database
add supplemental log data (primary key) columns;
add supplemental log data (foreign key) columns;
add supplemental log data (unique) columns
切日志生效
alter system switch logfile;
select supplemental_log_data_min from v$database;
SUPPLEMENTAL_LOG_DATA_MI
------------------------
YES
备注： 在oracle中可以通过rowid来定位某条记录，但是目标端的数据库和源端数据库的数据库可能完全不一样，所
以无法通过rowid来确定源端数据库的逻辑变化，这时附加日志supplemental log便登上了表演的舞台。数据库在开启附
加日志功能后，对于源端的修改操作，oracle会同时追加能够唯一标示记录的列到redo log。这样目标端数据库就可以
知道源端发生了哪些具体的变化。
关闭回收站
show parameter recyclebin
NAME
TYPE VALUE
SUPPLEMENTAL_LOG_DATA_MI
------------------------
YES
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE scope=both sid='*';
备注： 在oracle中可以通过rowid来定位某条记录，但是目标端的数据库和源端数据库的数据库可能完全不一样，所
以无法通过rowid来确定源端数据库的逻辑变化，这时附加日志supplemental log便登上了表演的舞台。数据库在开启
附加日志功能后，对于源端的修改操作，oracle会同时追加能够唯一标示记录的列到redo log。这样目标端数据库就可
以知道源端发生了哪些具体的变化。
关闭回收站
show parameter recyclebin
分区 实施手册 的第 5 页
Aluphamii
备注： 在oracle中可以通过rowid来定位某条记录，但是目标端的数据库和源端数据库的数据库可能完全不一样，所
以无法通过rowid来确定源端数据库的逻辑变化，这时附加日志supplemental log便登上了表演的舞台。数据库在开启附
加日志功能后，对于源端的修改操作，oracle会同时追加能够唯一标示记录的列到redo log。这样目标端数据库就可以
知道源端发生了哪些具体的变化。
关闭回收站
show parameter recyclebin
TYPE VALUE
NAME
---------- ------- -------
recyclebin string on
alter system set recyclebin=off;
建立ggate管理用户
create tablespace ggate datafile'/oracle/oradata/ora10g/ggate01.dbf' size
500M autoextend on;
create user ggate identified by ggate default tablespace ggate temporary
tablespace temp;
grant connect ,resource,unlimited tablespace to ggate;
grant alter any table to ggate;
grant alter session to ggate;
grant create session to ggate;
grant flashback any table to ggate;
grant select any dictionary,select any table to ggate;
grant execute on utl_file to ggate; /***开启ddl时才需要此参数*****/
grant execute on dbms_flashback to ggate;
如需复制DDL，则两端均需要sysdba权限。
grant sysdba to ggate;
@sequence.sql
@marker_setup.sql
@ddl_setup.sql
@role_setup.sql
grant ggs_ggsuser_role to ggate;
@ddl_enable.sql
@?/rdbms/admin/dbmspool.sql
@ddl_pin ggate
主库建立测试用户test，并且建立测试表，插入若干数据。
create user test identified by test;
grant dba to test;
create table t1(shijian date);
insert into t1 values(sysdate);
alter table t1 add primary key (shijian);
SQL> select * from t1;
SHIJIAN
-------------------
2020-04-16 21:25:03
2020-04-16 21:26:31
2020-04-16 21:26:32
2020-04-16 21:26:34
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE scope=both sid='*';
备注： 在oracle中可以通过rowid来定位某条记录，但是目标端的数据库和源端数据库的数据库可能完全不一样，所
以无法通过rowid来确定源端数据库的逻辑变化，这时附加日志supplemental log便登上了表演的舞台。数据库在开启
附加日志功能后，对于源端的修改操作，oracle会同时追加能够唯一标示记录的列到redo log。这样目标端数据库就可
以知道源端发生了哪些具体的变化。
关闭回收站
show parameter recyclebin
TYPE VALUE
NAME
---------- ------- -------
recyclebin string on
alter system set recyclebin=off deferred;
建立ggate管理用户
create tablespace ggate datafile'+DG_DATA' size 500M autoextend on;
create user ggate identified by ggate default tablespace ggate temporary
tablespace temp;
grant connect ,resource,unlimited tablespace to ggate;
grant alter any table to ggate;
grant alter session to ggate;
grant create session to ggate;
grant flashback any table to ggate;
grant select any dictionary,select any table to ggate;
grant execute on utl_file to ggate; /***开启ddl时才需要此参数*****/
grant execute on dbms_flashback to ggate;
如需复制DDL，则两端均需要sysdba权限。
grant sysdba to ggate;
alter system set enable_goldengate_replication= TRUE scope=both;
@sequence.sql
@marker_setup.sql
@ddl_setup.sql
@role_setup.sql
grant ggs_ggsuser_role to ggate;
@ddl_enable.sql
@?/rdbms/admin/dbmspool.sql
@ddl_pin ggate
主库配置配置trandata
touch GLOBALS
GGSCI (ora10g) 1> view params ./GLOBALS
GGSCHEMA GGATE
GGSCI (ora10g) 1> dblogin userid ggate,password ggate
Successfully logged into database.
GGSCI (ora10g) 2> add trandata test.*
Logging of supplemental redo data enabled for table TEST.T1.
备注：表名可以使用通配符，如add trandata gss.*
这里schema_name和table_name是goldengate要同步的所有表，也就是说针对每一张表，都要做一遍，当然你可以采用
add trandata .*,或者采用sqlplus中的select from dba_tables 批量生成脚本。
这一步非常关键，如果漏掉，同步时insert，delete可能会没问题，但update肯定报错。
备库配置checkpoint表
touch GLOBALS
GGSCI (rac1) 1> view params ./GLOBALS
ggschema GGATE
checkpointtable ggate.checkpoint
GGSCI (rac1) 2> dblogin userid ggate,password ggate
Successfully logged into database.
GGSCI (rac1 as ggate@pro1) 3> add checkpointtable ggate.checkpoint
Successfully created checkpoint table ggate.checkpoint.
备注：在target端配置replicat进程之前，通常需要在目标端的数据库中创建一个checkpoint表，这个表是基于ogg
checkpoint文件的，它记录了所有ogg可恢复的checkpoint以及sequence，这个操作不是必须的，但oracle强烈建议使
用它，因为它可以使得checkpoint包含在replicat的事务中，保证了可以从各类失败场景中恢复！
1、主库配置mgr
新建必要目录
mkdir /oracle/app/ggs/dirrpt
mkdir /oracle/app/ggs/dirprm
mkdir /oracle/app/ggs/dirout
mkdir /oracle/app/ggs/dirchk
mkdir /oracle/app/ggs/dirpcs
mkdir /oracle/app/ggs/dirsql
mkdir /oracle/app/ggs/dirdef
mkdir /oracle/app/ggs/dirtmp
mkdir /oracle/app/ggs/dirdat
[oracle@ora10g ggs]$ ggsci
1、备库配置mgr
新建必要目录
mkdir /ogg/ggs/dirrpt
mkdir /ogg/ggs/dirprm
mkdir /ogg/ggs/dirout
mkdir /ogg/ggs/dirchk
mkdir /ogg/ggs/dirpcs
mkdir /ogg/ggs/dirsql
mkdir /ogg/ggs/dirdef
mkdir /ogg/ggs/dirtmp
mkdir /ogg/ggs/dirdat
[oracle@rac1 ggs]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 10g on Oct 4 2011 23:50:20
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF -8.
Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10g) 1> edit params mgr
GGSCI (ora10g) 2> view params mgr
port 7809
autostart er *
autorestart er *
GGSCI (ora10g) 3> start mgr
Manager started.
GGSCI (ora10g) 3> info all
GGSCI (rac1) 1> edit params mgr
GGSCI (rac1) 2> view params mgr
port 7809
autostart er *
autorestart er *
GGSCI (rac1) 3> start mgr
Manager started.
GGSCI (rac1) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (rac1) 5>
备库配置应用进程
add replicat rpt1,exttrail ./dirdat/ nd,nodbcheckpoint
edit params testrpt
GGSCI (asmonly) 2> view params testrpt
REPLICAT rpt1
USERID ggate@pro,PASSWORD ggate
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE ./dirrpt/repdr.dsc,append,megabytes 100
setenv ( NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" )
ddl include all
ddlerror default ignore retryop maxretries 3 retrydelay 5
map test.*,target test.*;
GGSCI (ora10g) 3>
主库配置抽取进程
dblogin userid ggate,password ggate
Successfully logged into database.
add extract ext1,tranlog,begin now
EXTRACT added.
ADD EXTTRAIL /oracle/app/ggs/dirdat/et, EXTRACT EXT1
EXTTRAIL added.
GGSCI (ora10g) 18> view params testext
EXTRACT ext1
setenv ( NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" )
setenv (ORACLE_SID = ora10g)
USERID ggate, PASSWORD ggate
EXTTRAIL /oracle/app/ggs/dirdat/et
dynamicresolution
DDL INCLUDE ALL
table test.*;
启动进程
start ext1
主库配置传输进程
dblogin userid ggate,password ggate
Successfully logged into database.
add extract pump1,exttrailsource /oracle/app/ggs/dirdat/et
EXTRACT added.
add rmttrail /ogg/ggs/dirdat/nd,extract pump1
RMTTRAIL added.
GGSCI (ora10g) 18> view params testext
EXTRACT ext1
setenv ( NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" )
setenv (ORACLE_SID = ora10g)
USERID ggate, PASSWORD ggate
EXTTRAIL /oracle/app/ggs/dirdat/et
dynamicresolution
DDL INCLUDE ALL
table test.*;
分区 实施手册 的第 6 页
Aluphamii
启动进程
start pump1
主库查看目前最小SCN
SELECT (SELECT MIN(d.CHECKPOINT_CHANGE#) FROM v$datafile d) datafile_scn,
(SELECT MIN(d.CHECKPOINT_CHANGE#)
FROM v$datafile_header d
WHERE rownum = 1) datafile_header_scn,
(SELECT current_scn FROM v$database) current_scn,
(SELECT min(b.NEXT_CHANGE#)
FROM v$archived_log b
WHERE b.SEQUENCE# in (130,78)
AND resetlogs_change# =
(SELECT d.RESETLOGS_CHANGE# FROM v$database d)) NEXT_CHANGE#
FROM dual;
DATAFILE_SCN DATAFILE_HEADER_SCN CURRENT_SCN NEXT_CHANGE#
------------ ------------------- ----------- ------------
486776
486776 486974
主库开始备份
create or replace directory dmp as '/oracle';
grant read,write on directory dmp to public;
[oracle@ora10g oracle]$ expdp system/oracle directory=dmp schemas=TEST
logfile=exp_20200416.log dumpfile=test_dump_20200416_%u.dmp flashback_scn=
486974;
Export: Release 10.2.0.5.0 - 64bit Production on Friday, 17 April, 2020
3:03:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dmp
schemas=TEST logfile=exp_20200416.log dumpfile=test_dump_20200416_%u.dmp
flashback_scn=486974
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TEST"."T1" 5.023 KB 10
rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
*****************************************************************************
*
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/oracle/test_dump_20200416_01.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 03:04:01
导出过程中可向该表中继续添加数据
SQL> insert into t1 values(sysdate);
1 row created.
SQL> select count(*) from t1;
COUNT(*)
----------
16
将备份传至备库
[oracle@ora10g oracle]$ scp test_dump_20200416_01.dmp rac1:/ogg/ggs
oracle@rac1's password:
test_dump_20200416_01.dmp
100% 168KB 168.0KB/s 00:00
备库导入数据
create or replace directory dmp as '/ogg/ggs';
Directory created.
grant read,write on directory dmp to public;
Grant succeeded.
[oracle@rac1 ggs]$ impdp system/oracle directory=dmp
schemas=TEST logfile=exp_20200416.log dumpfile=test_dump_
20200416_%u.dmp cluster=no;
Import: Release 11.2.0.4.0 - Production on Fri Apr 17
03:19:33 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition
Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters,
Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully
loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02": system/********
directory=dmp schemas=TEST logfile=exp_20200416.log
dumpfile=test_dump_20200416_%u.dmp cluster=no
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TEST"."T1"
5.023 KB 10 rows
Processing object type
SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type
SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type
SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully completed
at Fri Apr 17 03:20:52 2020 elapsed 0 00:01:04
查看表内数据发现并不一致，因为主库一直在活动
SQL> select count(*) from t1;
COUNT(*)
----------
10
备库启动应用进程
start replicat rpt1,aftercsn 486974
备库查看表的应用情况
SQL> select count(*) from t1;
COUNT(*)
----------
分区 实施手册 的第 7 页
Aluphamii
----------
16
将1节点的OGG进程停止，在2节点启动
GGSCI (rac1) 21> stop rpt1
Sending STOP request to REPLICAT RPT1 ...
Request processed.
GGSCI (rac1) 22> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (rac1) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
REPLICAT STOPPED RPT1 00:00:00 00:00:12
2节点启动OGG进程
GGSCI (rac2) 1> start mgr
Manager started.
GGSCI (rac2) 4> info all
Program Status Group Lag at Chkpt Time Since
Chkpt
MANAGER RUNNING
REPLICAT RUNNING RPT1 00:00:00 00:00:02
主库继续插入数据
备库验证数据
SQL> insert into t1 values(sysdate);
SQL> select count(*) from t1;
1 row created.
commit；
SQL> select count(*) from t1;
COUNT(*)
----------
18
COUNT(*)
----------
18
至此OGG 10向11g迁移已完成
分区 实施手册 的第 8 页
Aluphamii
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
