goldengate 源端open resetlogs 后的处理测试
2017/4/28 23:23:31GGSCI (node1) 12> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:04
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:08
EXTRACT STOPPED EGGTEST1 00:00:00 5940:34:22
EXTRACT STOPPED EOLTP01 00:00:00 5940:34:22
EXTRACT STOPPED EPUMP01 00:00:00 5940:34:20
EXTRACT STOPPED HREXT 00:00:03 5940:34:19
EXTRACT STOPPED HRPUMP 00:00:00 5940:34:19
EXTRACT STOPPED MYDP1 00:00:00 5940:34:18
EXTRACT STOPPED MYEXT1 00:00:01 5940:34:17
EXTRACT STOPPED PGGTEST1 00:00:00 5940:34:16
GGSCI (node1) 13> info class_ex
EXTRACT CLASS_EXLast Started 2017-04-28 11:22 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 2636
Log Read CheckpointOracle Redo Logs
2017-04-28 11:22:42Seqno 204, RBA 9132032
SCN 0.2379392 (2379392)
GGSCI (node1) 14> lag class_ex
2017-04-28 11:23:50INFO OGG-14054Lag from heartbeat table requires DBLOGIN.
Sending GETLAG request to EXTRACT CLASS_EX ...
Last record lag 171 seconds.
At EOF, no more records to process.
GGSCI (node1) 15> exit
$ sqlplus scott/oracle
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:24:09 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> delete test;
100 rows deleted.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ 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 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
Start of Statistics at 2017-04-28 11:24:26.
Output to ./dirdat/cl:
Extracting from SCOTT.TEST to SCOTT.TEST:
*** Total statistics since 2017-04-28 11:24:19 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 100.00
*** Daily statistics since 2017-04-28 11:24:19 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 100.00
*** Hourly statistics since 2017-04-28 11:24:19 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 100.00
*** Latest statistics since 2017-04-28 11:24:19 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 100.00
End of Statistics.
GGSCI (node1) 2> exit
$ sqlplus scott/oracle
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:24:41 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connect scott/oracle
ERROR:
ORA-28002: the password will expire within 7 days
Connected.
SQL> select count(*) from test;
COUNT(*)
----------
0
SQL> desc test;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(38)
COL1 VARCHAR2(20)
COL2 VARCHAR2(20)
SQL> insert into test values (1,'1','1');
1 row created.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ 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 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
Start of Statistics at 2017-04-28 11:25:40.
Output to ./dirdat/cl:
Extracting from SCOTT.TEST to SCOTT.TEST:
*** Total statistics since 2017-04-28 11:24:19 ***
Total inserts 1.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 101.00
*** Daily statistics since 2017-04-28 11:24:19 ***
Total inserts 1.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 101.00
*** Hourly statistics since 2017-04-28 11:24:19 ***
Total inserts 1.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 101.00
*** Latest statistics since 2017-04-28 11:24:19 ***
Total inserts 1.00
Total updates 0.00
Total deletes 100.00
Total discards 0.00
Total operations 101.00
End of Statistics.
GGSCI (node1) 2>
GGSCI (node1) 2>
GGSCI (node1) 2>
GGSCI (node1) 2> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
sEXTRACT RUNNING CLASS_EX 00:00:00 00:00:00
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:03
EXTRACT STOPPED EGGTEST1 00:00:00 5940:37:58
EXTRACT STOPPED EOLTP01 00:00:00 5940:37:58
EXTRACT STOPPED EPUMP01 00:00:00 5940:37:57
EXTRACT STOPPED HREXT 00:00:03 5940:37:55
EXTRACT STOPPED HRPUMP 00:00:00 5940:37:55
EXTRACT STOPPED MYDP1 00:00:00 5940:37:55
EXTRACT STOPPED MYEXT1 00:00:01 5940:37:53
EXTRACT STOPPED PGGTEST1 00:00:00 5940:37:52
GGSCI (node1) 3> stop class_ex
ERROR: Invalid command.
GGSCI (node1) 4> stop class_ex
Sending STOP request to EXTRACT CLASS_EX ...
Request processed.
GGSCI (node1) 5> stop class_pu
Sending STOP request to EXTRACT CLASS_PU ...
Request processed.
GGSCI (node1) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:00:05
EXTRACT STOPPED CLASS_PU 00:00:00 00:00:02
EXTRACT STOPPED EGGTEST1 00:00:00 5940:38:17
EXTRACT STOPPED EOLTP01 00:00:00 5940:38:17
EXTRACT STOPPED EPUMP01 00:00:00 5940:38:16
EXTRACT STOPPED HREXT 00:00:03 5940:38:14
EXTRACT STOPPED HRPUMP 00:00:00 5940:38:14
EXTRACT STOPPED MYDP1 00:00:00 5940:38:14
EXTRACT STOPPED MYEXT1 00:00:01 5940:38:12
EXTRACT STOPPED PGGTEST1 00:00:00 5940:38:11
GGSCI (node1) 7> exit
$ sqlplus scott/oracle
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:27:49 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select dbid from v$database;
DBID
----------
1523110113
SQL> connect /as sysdba
Connected.
SQL> connect scott/oracle
ERROR:
ORA-28002: the password will expire within 7 days
Connected.
SQL> begin
2for i in 1 .. 100000
3loop
4insert into test values (i,to_char(i),to_char(i));
5commit;
6end loop;
7end;
8/
begin
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.SYS_C0011746) violated
ORA-06512: at line 4
SQL> 2
2* for i in 1 .. 100000
SQL> c/1/2
2* for i in 2 .. 100000
SQL> l
1begin
2for i in 2 .. 100000
3loop
4insert into test values (i,to_char(i),to_char(i));
5commit;
6end loop;
7* end;
SQL> /
PL/SQL procedure successfully completed.
SQL> select count(*) from test;
COUNT(*)
----------
100000
SQL> connect /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:32:15 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 1476398240 bytes
Database Buffers 117440512 bytes
Redo Buffers 7319552 bytes
Database mounted.
SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select resetlogs_change#,prior_resetlogs_change#,current_scn from v$database;
RESETLOGS_CHANGE# PRIOR_RESETLOGS_CHANGE# CURRENT_SCN
----------------- ----------------------- -----------
2582150 925702 2582515
SQL> select max(sequence#) from v$log;
MAX(SEQUENCE#)
--------------
1
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ 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 11g on Dec 12 2015 00:54:38
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 ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:07:22
EXTRACT STOPPED CLASS_PU 00:00:00 00:07:19
EXTRACT STOPPED EGGTEST1 00:00:00 5940:45:34
EXTRACT STOPPED EOLTP01 00:00:00 5940:45:34
EXTRACT STOPPED EPUMP01 00:00:00 5940:45:33
EXTRACT STOPPED HREXT 00:00:03 5940:45:31
EXTRACT STOPPED HRPUMP 00:00:00 5940:45:31
EXTRACT STOPPED MYDP1 00:00:00 5940:45:31
EXTRACT STOPPED MYEXT1 00:00:01 5940:45:29
EXTRACT STOPPED PGGTEST1 00:00:00 5940:45:28
GGSCI (node1) 2> start class_ex
Sending START request to MANAGER ...
EXTRACT CLASS_EX starting
GGSCI (node1) 3> start class_pu
Sending START request to MANAGER ...
EXTRACT CLASS_PU starting
GGSCI (node1) 4> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:04
EXTRACT RUNNING CLASS_PU 00:00:00 00:07:28
EXTRACT STOPPED EGGTEST1 00:00:00 5940:45:43
EXTRACT STOPPED EOLTP01 00:00:00 5940:45:43
EXTRACT STOPPED EPUMP01 00:00:00 5940:45:41
EXTRACT STOPPED HREXT 00:00:03 5940:45:40
EXTRACT STOPPED HRPUMP 00:00:00 5940:45:40
EXTRACT STOPPED MYDP1 00:00:00 5940:45:40
EXTRACT STOPPED MYEXT1 00:00:01 5940:45:38
EXTRACT STOPPED PGGTEST1 00:00:00 5940:45:37
GGSCI (node1) 7> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
No active extraction maps.
GGSCI (node1) 8> stats class_pu
Sending STATS request to EXTRACT CLASS_PU ...
No active extraction maps.
GGSCI (node1) 9> info class_ex
EXTRACT CLASS_EXLast Started 2017-04-28 11:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Process ID 2852
Log Read CheckpointOracle Redo Logs
2017-04-28 11:26:30Seqno 204, RBA 9220608
SCN 0.2379514 (2379514)
GGSCI (node1) 10> info class_pu
EXTRACT CLASS_PULast Started 2017-04-28 11:34 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Process ID 2864
Log Read CheckpointFile ./dirdat/cl000000074
2017-04-28 11:34:53.207817RBA 1446
GGSCI (node1) 11> send class_ex status
Sending STATUS request to EXTRACT CLASS_EX ...
EXTRACT CLASS_EX (PID 2852)
Current status: In recovery: At EOF
Current read position:
Redo thread #: 1
Sequence #: 204
RBA: 9220112
Timestamp: 2017-04-28 11:26:30.000000
SCN: 0.2379514 (2379514)
Current write position:
Sequence #: 74
RBA: 1446
Timestamp: 2017-04-28 11:37:04.660573
Extract Trail: ./dirdat/cl
GGSCI (node1) 12>
GGSCI (node1) 12>
GGSCI (node1) 12> exit
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:38:56 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> col name for a200;
SQL> set linesize 220;
SQL> select sequence#,name from v$archived_log;
SEQUENCE# NAME
---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
179 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_179_cv5nrw1n_.arc
180 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_180_cv5nrx4m_.arc
181 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_181_cv5nry1p_.arc
182 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_182_cv5nrzkg_.arc
183 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_183_cv5ns12c_.arc
184 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_184_cv5ns2t7_.arc
185 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_16/o1_mf_1_185_cv648ntg_.arc
186 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_17/o1_mf_1_186_cv8vhfoo_.arc
187 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_17/o1_mf_1_187_cv8vhgn5_.arc
188 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_18/o1_mf_1_188_cvdwvdqz_.arc
189 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_19/o1_mf_1_189_cvfdd6v6_.arc
SEQUENCE# NAME
-----------------------------------------------
190 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_19/o1_mf_1_190_cvfdpg0h_.arc
191 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_19/o1_mf_1_191_cvff1w4p_.arc
192 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_19/o1_mf_1_192_cvff8270_.arc
193 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_21/o1_mf_1_193_cvlgwykq_.arc
194 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_21/o1_mf_1_194_cvmqnjtd_.arc
195 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_22/o1_mf_1_195_cvobgm6m_.arc
196 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_22/o1_mf_1_196_cvoq4g1s_.arc
197 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_22/o1_mf_1_197_cvor0ymc_.arc
198 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_22/o1_mf_1_198_cvow82yp_.arc
199 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_199_cvrj8krm_.arc
200 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_200_cvrpv97t_.arc
SEQUENCE# NAME
-----------------------------------------------
201 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_201_cvrq3hl2_.arc
202 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_202_cvrqy3wv_.arc
203 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_203_dj6qyvkx_.arc
204 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_204_dj6r1r7l_.arc
205 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_205_dj6r20ny_.arc
206 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_206_dj6r5bq7_.arc
204 rows selected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ cd /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/
$ ls -ltr
total 171208
-rw-r----- 1 oracle oinstall 38883840 Apr 28 11:29 o1_mf_1_203_dj6qyvkx_.arc
-rw-r----- 1 oracle oinstall 48936448 Apr 28 11:31 o1_mf_1_204_dj6r1r7l_.arc
-rw-r----- 1 oracle oinstall 50181632 Apr 28 11:31 o1_mf_1_205_dj6r20ny_.arc
-rw-r----- 1 oracle oinstall 37306368 Apr 28 11:32 o1_mf_1_206_dj6r5bq7_.arc
SQL> l
1* select sequence#,resetlogs_id,name from v$archived_log
SEQUENCE# RESETLOGS_ID NAME
---------- ------------ ----------------------------------------------------------------------------------------------------
201 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_201_cvrq3hl2_.arc
202 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2016_08_23/o1_mf_1_202_cvrqy3wv_.arc
203 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_203_dj6qyvkx_.arc
204 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_204_dj6r1r7l_.arc
205 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_205_dj6r20ny_.arc
206 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_206_dj6r5bq7_.arc
1 942492778 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_1_dj6swn95_.arc
2 942492778 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_2_dj6swp1d_.arc
3 942492778 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_3_dj6swrp5_.arc
207 rows selected.
$ mv o1_mf_1_204_dj6r1r7l_.arc 1_204_942492778.dbf
$ mv o1_mf_1_205_dj6r20ny_.arc 1_205_942492778.dbf
$ mv o1_mf_1_206_dj6r5bq7_.arc 1_206_942492778.dbf
$ cd /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
SQL>
The following variables can be used in the format:
%s log sequence number
%S log sequence number, zero filled
%tthread number
%Tthread number, zero filled
%a activation ID
%d database ID
%r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database
SQL> select * from v$database_incarnation;
INCARNATION# RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES STATUSRESETLOGS_ID PRIOR_INCARNATION# FLASHBACK_DATABASE_ALLOWED
------------ ----------------- --------- ----------------------- --------- ------- ------------ ------------------ --------------------------
1 1 24-AUG-13 0 PARENT 824297850 0 NO
2 925702 02-MAR-16 1 24-AUG-13 PARENT 905467041 1 NO
3 2582150 28-APR-17 925702 02-MAR-16 CURRENT 942492778 2 NO
204 905467041 /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/o1_mf_1_204_dj6r1r7l_.arc
$ pwd
/u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28
$ cd $GGHOME
$ 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 11g on Dec 12 2015 00:54:38
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 ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:04
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:00
EXTRACT STOPPED EGGTEST1 00:00:00 5940:54:05
EXTRACT STOPPED EOLTP01 00:00:00 5940:54:05
EXTRACT STOPPED EPUMP01 00:00:00 5940:54:04
EXTRACT STOPPED HREXT 00:00:03 5940:54:02
EXTRACT STOPPED HRPUMP 00:00:00 5940:54:02
EXTRACT STOPPED MYDP1 00:00:00 5940:54:02
EXTRACT STOPPED MYEXT1 00:00:01 5940:54:00
EXTRACT STOPPED PGGTEST1 00:00:00 5940:53:59
GGSCI (node1) 2> stop class_ex
Sending STOP request to EXTRACT CLASS_EX ...
Request processed.
GGSCI (node1) 3> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:00:02
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:07
EXTRACT STOPPED EGGTEST1 00:00:00 5940:54:12
EXTRACT STOPPED EOLTP01 00:00:00 5940:54:12
EXTRACT STOPPED EPUMP01 00:00:00 5940:54:11
EXTRACT STOPPED HREXT 00:00:03 5940:54:09
EXTRACT STOPPED HRPUMP 00:00:00 5940:54:09
EXTRACT STOPPED MYDP1 00:00:00 5940:54:09
EXTRACT STOPPED MYEXT1 00:00:01 5940:54:07
EXTRACT STOPPED PGGTEST1 00:00:00 5940:54:07
GGSCI (node1) 4> edit params class_ex
GGSCI (node1) 5> view params class_ex
extract class_ex
dynamicresolution
userid ogg@orcc1,password AADAAAAAAAAAAADASBECPGQHFAPJFIGJJJHEZDUGZGBITHIFSHAEEDAEZAIHAGXGKDKIQENIRBCCYCOJ, aes128, encryptkey dbkey1
encrypttrail aes128 keyname dbkey1
-------add tranlogoptions 参数
tranlogoptions archivedlogonly
tranlogoptions altarchivelogdest primary /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28
--useridalias ogg
exttrail ./dirdat/cl
----table scott.*;
table scott.bonus;
table scott.dept;
table scott.emp;
table scott.load_data;
table scott.salgrade;
table scott.emp1;
table scott.cust, TOKENS ( TK-HOST = @GETENV('GGENVIRONMENT' , 'HOSTNAME'));
table scott.test, cols (id, col1);
table scott.test1, where (id < 1000);
table scott.test2;
table scott.dd;
table scott.tcustmer;
table scott.tcustord;
GGSCI (node1) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:02:24
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:04
EXTRACT STOPPED EGGTEST1 00:00:00 5940:56:34
EXTRACT STOPPED EOLTP01 00:00:00 5940:56:34
EXTRACT STOPPED EPUMP01 00:00:00 5940:56:33
EXTRACT STOPPED HREXT 00:00:03 5940:56:31
EXTRACT STOPPED HRPUMP 00:00:00 5940:56:31
EXTRACT STOPPED MYDP1 00:00:00 5940:56:31
EXTRACT STOPPED MYEXT1 00:00:01 5940:56:29
EXTRACT STOPPED PGGTEST1 00:00:00 5940:56:28
GGSCI (node1) 15> start class_ex
Sending START request to MANAGER ...
EXTRACT CLASS_EX starting
GGSCI (node1) 16> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:06
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:06
EXTRACT STOPPED EGGTEST1 00:00:00 5941:03:17
EXTRACT STOPPED EOLTP01 00:00:00 5941:03:17
EXTRACT STOPPED EPUMP01 00:00:00 5941:03:15
EXTRACT STOPPED HREXT 00:00:03 5941:03:14
EXTRACT STOPPED HRPUMP 00:00:00 5941:03:13
EXTRACT STOPPED MYDP1 00:00:00 5941:03:13
EXTRACT STOPPED MYEXT1 00:00:01 5941:03:12
EXTRACT STOPPED PGGTEST1 00:00:00 5941:03:11
GGSCI (node1) 17> info class_ex
EXTRACT CLASS_EXLast Started 2017-04-28 11:52 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Process ID 3003
Log Read CheckpointOracle Redo Logs
2017-04-28 11:31:56Seqno 206, RBA 37306368
SCN 0.2582146 (2582146)
GGSCI (node1) 18> lag class_ex
2017-04-28 11:52:58INFO OGG-14054Lag from heartbeat table requires DBLOGIN.
Sending GETLAG request to EXTRACT CLASS_EX ...
Last record lag 1,258 seconds.
At EOF, no more records to process.
GGSCI (node1) 19> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
Start of Statistics at 2017-04-28 11:53:47.
Output to ./dirdat/cl:
Extracting from SCOTT.TEST to SCOTT.TEST:
*** Total statistics since 2017-04-28 11:52:14 ***
Total inserts 99999.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 99999.00
*** Daily statistics since 2017-04-28 11:52:14 ***
Total inserts 99999.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 99999.00
*** Hourly statistics since 2017-04-28 11:52:14 ***
Total inserts 99999.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 99999.00
*** Latest statistics since 2017-04-28 11:52:14 ***
Total inserts 99999.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 99999.00
End of Statistics.
GGSCI (node1) 20> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:05
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:04
EXTRACT STOPPED EGGTEST1 00:00:00 5941:04:56
EXTRACT STOPPED EOLTP01 00:00:00 5941:04:56
EXTRACT STOPPED EPUMP01 00:00:00 5941:04:54
EXTRACT STOPPED HREXT 00:00:03 5941:04:53
EXTRACT STOPPED HRPUMP 00:00:00 5941:04:53
EXTRACT STOPPED MYDP1 00:00:00 5941:04:53
EXTRACT STOPPED MYEXT1 00:00:01 5941:04:51
EXTRACT STOPPED PGGTEST1 00:00:00 5941:04:50
GGSCI (node1) 21> info class_ex
EXTRACT CLASS_EXLast Started 2017-04-28 11:52 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago) **************************
Process ID 3003
Log Read CheckpointOracle Redo Logs
2017-04-28 11:31:56Seqno 206, RBA 37306368
SCN 0.2582146 (2582146)
GGSCI (node1) 22> stop class_ex
Sending STOP request to EXTRACT CLASS_EX ...
Request processed.
GGSCI (node1) 23> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:00:01
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:04
EXTRACT STOPPED EGGTEST1 00:00:00 5941:05:26
EXTRACT STOPPED EOLTP01 00:00:00 5941:05:26
EXTRACT STOPPED EPUMP01 00:00:00 5941:05:24
EXTRACT STOPPED HREXT 00:00:03 5941:05:23
EXTRACT STOPPED HRPUMP 00:00:00 5941:05:23
EXTRACT STOPPED MYDP1 00:00:00 5941:05:23
EXTRACT STOPPED MYEXT1 00:00:01 5941:05:21
EXTRACT STOPPED PGGTEST1 00:00:00 5941:05:20
GGSCI (node1) 24> edit params class_ex
GGSCI (node1) 25> view params class_ex
extract class_ex
dynamicresolution
userid ogg@orcc1,password AADAAAAAAAAAAADASBECPGQHFAPJFIGJJJHEZDUGZGBITHIFSHAEEDAEZAIHAGXGKDKIQENIRBCCYCOJ, aes128, encryptkey dbkey1
encrypttrail aes128 keyname dbkey1
---tranlogoptions archivedlogonly
---tranlogoptions altarchivelogdest primary /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28
--useridalias ogg
exttrail ./dirdat/cl
----table scott.*;
table scott.bonus;
table scott.dept;
table scott.emp;
table scott.load_data;
table scott.salgrade;
table scott.emp1;
table scott.cust, TOKENS ( TK-HOST = @GETENV('GGENVIRONMENT' , 'HOSTNAME'));
table scott.test, cols (id, col1);
table scott.test1, where (id < 1000);
table scott.test2;
table scott.dd;
table scott.tcustmer;
table scott.tcustord;
GGSCI (node1) 26> exit
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:55:21 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
SQL> select dbid from v$database;
DBID
----------
1523110113
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ 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 11g on Dec 12 2015 00:54:38
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 ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:01:39
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:01
EXTRACT STOPPED EGGTEST1 00:00:00 5941:07:04
EXTRACT STOPPED EOLTP01 00:00:00 5941:07:04
EXTRACT STOPPED EPUMP01 00:00:00 5941:07:02
EXTRACT STOPPED HREXT 00:00:03 5941:07:01
EXTRACT STOPPED HRPUMP 00:00:00 5941:07:01
EXTRACT STOPPED MYDP1 00:00:00 5941:07:01
EXTRACT STOPPED MYEXT1 00:00:01 5941:06:59
EXTRACT STOPPED PGGTEST1 00:00:00 5941:06:58
GGSCI (node1) 2> alter class_ex extseqno 1,extrba 0
EXTRACT altered.
GGSCI (node1) 3> info class_ex
EXTRACT CLASS_EXInitialized 2017-04-28 11:56 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read CheckpointOracle Redo Logs
First Record Seqno 1, RBA 0
SCN 0.0 (0)
GGSCI (node1) 4> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 00:00:27
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:05
EXTRACT STOPPED EGGTEST1 00:00:00 5941:07:49
EXTRACT STOPPED EOLTP01 00:00:00 5941:07:49
EXTRACT STOPPED EPUMP01 00:00:00 5941:07:48
EXTRACT STOPPED HREXT 00:00:03 5941:07:46
EXTRACT STOPPED HRPUMP 00:00:00 5941:07:46
EXTRACT STOPPED MYDP1 00:00:00 5941:07:46
EXTRACT STOPPED MYEXT1 00:00:01 5941:07:44
EXTRACT STOPPED PGGTEST1 00:00:00 5941:07:43
GGSCI (node1) 5> start class_ex
Sending START request to MANAGER ...
EXTRACT CLASS_EX starting
GGSCI (node1) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:01
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:00
EXTRACT STOPPED EGGTEST1 00:00:00 5941:07:54
EXTRACT STOPPED EOLTP01 00:00:00 5941:07:54
EXTRACT STOPPED EPUMP01 00:00:00 5941:07:52
EXTRACT STOPPED HREXT 00:00:03 5941:07:51
EXTRACT STOPPED HRPUMP 00:00:00 5941:07:51
EXTRACT STOPPED MYDP1 00:00:00 5941:07:51
EXTRACT STOPPED MYEXT1 00:00:01 5941:07:49
EXTRACT STOPPED PGGTEST1 00:00:00 5941:07:48
GGSCI (node1) 7> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING CLASS_EX 00:00:00 00:00:08
EXTRACT RUNNING CLASS_PU 00:00:00 00:00:07
EXTRACT STOPPED EGGTEST1 00:00:00 5941:08:11
EXTRACT STOPPED EOLTP01 00:00:00 5941:08:11
EXTRACT STOPPED EPUMP01 00:00:00 5941:08:10
EXTRACT STOPPED HREXT 00:00:03 5941:08:08
EXTRACT STOPPED HRPUMP 00:00:00 5941:08:08
EXTRACT STOPPED MYDP1 00:00:00 5941:08:08
EXTRACT STOPPED MYEXT1 00:00:01 5941:08:06
EXTRACT STOPPED PGGTEST1 00:00:00 5941:08:05
GGSCI (node1) 8> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
No active extraction maps.
GGSCI (node1) 9> exit
$ sqlplus scott/oracle
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 28 11:57:41 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select count(*) from test;
COUNT(*)
----------
100000
SQL> delete from test;
100000 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from test;
COUNT(*)
----------
0
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ 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 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> stats class_ex
Sending STATS request to EXTRACT CLASS_EX ...
Start of Statistics at 2017-04-28 11:59:01.
Output to ./dirdat/cl:
Extracting from SCOTT.TEST to SCOTT.TEST:
*** Total statistics since 2017-04-28 11:57:56 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100000.00
Total discards 0.00
Total operations 100000.00
*** Daily statistics since 2017-04-28 11:57:56 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100000.00
Total discards 0.00
Total operations 100000.00
*** Hourly statistics since 2017-04-28 11:57:56 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100000.00
Total discards 0.00
Total operations 100000.00
*** Latest statistics since 2017-04-28 11:57:56 ***
Total inserts 0.00
Total updates 0.00
Total deletes 100000.00
Total discards 0.00
Total operations 100000.00
End of Statistics.
2017/4/29 0:00:00
页:
[1]