goldengate 源端open resetlogs 后的处理测试

dongxujian

[BEGIN] 2017/4/28 23:23:31
GGSCI (node1) 12> info all

Program    Status    Group    Lag at Chkpt  Time 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_EX  Last Started 2017-04-28 11:22 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:00:08 ago)
Process ID          2636
Log Read Checkpoint  Oracle Redo Logs
                  2017-04-28 11:22:42  Seqno 204, RBA 9132032
                  SCN 0.2379392 (2379392)

GGSCI (node1) 14> lag class_ex

2017-04-28 11:23:50  INFO OGG-14054  Lag 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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 Chkpt  Time 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 Chkpt  Time 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
[oracle@node1 goldengate]$ 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
  2  for i in 1 .. 100000
  3  loop
  4  insert into test values (i,to_char(i),to_char(i));
  5  commit;
  6  end loop;
  7  end;
  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
  1  begin
  2  for i in 2 .. 100000
  3  loop
  4  insert into test values (i,to_char(i),to_char(i));
  5  commit;
  6  end 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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 Chkpt  Time 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 Chkpt  Time 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_EX  Last Started 2017-04-28 11:34 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:00:09 ago)
Process ID          2852
Log Read Checkpoint  Oracle Redo Logs
                  2017-04-28 11:26:30  Seqno 204, RBA 9220608
                  SCN 0.2379514 (2379514)

GGSCI (node1) 10> info class_pu

EXTRACT CLASS_PU  Last Started 2017-04-28 11:34 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:00:04 ago)
Process ID          2864
Log Read Checkpoint  File ./dirdat/cl000000074
                  2017-04-28 11:34:53.207817  RBA 1446

GGSCI (node1) 11> send class_ex status

Sending STATUS request to EXTRACT CLASS_EX ...

EXTRACT CLASS_EX (PID 2852)
  Current status: In recovery[1]: 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ cd /u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28/
[oracle@node1 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.

[oracle@node1 2017_04_28]$ mv o1_mf_1_204_dj6r1r7l_.arc 1_204_942492778.dbf
[oracle@node1 2017_04_28]$ mv o1_mf_1_205_dj6r20ny_.arc 1_205_942492778.dbf
[oracle@node1 2017_04_28]$ mv o1_mf_1_206_dj6r5bq7_.arc 1_206_942492778.dbf

[oracle@node1 goldengate]$ 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 STATUS  RESETLOGS_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

[oracle@node1 2017_04_28]$ pwd
/u01/app/oracle/fast_recovery_area/ORCC1/archivelog/2017_04_28
[oracle@node1 2017_04_28]$ cd $GGHOME
[oracle@node1 goldengate]$ 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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_EX  Last Started 2017-04-28 11:52 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:00:06 ago)
Process ID          3003
Log Read Checkpoint  Oracle Redo Logs
                  2017-04-28 11:31:56  Seqno 206, RBA 37306368
                  SCN 0.2582146 (2582146)

GGSCI (node1) 18> lag class_ex

2017-04-28 11:52:58  INFO OGG-14054  Lag 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 Chkpt  Time 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_EX  Last Started 2017-04-28 11:52 Status RUNNING
Checkpoint Lag    00:00:00 (updated 00:00:08 ago) **************************
Process ID          3003
Log Read Checkpoint  Oracle Redo Logs
                  2017-04-28 11:31:56  Seqno 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 Chkpt  Time 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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 Chkpt  Time 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_EX  Initialized 2017-04-28 11:56 Status STOPPED
Checkpoint Lag    00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint  Oracle Redo Logs
                  First Record       Seqno 1, RBA 0
                  SCN 0.0 (0)

GGSCI (node1) 4> info all

Program    Status    Group    Lag at Chkpt  Time 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 Chkpt  Time 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 Chkpt  Time 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
[oracle@node1 goldengate]$ 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
[oracle@node1 goldengate]$ 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.

[END] 2017/4/29 0:00:00

图文精华

goldengate 源端open resetlogs 后的处理测试