[BEGIN] 2016/10/28 10:06:55
[oracle@shost ~]$ hostname
shost
[oracle@shost ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Oct 28 10:08:51 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 320306616 bytes
Fixed Size 740792 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes
Database mounted.
Database opened.
SQL> !lsnrctl status
LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 28-OCT-2016 10:09:40
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
!TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
SQL> !lsnrctl start
/bin/bash: !lsnrctl: command not found
SQL> !lsnrctl start
LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 28-OCT-2016 10:09:51
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Starting /u01/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.8.0 - Production
Start Date 28-OCT-2016 10:09:51
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL> alter system register;
System altered.
SQL> !lsnrctl status
LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 28-OCT-2016 10:10:04
Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.8.0 - Production
Start Date 28-OCT-2016 10:09:51
Uptime 0 days 0 hr. 0 min. 13 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL> select * from v$banner;
select * from v$banner
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
[oracle@shost ~]$ cd $GGHOME
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED
GGSCI (shost) 2> start mgr
Manager started.
GGSCI (shost) 3> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
GGSCI (shost) 4> create user ggs identified by ggs account unlock;
ERROR: Invalid command.
GGSCI (shost) 5> exit
[oracle@shost ogg11]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Oct 28 10:11:44 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> create user ggs identified by ggs account unlock;
User created.
如果对权限有要求，如没要求，一般就给dba权限，详细权限为：
GRANT create table to ggs;
GRANT CONNECT TO ggs;
GRANT ALTER ANY TABLE TO ggs;
GRANT ALTER SESSION TO ggs;
GRANT CREATE SESSION TO ggs;
GRANT FLASHBACK ANY TABLE TO ggs;
GRANT SELECT ANY DICTIONARY TO ggs;
GRANT SELECT ANY TABLE TO ggs;
GRANT RESOURCE” TO ggs;
GRANT DELETE ANY TABLE TO ggs;
GRANT INSERT ANY TABLE TO ggs;
GRANT UPDATE ANY TABLE TO ggs;
GRANT RESTRICTED SESSION TO ggs;
SQL> grant dba to ggs;
Grant succeeded.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/orcl/archive
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11
SQL> alter system set recyclebin=off scope=spfile;
alter system set recyclebin=off scope=spfile
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> select supplemental_log_data_min from v$database;
SUP
---
NO
SQL> alter database add supplemental log data;
Database altered.
SQL> select supplemental_log_data_min from v$database;
SUP
---
YES
SQL> select username,default_tablespace,temporary_tablespace from dba_users where username='HR';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
----------- ------------------------------
HR EXAMPLE TEMP
SQL> alter user hr identified by hr account unlock;
User altered.
SQL> connect hr/hr
Connected.
SQL> select tname from tab;
TNAME
------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
EMP_DETAILS_VIEW
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
15 rows selected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
[oracle@shost ogg11]$
[oracle@shost ogg11]$
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> dblogin userid ggs,password ggs
Successfully logged into database.
GGSCI (shost) 2> add trandata sh.*
2016-10-28 10:17:12 INFO OGG-01451 Unique key I_SNAP$_CAL_MONTH_SALES_MV cannot be used due to the inclusion of function-based index column.
2016-10-28 10:17:12 WARNING OGG-00869 No viable unique key is defined for table CAL_MONTH_SALES_MV. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.CAL_MONTH_SALES_MV.
Logging of supplemental redo data enabled for table SH.CHANNELS.
2016-10-28 10:17:12 WARNING OGG-00869 No unique key is defined for table COSTS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.COSTS.
Logging of supplemental redo data enabled for table SH.COUNTRIES.
Logging of supplemental redo data enabled for table SH.CUSTOMERS.
2016-10-28 10:17:12 INFO OGG-01451 Unique key I_SNAP$_FWEEK_PSCAT_SALES_ cannot be used due to the inclusion of function-based index column.
2016-10-28 10:17:12 WARNING OGG-00869 No viable unique key is defined for table FWEEK_PSCAT_SALES_MV. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.FWEEK_PSCAT_SALES_MV.
2016-10-28 10:17:12 WARNING OGG-00869 No unique key is defined for table MVIEW$_EXCEPTIONS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.MVIEW$_EXCEPTIONS.
2016-10-28 10:17:12 WARNING OGG-00869 No unique key is defined for table MV_CAPABILITIES_TABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.MV_CAPABILITIES_TABLE.
2016-10-28 10:17:12 WARNING OGG-00869 No unique key is defined for table PLAN_TABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.PLAN_TABLE.
Logging of supplemental redo data enabled for table SH.PRODUCTS.
Logging of supplemental redo data enabled for table SH.PROMOTIONS.
2016-10-28 10:17:13 WARNING OGG-00869 No unique key is defined for table REWRITE_TABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.REWRITE_TABLE.
2016-10-28 10:17:13 WARNING OGG-00869 No unique key is defined for table SALES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Logging of supplemental redo data enabled for table SH.SALES.
ERROR: OCI Error retrieving bind info for query (status = 100), SQL <SELECT * FROM "SH"."SALES_TRANSACTIONS_EXT">.
GGSCI (shost) 5> add trandata oe.*
2016-10-28 10:23:24 WARNING OGG-01455 Object table OE.CATEGORIES_TAB is not supported for this database version.
Logging of supplemental redo data enabled for table OE.CUSTOMERS.
Logging of supplemental redo data enabled for table OE.INVENTORIES.
Logging of supplemental redo data enabled for table OE.ORDERS.
Logging of supplemental redo data enabled for table OE.ORDER_ITEMS.
Logging of supplemental redo data enabled for table OE.PRODUCT_DESCRIPTIONS.
Logging of supplemental redo data enabled for table OE.PRODUCT_INFORMATION.
Logging of supplemental redo data enabled for table OE.WAREHOUSES.
GGSCI (shost) 6> add trandata hr.*
Logging of supplemental redo data enabled for table HR.COUNTRIES.
Logging of supplemental redo data enabled for table HR.DEPARTMENTS.
Logging of supplemental redo data enabled for table HR.EMPLOYEES.
Logging of supplemental redo data enabled for table HR.JOBS.
Logging of supplemental redo data enabled for table HR.JOB_HISTORY.
Logging of supplemental redo data enabled for table HR.LOCATIONS.
Logging of supplemental redo data enabled for table HR.REGIONS.
GGSCI (shost) 7>
GGSCI (shost) 7>
GGSCI (shost) 7>
GGSCI (shost) 7> info trandata hr.*
Logging of supplemental redo log data is enabled for table HR.COUNTRIES
Logging of supplemental redo log data is enabled for table HR.DEPARTMENTS
Logging of supplemental redo log data is enabled for table HR.EMPLOYEES
Logging of supplemental redo log data is enabled for table HR.JOBS
Logging of supplemental redo log data is enabled for table HR.JOB_HISTORY
Logging of supplemental redo log data is enabled for table HR.LOCATIONS
Logging of supplemental redo log data is enabled for table HR.REGIONS
GGSCI (shost) 8> info trandata oe.*
2016-10-28 10:25:48 WARNING OGG-01455 Object table OE.CATEGORIES_TAB is not supported for this database version.
Logging of supplemental redo log data is enabled for table OE.CUSTOMERS
Logging of supplemental redo log data is enabled for table OE.INVENTORIES
Logging of supplemental redo log data is enabled for table OE.ORDERS
Logging of supplemental redo log data is enabled for table OE.ORDER_ITEMS
Logging of supplemental redo log data is enabled for table OE.PRODUCT_DESCRIPTIONS
Logging of supplemental redo log data is enabled for table OE.PRODUCT_INFORMATION
Logging of supplemental redo log data is enabled for table OE.WAREHOUSES
GGSCI (shost) 9> info trandata sh.*
Logging of supplemental redo log data is enabled for table SH.CAL_MONTH_SALES_MV
Logging of supplemental redo log data is enabled for table SH.CHANNELS
Logging of supplemental redo log data is enabled for table SH.COSTS
Logging of supplemental redo log data is enabled for table SH.COUNTRIES
Logging of supplemental redo log data is enabled for table SH.CUSTOMERS
Logging of supplemental redo log data is enabled for table SH.FWEEK_PSCAT_SALES_MV
Logging of supplemental redo log data is enabled for table SH.MVIEW$_EXCEPTIONS
Logging of supplemental redo log data is enabled for table SH.MV_CAPABILITIES_TABLE
Logging of supplemental redo log data is enabled for table SH.PLAN_TABLE
Logging of supplemental redo log data is enabled for table SH.PRODUCTS
Logging of supplemental redo log data is enabled for table SH.PROMOTIONS
Logging of supplemental redo log data is enabled for table SH.REWRITE_TABLE
Logging of supplemental redo log data is enabled for table SH.SALES
Logging of supplemental redo log data is disabled for table SH.SALES_TRANSACTIONS_EXT.
Logging of supplemental redo log data is disabled for table SH.TIMES.
GGSCI (shost) 10> edit params ext_db
GGSCI (shost) 4> view params ext_db
extract ext_db
dynamicresolution
userid ggs,password ggs
exttrail ./dirdat/aa
table hr.*;
GGSCI (shost) 5> add extract ext_db,tranlog,begin now
EXTRACT added.
GGSCI (shost) 7> add exttrail ./dirdat/aa,extract ext_db
EXTTRAIL added.
GGSCI (shost) 8> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_DB 00:00:00 00:00:39
GGSCI (shost) 9> edit params pm_db
GGSCI (shost) 10> view params pm_db
extract pm_db
passthru
dynamicresolution
userid ggs,password ggs
rmthost 192.168.1.123,mgrport 7809
rmttrail ./dirdat/bb
table hr.*;
GGSCI (shost) 11> add extract pm_db,exttrailsource ./dirdat/aa
EXTRACT added.
GGSCI (shost) 12> add rmttrail ./dirdat/bb,extract pm_db
RMTTRAIL added.
GGSCI (shost) 13> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_DB 00:00:00 00:02:44
EXTRACT STOPPED PM_DB 00:00:00 00:00:20
GGSCI (shost) 32> start ext_db
Sending START request to MANAGER ...
EXTRACT EXT_DB starting
GGSCI (shost) 33> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:04:19
EXTRACT STOPPED PM_DB 00:00:00 00:10:03
GGSCI (shost) 34> start pm_db
Sending START request to MANAGER ...
EXTRACT PM_DB starting
GGSCI (shost) 35> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:04:19 00:00:10
EXTRACT RUNNING PM_DB 00:00:00 00:10:13
GGSCI (shost) 41> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:06
EXTRACT ABENDED PM_DB 00:00:00 00:12:25
GGSCI (shost) 42> view ggsevt
2016-10-26 19:26:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
2016-10-26 19:26:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
2016-10-26 19:30:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
2016-10-26 19:31:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-26 19:31:01 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-26 20:32:04 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop mgr.
2016-10-26 20:32:05 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (STOP).
2016-10-26 20:32:05 WARNING OGG-00938 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager is stopping at user request.
2016-10-28 10:11:08 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-28 10:11:08 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-28 10:17:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata sh.*
.
2016-10-28 10:17:12 INFO OGG-01451 Oracle GoldenGate Command Interpreter for Oracle: Unique key I_SNAP$_CAL_MONTH_SALES_MV can
not be used due to the inclusion of function-based index column.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No viable unique key is defined for table
CAL_MONTH_SALES_MV. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to
define the key.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table COSTS.
All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-10-28 10:17:12 INFO OGG-01451 Oracle GoldenGate Command Interpreter for Oracle: Unique key I_SNAP$_FWEEK_PSCAT_SALES_ can
not be used due to the inclusion of function-based index column.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No viable unique key is defined for table
FWEEK_PSCAT_SALES_MV. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used
to define the key.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table MVIEW$
_EXCEPTIONS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define
the key.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table MV_CAP
ABILITIES_TABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to def
ine the key.
2016-10-28 10:17:12 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table PLAN_T
ABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key
.
2016-10-28 10:17:13 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table REWRIT
E_TABLE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the
key.
2016-10-28 10:17:13 WARNING OGG-00869 Oracle GoldenGate Command Interpreter for Oracle: No unique key is defined for table SALES.
All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2016-10-28 10:23:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata scot
t.*.
2016-10-28 10:23:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata oe.*
.
2016-10-28 10:23:24 WARNING OGG-01455 Oracle GoldenGate Command Interpreter for Oracle: Object table OE.CATEGORIES_TAB is not sup
ported for this database version.
2016-10-28 10:25:08 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add trandata hr.*
.
2016-10-28 10:25:48 WARNING OGG-01455 Oracle GoldenGate Command Interpreter for Oracle: Object table OE.CATEGORIES_TAB is not sup
ported for this database version.
2016-10-28 10:26:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext_c
db.
2016-10-28 10:29:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext_d
b.
2016-10-28 10:29:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add extract ext_d
b tranlog,begin now.
2016-10-28 10:30:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./di
rdat/aa extrace ext_db.
2016-10-28 10:30:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./di
rdat/aa extract ext_db.
2016-10-28 10:30:52 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params pm_db
.
2016-10-28 10:32:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add extract pm_db
exttrailsource ./dirdat/aa.
2016-10-28 10:32:32 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add rmttrail ./di
rdat/bb extract pm_db.
2016-10-28 10:33:39 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext_db.
2016-10-28 10:33:39 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT EXT_DB ).
2016-10-28 10:33:39 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_DB starting.
2016-10-28 10:33:39 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB starting.
2016-10-28 10:33:39 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext_db.prm: Could not open checkpoint file /u01/ogg11
/dirchk/EXT_CDB.cpe, mode 1 (error 2, No such file or directory).
2016-10-28 10:33:39 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_db.prm: PROCESS ABENDING.
2016-10-28 10:33:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext_db.
2016-10-28 10:33:49 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT EXT_DB ).
2016-10-28 10:33:49 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_DB starting.
2016-10-28 10:33:49 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB starting.
2016-10-28 10:33:49 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext_db.prm: Could not open checkpoint file /u01/ogg11
/dirchk/EXT_CDB.cpe, mode 1 (error 2, No such file or directory).
2016-10-28 10:33:49 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_db.prm: PROCESS ABENDING.
2016-10-28 10:37:30 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): delete ext_cdb.
2016-10-28 10:37:58 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add extract ext_d
b tranlog,begin now.
2016-10-28 10:38:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./di
rdat/aa extrace ext_db.
2016-10-28 10:38:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./di
rdat/aa extract ext_db.
2016-10-28 10:38:39 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext_db.
2016-10-28 10:38:39 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT EXT_DB ).
2016-10-28 10:38:39 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_DB starting.
2016-10-28 10:38:39 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB starting.
2016-10-28 10:38:39 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext_db.prm: Could not open checkpoint file /u01/ogg11
/dirchk/EXT_CDB.cpe, mode 1 (error 2, No such file or directory).
2016-10-28 10:38:39 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext_db.prm: PROCESS ABENDING.
2016-10-28 10:42:02 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext_d
b.
2016-10-28 10:42:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext_db.
2016-10-28 10:42:15 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT EXT_DB ).
2016-10-28 10:42:15 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_DB starting.
2016-10-28 10:42:15 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB starting.
2016-10-28 10:42:15 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext_db.prm: BOUNDED RECOVERY: reset to initial or alt
ered checkpoint.
2016-10-28 10:42:16 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext_db.prm: Positioning to begin time Oct 28, 2016 10
:37:58 AM.
2016-10-28 10:42:17 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext_db.prm: Positioned to Sequence 11, RBA 59398672,
Oct 28, 2016 10:37:58 AM.
2016-10-28 10:42:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB started.
2016-10-28 10:42:17 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext_db.prm: No recovery is required for target file .
/dirdat/aa000000, at RBA 0 (file not opened).
2016-10-28 10:42:17 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext_db.prm: Output file ./dirdat/aa is using format R
ELEASE 10.4/11.1.
2016-10-28 10:42:17 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext_db.prm: Position of first record processed Sequen
ce 11, RBA 59398672, SCN 0.259079, Oct 28, 2016 10:37:59 AM.
2016-10-28 10:42:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start pm_db.
2016-10-28 10:42:26 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT PM_DB ).
2016-10-28 10:42:26 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PM_DB starting.
2016-10-28 10:42:26 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB starting.
2016-10-28 10:42:26 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB started.
2016-10-28 10:42:26 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:36 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:46 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:56 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:06 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:16 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:26 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:36 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:46 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:56 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:44:06 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:44:16 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused); ret
ries exceeded.
2016-10-28 10:44:16 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pm_db.prm: PROCESS ABENDING.
启动 target 端 mgr:
GGSCI (shost) 43> exit
[oracle@shost ogg11]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 6 09:55:01 2016 from 192.168.1.25
[oracle@node1 ~]$ cd $GGHOME
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (node1) 2> start mgr
Manager started.
GGSCI (node1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (node1) 4> exit
[oracle@node1 ogg12c]$ exit
logout
Connection to 192.168.1.123 closed.
重新启动源端 pm_db:
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:09
EXTRACT ABENDED PM_DB 00:00:00 00:13:21
GGSCI (shost) 2> start pm_db
Sending START request to MANAGER ...
EXTRACT PM_DB starting
GGSCI (shost) 3> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:10
EXTRACT RUNNING PM_DB 00:00:00 00:13:32
GGSCI (shost) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:05
EXTRACT RUNNING PM_DB 00:00:00 00:00:04
GGSCI (shost) 5> view ggsevt
2016-10-28 10:42:15 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT_DB starting.
2016-10-28 10:42:15 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB starting.
2016-10-28 10:42:15 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext_db.prm: BOUNDED RECOVERY: reset to initial or alt
ered checkpoint.
2016-10-28 10:42:16 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext_db.prm: Positioning to begin time Oct 28, 2016 10
:37:58 AM.
2016-10-28 10:42:17 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext_db.prm: Positioned to Sequence 11, RBA 59398672,
Oct 28, 2016 10:37:58 AM.
2016-10-28 10:42:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext_db.prm: EXTRACT EXT_DB started.
2016-10-28 10:42:17 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext_db.prm: No recovery is required for target file .
/dirdat/aa000000, at RBA 0 (file not opened).
2016-10-28 10:42:17 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext_db.prm: Output file ./dirdat/aa is using format R
ELEASE 10.4/11.1.
2016-10-28 10:42:17 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, ext_db.prm: Position of first record processed Sequen
ce 11, RBA 59398672, SCN 0.259079, Oct 28, 2016 10:37:59 AM.
2016-10-28 10:42:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start pm_db.
2016-10-28 10:42:26 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT PM_DB ).
2016-10-28 10:42:26 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PM_DB starting.
2016-10-28 10:42:26 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB starting.
2016-10-28 10:42:26 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB started.
2016-10-28 10:42:26 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:36 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:46 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:42:56 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:06 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:16 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:26 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:36 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:46 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:43:56 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:44:06 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused).
2016-10-28 10:44:16 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, pm_db.prm: TCP/IP error 111 (Connection refused); ret
ries exceeded.
2016-10-28 10:44:16 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pm_db.prm: PROCESS ABENDING.
2016-10-28 10:45:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start pm_db.
2016-10-28 10:45:41 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.
1.88 (START EXTRACT PM_DB ).
2016-10-28 10:45:41 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PM_DB starting.
2016-10-28 10:45:41 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB starting.
2016-10-28 10:45:41 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pm_db.prm: EXTRACT PM_DB started.
2016-10-28 10:45:47 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, pm_db.prm: Socket buffer size set to 27985 (flush siz
e 27985).
2016-10-28 10:45:47 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, pm_db.prm: No recovery is required for target file ./
dirdat/bb000000, at RBA 0 (file not opened).
2016-10-28 10:45:47 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, pm_db.prm: Output file ./dirdat/bb is using format RE
LEASE 10.4/11.1.
GGSCI (shost) 6> exit
查看目标端生成trail文件：
[oracle@shost ogg11]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 27 22:44:14 2016 from 192.168.1.88
[oracle@node1 ~]$ cd $GGHOME
[oracle@node1 ogg12c]$ cd dirdat
[oracle@node1 dirdat]$ ls -l
total 0
-rw-r-----. 1 oracle oinstall 0 Oct 27 22:44 bb000000
[oracle@node1 dirdat]$ exit
logout
Connection to 192.168.1.123 closed.
[oracle@shost ogg11]$ exit
logout
执行数据首次实例化：
[root@shost ~]# su - oracle
[oracle@shost ~]$ cd $GGHOME
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:10
EXTRACT RUNNING PM_DB 00:00:00 00:00:01
确认extrace,data pump 启动后：
GGSCI (shost) 2> exit
查看源端数据库当前scn:
[oracle@shost ogg11]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Oct 28 10:47:06 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
260562
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
exp 一致性导出源端数据：
[oracle@shost ogg11]$ cd
[oracle@shost ~]$ pwd
/home/oracle
[oracle@shost ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@shost ~]$ exp system/oracle file=/u01/app/oracle/exp_hr.dmp owner=hr flashback_scn=190646 log= exp_hr.log
Export: Release 9.2.0.8.0 - Production on Fri Oct 28 10:49:29 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
EXP-00008: ORACLE error 1466 encountered
ORA-01466: unable to read data - table definition has changed
EXP-00000: Export terminated unsuccessfully
上面指定的scn有误，调整为正确的scn导出数据正常：
[oracle@shost ~]$ exp system/oracle file=/u01/app/oracle/exp_hr.dmp owner=hr flashback_scn=260562 log= exp_hr.log
Export: Release 9.2.0.8.0 - Production on Fri Oct 28 10:49:46 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user HR
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user HR
About to export HR's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export HR's tables via Conventional Path ...
. . exporting table COUNTRIES 25 rows exported
. . exporting table DEPARTMENTS 27 rows exported
. . exporting table EMPLOYEES 107 rows exported
. . exporting table JOBS 19 rows exported
. . exporting table JOB_HISTORY 10 rows exported
. . exporting table LOCATIONS 23 rows exported
. . exporting table REGIONS 4 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@shost ~]$
[oracle@shost ~]$
[oracle@shost ~]$
再次确认源端用户表空间相关信息：
[oracle@shost ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Oct 28 10:50:19 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> select username,default_tablespace,temporary_tablespace from dba_users where username='HR';
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TEMPORARY_TABLESPACE
------------------------------
HR EXAMPLE
TEMP
查看源端hr用户的数据表：
SQL> alter user hr identified by hr account unlock;
SP2-0640: Not connected
SQL> connect /as sysdba
Connected.
SQL> alter user hr identified by hr account unlock;
User altered.
SQL> connect hr/hr
Connected.
SQL> select tname from tab;
TNAME
------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
EMP_DETAILS_VIEW
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
8 rows selected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
连接到目标端，创建相应的表空间及用户：
[oracle@shost ~]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 27 22:45:31 2016 from 192.168.1.88
[oracle@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 22:51:13 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@node1 ~]$ export ORACLE_SID=orcl
[oracle@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 22:51:49 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> create tablespace example datafile size 2G;
Tablespace created.
SQL> l
1 create user hr identified by hr
2 account unlock
3 default tablespace example
4 temporary tablespace temp
5* quota unlimited on example
SQL> /
User created.
赋予用户相应的权限：
SQL> grant dba to hr;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
源端拷贝dmp文件至目标端导入：
[oracle@node1 ~]$ echo $ORACLE_SID
orcl
[oracle@node1 ~]$ exit
logout
Connection to 192.168.1.123 closed.
[oracle@shost ~]$ cd /u01/app/oracle
[oracle@shost oracle]$ ls -l
total 187472
drwxr-xr-x 3 oracle oinstall 4096 Oct 26 14:48 admin
drwxrwxr-x 7 oracle oinstall 4096 Oct 26 13:41 doc
-rw-r--r-- 1 oracle oinstall 114032640 Oct 27 10:48 exp_full.dmp
-rw-r--r-- 1 oracle oinstall 57344 Oct 28 10:49 exp_hr.dmp
-rw-r--r-- 1 oracle oinstall 77651968 Oct 27 10:46 exp_sh.dmp
drwxrwxr-x 3 oracle oinstall 4096 Oct 26 13:41 jre
drwxr-xr-x 3 oracle oinstall 4096 Oct 26 14:48 oradata
drwxrwxr-x 13 oracle oinstall 4096 Oct 26 14:42 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Oct 26 13:18 product
[oracle@shost oracle]$ scp -pr exp_hr.dmp 192.168.1.123:/u01/app/oracle/
oracle@192.168.1.123's password:
exp_hr.dmp 100% 56KB 56.0KB/s 00:00
登录至目标端导入数据：
[oracle@shost oracle]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 27 22:51:08 2016 from 192.168.1.88
[oracle@node1 ~]$ cd /u01/app/oracle
[oracle@node1 oracle]$ ls -l
total 84
drwxrwx---. 4 oracle oinstall 4096 Oct 27 00:29 admin
drwxrwx---. 4 oracle oinstall 4096 Oct 26 23:22 audit
drwxrwx---. 3 oracle oinstall 4096 Jun 6 01:43 cfgtoollogs
drwxrwxr-x. 2 oracle oinstall 4096 Oct 6 08:58 checkpoints
drwxrwxr-x. 19 oracle oinstall 4096 Jun 6 01:42 diag
drwxr-xr-x. 2 oracle oinstall 4096 Oct 27 02:20 dir1
-rw-r--r--. 1 oracle oinstall 57344 Oct 28 2016 exp_hr.dmp
drwxrwxr-x. 3 oracle oinstall 4096 Jun 6 01:38 product
[oracle@node1 oracle]$ pwd
/u01/app/oracle
[oracle@node1 oracle]$ imp userid=system/oracle@orcl fromuser=hr touser=hr file=exp_hr.dmp log=imp_hr.log
Import: Release 12.1.0.2.0 - Production on Thu Oct 27 22:57:06 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing HR's objects into HR
. . importing table "COUNTRIES" 25 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "COUNTRIES" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT REFERENCES ON "COUNTRIES" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "DEPARTMENTS" 27 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "DEPARTMENTS" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "EMPLOYEES" 107 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "EMPLOYEES" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT REFERENCES ON "EMPLOYEES" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "JOBS" 19 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "JOBS" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "JOB_HISTORY" 10 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "JOB_HISTORY" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "LOCATIONS" 23 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "LOCATIONS" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT REFERENCES ON "LOCATIONS" TO "OE""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'OE' does not exist
. . importing table "REGIONS" 4 rows imported
About to enable constraints...
Import terminated successfully with warnings.
忽略报错
确认目标端导入的表：
[oracle@node1 oracle]$ sqlplus hr/hr@orcl
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 22:58:27 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> select tname from tab;
TNAME
--------------------------------------------------------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
EMP_DETAILS_VIEW
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
8 rows selected.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
目标端准备配置replicat:
[oracle@node1 oracle]$ cd $GGHOME
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (node1) 2> exit
目标端建有orcc,orcl两个数据库实例，确认数据库实例为non-cdb实例：
[oracle@node1 ogg12c]$ echo $ORACLE_SID
orcc
[oracle@node1 ogg12c]$ export ORACLE_SID=orcl
目标端创建goldengate管理用户ggs:
[oracle@node1 ogg12c]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 22:59:44 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> create user ggs identified by ggs account unlock;
User created.
SQL> grant dba to ggs;
Grant succeeded.
SQL> connect ggs/ggs
Connected.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
配置目标端replicat进程：
[oracle@node1 ogg12c]$ echo $ORACLE_SID
orcl
[oracle@node1 ogg12c]$ cd $GGHOME
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (node1) 2> dblogin userid ggs,password ggs
Successfully logged into database.
配置replicat进程参数：
GGSCI (node1 as ggs@orcl) 3> edit params rep_db
GGSCI (node1 as ggs@orcl) 4> view params rep_db
replicat rep_db
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
SETENV (ORACLE_SID="orcl")
USERID ggs, PASSWORD ggs
handlecollisions
assumetargetdefs
map hr.*, target hr.*;
配置检查点表：
GGSCI (node1 as ggs@orcl) 6> edit params ./GLOBALS
添加检查点表：
GGSCI (node1 as ggs@orcl) 9> add checkpointtable ggs.chkt
Successfully created checkpoint table ggs.chkt.
添加replicat进程：
GGSCI (node1 as ggs@orcl) 10> add replicat rep_db,exttrail ./dirdat/bb,checkpointtable ggs.chkt
REPLICAT added.
GGSCI (node1 as ggs@orcl) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP_DB 00:00:00 00:00:03
启动replicat进程，指定scn:
GGSCI (node1 as ggs@orcl) 12> start rep_db,aftercsn 260562
Sending START request to MANAGER ...
REPLICAT REP_DB starting
GGSCI (node1 as ggs@orcl) 13> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP_DB 00:00:00 00:01:09
检查日志，发现报错如下：
GGSCI (node1 as ggs@orcl) 14> view ggsevt
2016-10-26 08:18:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:18:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop mgr.
2016-10-26 08:18:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:15094 (STOP).
2016-10-26 08:18:10 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-26 08:18:10 WARNING OGG-00938 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager is stopping at user request.
2016-10-26 08:18:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-26 08:18:15 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server colle
ctor.
2016-10-26 08:18:15 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-26 08:18:15 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-26 08:18:17 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:31:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:32:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop mgr.
2016-10-26 08:32:01 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:15109 (STOP).
2016-10-26 08:32:01 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-26 08:32:01 WARNING OGG-00938 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager is stopping at user request.
2016-10-26 08:32:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 01:20:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 01:32:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:27 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-27 22:44:27 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server colle
ctor.
2016-10-27 22:44:27 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-27 22:44:27 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-27 22:44:29 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:48 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.1
68.1.88]:32798 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2016-10-27 22:44:48 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2016-10-27 22:44:48 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
2016-10-27 22:44:48 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host [::1]:4
2886 (REPORT 3990 7819).
2016-10-27 22:44:48 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).
2016-10-27 22:44:48 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7819
).
2016-10-27 22:44:48 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.
2016-10-27 22:44:53 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to :32799.
2016-10-27 22:44:53 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/bb000000 (byte -1, current EOF 0).
2016-10-27 22:59:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:00:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:00:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid gg
s password ***.
2016-10-27 23:01:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params rep_d
b.
2016-10-27 23:04:27 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit ./GLOBALS.
2016-10-27 23:04:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ./GLO
BALS.
2016-10-27 23:05:05 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le.
2016-10-27 23:05:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le ogg.chkt.
2016-10-27 23:05:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le ggs.chkt.
2016-10-27 23:06:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add replicat rep_
db exttrail ./dirdat/bb,checkpointtable ggs.chkt.
2016-10-27 23:06:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:07:25 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_db afte
rcsn 260562.
2016-10-27 23:07:25 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:34307 (START REPLICAT REP_DB AFTERCSN 260562).
2016-10-27 23:07:25 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-27 23:07:25 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_DB starting.
2016-10-27 23:07:26 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_db.prm: REPLICAT REP_DB starting.
2016-10-27 23:07:26 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Operating system character set identifie
d as UTF-8.
2016-10-27 23:07:26 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_db.prm: ANSI SQL parameter syntax is used for pa
rameter parsing.
2016-10-27 23:07:26 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Successfully set environment variable OR
ACLE_SID=orcl.
2016-10-27 23:07:27 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, rep_db.prm: The previous message, 'INFO OGG-02095',
repeated 1 times.
2016-10-27 23:07:27 WARNING OGG-06471 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Unable to disable trigger firing.
2016-10-27 23:07:27 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-27 23:07:28 ERROR OGG-02091 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Operation not supported because enable_g
oldengate_replication is not set to true.
2016-10-27 23:07:28 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_db.prm: PROCESS ABENDING.
2016-10-27 23:07:29 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
目标端设置 enable_goldengate_replication 为TRUE:
GGSCI (node1 as ggs@orcl) 15> exit
[oracle@node1 ogg12c]$ echo $ORACLE_SID
orcl
[oracle@node1 ogg12c]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 23:08:34 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> show parameter goldengate_replicat
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
SQL> alter system set enable_goldengate_replication=TRUE;
System altered.
SQL> show parameter goldengate
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
目标端重新启动replicat:
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP_DB 00:00:00 00:02:59
GGSCI (node1) 2> start rep_db,aftercsn 260562
Sending START request to MANAGER ...
REPLICAT REP_DB starting
GGSCI (node1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:01
GGSCI (node1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:03
GGSCI (node1) 5> view ggsevt
2016-10-26 08:18:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:18:09 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop mgr.
2016-10-26 08:18:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:15094 (STOP).
2016-10-26 08:18:10 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-26 08:18:10 WARNING OGG-00938 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager is stopping at user request.
2016-10-26 08:18:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-26 08:18:15 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server colle
ctor.
2016-10-26 08:18:15 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-26 08:18:15 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-26 08:18:17 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:31:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-26 08:32:01 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): stop mgr.
2016-10-26 08:32:01 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:15109 (STOP).
2016-10-26 08:32:01 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-26 08:32:01 WARNING OGG-00938 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager is stopping at user request.
2016-10-26 08:32:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 01:20:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 01:32:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:27 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-10-27 22:44:27 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server colle
ctor.
2016-10-27 22:44:27 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #8).
2016-10-27 22:44:27 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2016-10-27 22:44:29 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 22:44:48 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host [192.1
68.1.88]:32798 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2016-10-27 22:44:48 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2016-10-27 22:44:48 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
2016-10-27 22:44:48 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host [::1]:4
2886 (REPORT 3990 7819).
2016-10-27 22:44:48 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1).
2016-10-27 22:44:48 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7819
).
2016-10-27 22:44:48 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.
2016-10-27 22:44:53 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to :32799.
2016-10-27 22:44:53 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening ./dirdat/bb000000 (byte -1, current EOF 0).
2016-10-27 22:59:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:00:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:00:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid gg
s password ***.
2016-10-27 23:01:11 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params rep_d
b.
2016-10-27 23:04:27 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit ./GLOBALS.
2016-10-27 23:04:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ./GLO
BALS.
2016-10-27 23:05:05 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le.
2016-10-27 23:05:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le ogg.chkt.
2016-10-27 23:05:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add checkpointtab
le ggs.chkt.
2016-10-27 23:06:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add replicat rep_
db exttrail ./dirdat/bb,checkpointtable ggs.chkt.
2016-10-27 23:06:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:07:25 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_db afte
rcsn 260562.
2016-10-27 23:07:25 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:34307 (START REPLICAT REP_DB AFTERCSN 260562).
2016-10-27 23:07:25 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-27 23:07:25 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_DB starting.
2016-10-27 23:07:26 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_db.prm: REPLICAT REP_DB starting.
2016-10-27 23:07:26 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Operating system character set identifie
d as UTF-8.
2016-10-27 23:07:26 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_db.prm: ANSI SQL parameter syntax is used for pa
rameter parsing.
2016-10-27 23:07:26 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Successfully set environment variable OR
ACLE_SID=orcl.
2016-10-27 23:07:27 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, rep_db.prm: The previous message, 'INFO OGG-02095',
repeated 1 times.
2016-10-27 23:07:27 WARNING OGG-06471 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Unable to disable trigger firing.
2016-10-27 23:07:27 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-27 23:07:28 ERROR OGG-02091 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Operation not supported because enable_g
oldengate_replication is not set to true.
2016-10-27 23:07:28 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_db.prm: PROCESS ABENDING.
2016-10-27 23:07:29 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:09:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:09:36 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start rep_db afte
rcsn 260562.
2016-10-27 23:09:36 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168
.1.123]:34310 (START REPLICAT REP_DB AFTERCSN 260562).
2016-10-27 23:09:36 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2016-10-27 23:09:36 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP_DB starting.
2016-10-27 23:09:36 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep_db.prm: REPLICAT REP_DB starting.
2016-10-27 23:09:36 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Operating system character set identifie
d as UTF-8.
2016-10-27 23:09:36 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep_db.prm: ANSI SQL parameter syntax is used for pa
rameter parsing.
2016-10-27 23:09:36 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Successfully set environment variable OR
ACLE_SID=orcl.
2016-10-27 23:09:37 INFO OGG-01971 Oracle GoldenGate Delivery for Oracle, rep_db.prm: The previous message, 'INFO OGG-02095',
repeated 1 times.
2016-10-27 23:09:37 INFO OGG-06451 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Triggers will be suppressed by default.
2016-10-27 23:09:37 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
2016-10-27 23:09:37 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep_db.prm: REPLICAT REP_DB started.
2016-10-27 23:09:37 INFO OGG-02243 Oracle GoldenGate Delivery for Oracle, rep_db.prm: Opened trail file ./dirdat/bb000000 at 2
016-10-27 23:09:37.714785.
2016-10-27 23:09:38 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2016-10-27 23:09:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
GGSCI (node1) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:08
GGSCI (node1) 7> lag rep_db
2016-10-27 23:10:01 INFO OGG-14054 Lag from heartbeat table requires DBLOGIN.
Sending GETLAG request to REPLICAT REP_DB ...
No records yet processed.
At EOF, no more records to process.
GGSCI (node1) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:07
GGSCI (node1) 9> exit
[oracle@node1 ogg12c]$ exit
logout
Connection to 192.168.1.123 closed.
确认源端lag:
[oracle@shost oracle]$ cd $GGHOME
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:02
EXTRACT RUNNING PM_DB 00:00:00 00:00:07
GGSCI (shost) 2> lag ext_db
Sending GETLAG request to EXTRACT EXT_DB ...
No records yet processed.
At EOF, no more records to process.
GGSCI (shost) 3> lag pm_db
Sending GETLAG request to EXTRACT PM_DB ...
No records yet processed.
At EOF, no more records to process.
GGSCI (shost) 4> exit
登录目标端查询 lag:
[oracle@shost ogg11]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 27 22:55:58 2016 from 192.168.1.88
[oracle@node1 ~]$ cd $GGHOME
[oracle@node1 ogg12c]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:01
GGSCI (node1) 2> view params rep_db
replicat rep_db
SETENV (ORACLE_SID="orcl")
USERID ggs, PASSWORD ggs
handlecollisions
assumetargetdefs
map hr.*, target hr.*;
会话级别取消handlecollisions:
GGSCI (node1) 3> send replicat rep_db nohandlecollisions
Sending NOHANDLECOLLISIONS request to REPLICAT REP_DB ...
REP_DB No tables found matching * to set NOHANDLECOLLISIONS.
GGSCI (node1) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:02
GGSCI (node1) 5> edit params rep_db
GGSCI (node1) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:02
GGSCI (node1) 7> exit
[oracle@node1 ogg12c]$ exit
logout
Connection to 192.168.1.123 closed.
测试：
[oracle@shost ogg11]$ sqlplus hr/hr
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Oct 28 11:12:46 2016
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> select tname from tab;
TNAME
------------------------------
COUNTRIES
DEPARTMENTS
EMPLOYEES
EMP_DETAILS_VIEW
JOBS
JOB_HISTORY
LOCATIONS
REGIONS
8 rows selected.
SQL> desc employees;
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
SQL> select sum(salary) from employees;
SUM(SALARY)
-----------
691400
SQL> update employees set salary=salary+1000;
107 rows updated.
SQL> commit;
Commit complete.
SQL> select sum(salary) from employees;
SUM(SALARY)
-----------
798400
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
[oracle@shost ogg11]$ 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 9i on Oct 4 2011 23:49:32
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (shost) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_DB 00:00:00 00:00:06
EXTRACT RUNNING PM_DB 00:00:00 00:00:09
GGSCI (shost) 2> stats ext_db
Sending STATS request to EXTRACT EXT_DB ...
Start of Statistics at 2016-10-28 11:14:38.
Output to ./dirdat/aa:
Extracting from HR.EMPLOYEES to HR.EMPLOYEES:
*** Total statistics since 2016-10-28 11:14:05 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Daily statistics since 2016-10-28 11:14:05 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Hourly statistics since 2016-10-28 11:14:05 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Latest statistics since 2016-10-28 11:14:05 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
End of Statistics.
GGSCI (shost) 3> stats pm_db
Sending STATS request to EXTRACT PM_DB ...
Start of Statistics at 2016-10-28 11:14:50.
Output to ./dirdat/bb:
Extracting from HR.EMPLOYEES to HR.EMPLOYEES:
*** Total statistics since 2016-10-28 11:14:06 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Daily statistics since 2016-10-28 11:14:06 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Hourly statistics since 2016-10-28 11:14:06 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Latest statistics since 2016-10-28 11:14:06 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
End of Statistics.
GGSCI (shost) 4> exit
[oracle@shost ogg11]$ ssh 192.168.1.123
oracle@192.168.1.123's password:
Last login: Thu Oct 27 23:10:43 2016 from 192.168.1.88
[oracle@node1 ~]$ cd $GGHOME
GGSCI (node1) 26> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:02
GGSCI (node1) 27> stats rep_db
Sending STATS request to REPLICAT REP_DB ...
Start of Statistics at 2016-10-27 23:21:06.
Replicating from HR.EMPLOYEES to HR.EMPLOYEES:
*** Total statistics since 2016-10-27 23:20:57 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Daily statistics since 2016-10-27 23:20:57 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Hourly statistics since 2016-10-27 23:20:57 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
*** Latest statistics since 2016-10-27 23:20:57 ***
Total inserts 0.00
Total updates 107.00
Total deletes 0.00
Total discards 0.00
Total operations 107.00
End of Statistics.
GGSCI (node1) 28> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:06
GGSCI (node1) 29> view report rep_db
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 03:29:37
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2016-10-27 23:20:51
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Jan 29 11:47:41 EST 2013, Release 2.6.32-358.el6.x86_64
Node: node1
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 4724
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2016-10-27 23:20:51 INFO OGG-03059 Operating system character set identified as UTF-8.
2016-10-27 23:20:51 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2016-10-27 23:20:51 INFO OGG-02095 Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2016-10-27 23:20:51 INFO OGG-02095 Successfully set environment variable ORACLE_SID=orcl.
replicat rep_db
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
2016-10-27 23:20:51 INFO OGG-02095 Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
SETENV (ORACLE_SID="orcl")
2016-10-27 23:20:51 INFO OGG-02095 Successfully set environment variable ORACLE_SID=orcl.
USERID ggs, PASSWORD ***
assumetargetdefs
map hr.*, target hr.*;
2016-10-27 23:20:51 INFO OGG-06451 Triggers will be suppressed by default.
2016-10-27 23:20:51 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg12c/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 4M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
***********************************************************************
** Run Time Messages **
***********************************************************************
2016-10-27 23:20:51 INFO OGG-02243 Opened trail file ./dirdat/bb000000 at 2016-10-27 23:20:51.615848.
2016-10-27 23:20:51 WARNING OGG-03509 Using NLS_LANG character set zhs16gbk as the source database character set.
2016-10-27 23:20:51 INFO OGG-06506 Wildcard MAP resolved (entry hr.*): map "HR"."EMPLOYEES", target hr."EMPLOYEES".
2016-10-27 23:20:57 INFO OGG-02759 The definition for table HR.EMPLOYEES is obtained from the target database.
2016-10-27 23:20:57 INFO OGG-06511 Using following columns in default map by name: EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, P
HONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID.
2016-10-27 23:20:57 INFO OGG-06510 Using the following key columns for target table HR.EMPLOYEES: EMPLOYEE_ID.
2016-10-27 23:21:06 INFO OGG-01021 Command received from GGSCI: STATS.
GGSCI (node1) 30> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP_DB 00:00:00 00:00:00
GGSCI (node1) 31> exit
[oracle@node1 ogg12c]$ echo $ORACLE_SID
orcc
[oracle@node1 ogg12c]$ export ORACLE_SID=orcl
[
[oracle@node1 ogg12c]$ sqlplus hr/hr
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 27 23:22:32 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Oct 27 2016 22:58:27 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> select sum(salary) from employees;
SUM(SALARY)
-----------
798400
[END] 2016/10/28 11:23:18
添加复制表测试(帖子字数限制删除）：
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖