FAQ LOGDUMP

Purpose

Questions and Answers

1. What is the Logdump utility and when to use it?

3. How to filter based on a table name?

4. How to remove the current filter criteria?

5. How to filter on multiple conditions?

6. How to use logdump to get table record counts?

7. How to manually load balance across multiple processes

8. How to check the records in an encrypted tail file

9. What are the known problem on logdump ?

10. How to trace a transaction from trail back to redo log in Oracle DB ?

11. How to use logdump in finding records that will be duplicated to avoid duplicate processing for records already processed by the reader (Datapump or Replicat)

12. How ro use the logdump to alter the read position of the data pump in the local trail ?

13. Is there is a script to display the contents of the source and target tables, display one of the trail files by usig logdump?

14. How to look at the trail that Extract was reading and determine where the end of that LOB fragment ends.

15. How to trace transaction from GGS trail back to Oracle redo log?

@ 16. How to view transaction boundaries and type in logdump

@ 17. How to turn the auditRBA and auditPos lrom logdump into an LSN?

References

 

——————————————————————————–

 

 

Applies to:

Oracle GoldenGate – Version 9.5.0.0 to 11.2.0.0.0 [Release 9.5.0 to 11.2]

Information in this document applies to any platform.

 

Purpose

This document is intended to answer Frequently Asked Questions about Oracle GoldenGate Logdump.

 

 

 

Ask Questions, Get Help, And Share Your Experiences With This Article

 

 

 

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

 

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for GoldenGate, Streams and Distributed Database.

 

 

 

 

Questions and Answers

1. What is the Logdump utility and when to use it?

Logdump is an utility of Oracle GoldenGate that enables you to search for, filter, view, and save data that is stored in a trail or extract file. 2. How to use Logdump utility to perform a saving portion of a trail to a new trail? To save records to a new trail file To save the whole file:

 

Logdump 68> SAVE <file>

 

Where: <file> is the name of the new file.

To save a subset of records:

 

Logdump 69> SAVE <file> <n> RECORDS

 

Note 966188.1 How To Save A Part Of A GoldenGate Trail To A New Trail

 

3. How to filter based on a table name?

To filter out everything except records containing a specific table name:

 

Logdump 60> FILTER INCLUDE FILENAME <schema>.<table>

 

Now, when you use the N command, you will only see records that satisfy this filter.

Conversely, to filter out records containing a specific table name, but show everything

else, use the EXCLUDE option instead of INCLUDE.

 

Note 1450495.1 Master Note for Oracle GoldenGate for Filtering and Transformation Data.

 

4. How to remove the current filter criteria?

Logdump 62> FILTER CLEAR5. How to filter on multiple conditions?

Logdump 65> FILTER INCLUDE FILENAME <schema>.<table>; FILTER RECTYPE

<record_type>; FILTER MATCH ALL

 

Use MATCH ANY or MATCH ALL depending on whether you want the search to match any or

all of the filter conditions, respectively, when multiple conditions are specified. The

preceding example filters on a name and record type, typically an operation type such

as INSERT

 

6. How to use logdump to get table record counts?

 

 

LOGDUMP>filter filename {table name in Uppercase}

This will list record and the total operations for a specific table in the trail.

 

 

Note 1428422.1 How to Use OGG Logdump To Get Table Record Counts

 

7. How to manually load balance across multiple processes

For dailed informatio, please refer to:

 

Note 1301300.1 Oracle GoldenGate – Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes

 

8. How to check the records in an encrypted tail file

For dailed informatio, please refer to:

 

Note 1351522.1 How to Check the Records in an Encrypted Trail File by Using OGG Logdump Utility

 

9. What are the known problem on logdump ?

Note 1402388.1 GoldenGate Logdump COUNT INTERVAL Output is not Consistent

 

10. How to trace a transaction from trail back to redo log in Oracle DB ?

For dailed informatio, please refer to:

 

Note 1359141.1 OGG How To Trace A Transaction From Trail Back To Redo Log In Oracle DB

 

11. How to use logdump in finding records that will be duplicated to avoid duplicate processing for records already processed by the reader (Datapump or Replicat)

Note 1138409.1 OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE

 

12. How ro use the logdump to alter the read position of the data pump in the local trail ?

For dailed informatio, please refer to:

 

Note 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error

 

13. Is there is a script to display the contents of the source and target tables, display one of the trail files by usig logdump?

You can use the file ccc located in :

 

Note 1081322.1 Configuring Oracle GoldenGate for Partitioned Replication

 

14. How to look at the trail that Extract was reading and determine where the end of that LOB fragment ends.

For dailed informatio, please refer to:

 

Note 966223.1 The Reposition And Restart Of OGG Extract Pump or Replicat Gives Error 590 Unexpected LOB?

 

15. How to trace transaction from GGS trail back to Oracle redo log?

For dailed informatio, please refer to:

 

Note 1060533.1 How To Trace Transaction From Trail Back To Redo Log

 

@ 16. How to view transaction boundaries and type in logdump

 

For dailed informatio, please refer to:[This section is not visible to customers.]

 

 

Note 968618.1 OGG How Can I View Transaction Boundaries And Type In Logdump?[This section is not visible to customers.]

 

 

@ 17. How to turn the auditRBA and auditPos lrom logdump into an LSN?

 

For dailed informatio, please refer to:[This section is not visible to customers.]

 

 

Note 1063128.1 How Do I Turn The AuditRBA And AuditPos From Logdump Into An LSN?[This section is not visible to customers.]

 

 

References

NOTE:1428422.1 – How to Use OGG Logdump To Get Table Record Counts

NOTE:1450495.1 – Master Note for Oracle GoldenGate for Filtering and Transformation Data

NOTE:966223.1 – The Reposition And Restart Of OGG Extract Pump or Replicat Gives Error 590 Unexpected LOB?

NOTE:968618.1 – OGG How Can I View Transaction Boundaries And Type In Logdump?

NOTE:1351522.1 – How to Check the Records in an Encrypted Trail File by Using OGG Logdump Utility

NOTE:1301300.1 – Oracle GoldenGate – Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes

NOTE:1380230.1 – GoldenGate Trail Has Null or Unknown Values for @GETENV (“TRANSACTION”, “USERNAME”) Token

NOTE:1360967.1 – OGG Replicat passing NULL values for “XID” or “CSN” tokens

NOTE:1138409.1 – OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE

NOTE:1081322.1 – Configuring Oracle GoldenGate for Partitioned Replication

NOTE:957053.1 – Recovering From a GG Pump Process Abending With An Incompatible Record Error

NOTE:1359141.1 – OGG How To Trace A Transaction From Trail Back To Redo Log In Oracle DB


 

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Esse post foi publicado em GOLDENGATE. Bookmark o link permanente.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s