Detalhes do Serviço GoldenGate

Detalhes de log para logs GoldenGate.

Recursos

Implantações GoldenGate

Categoria de Log


Valor da API (ID):	Console (Nome para Exibição)	Descrição
process_logs	Processar	Contém conteúdo de vários arquivos de log para o Administration Service, Distribution Service, Performance Metrics Service, Receiver Service e Extrair/Replicar Eventos.
error_logs	Erro	Contém conteúdo do arquivo `ggserr.log` que registra eventos de processamento, mensagens, erros e avisos gerados por GoldenGate.

Disponibilidade

O registro em log do GoldenGate está disponível em todas as regiões dos realms comerciais.

Comentários

Você pode ativar logs de Processo e Erro para uma implantação específica.

Conteúdo dos Logs de Processo e Erro do GoldenGate


Propriedade	Descrição
level	Nível de log da mensagem, como INFO, DEBUG, ERROR.
message	Descreve os detalhes do evento.
processName	(Somente Logs de Processo) Nome do processo do Oracle GoldenGate gravando no log.
resourceId	OCID da implantação GoldenGate.

Exemplo de Log de Processo GoldenGate

{
  "ts": "2023-05-25T09:27:28.219Z",
  "source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
  "id": "<unique_ID>.<unique_ID>",
  "oracle": {
    "compartmentid": "ocid1.compartment.oc1..<unique_ID>",
    "logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
  },
  "specversion": "1.0",
  "type": "com.oraclecloud.goldengate.deployment.process_logs",
  "data": {
    "message": "Rollback transaction 0x00002987",
    "level": "WARN",
    "resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
    "processName": "pmsrvr"
  }
}
 
{
  "time": "2023-05-25T09:21:05.192Z",
  "source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
  "id": "<unique_ID>.<unique_ID>",
  "oracle": {
    "compartmentid": "ocid1.compartment.oc1..<unique_ID>",
    "logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
  },
  "specversion": "1.0",
  "type": "com.oraclecloud.goldengate.deployment.process_logs",
  "data": {
    "message": "CSRFTokenProtection: ENABLED.\nCross-Site Request Forgery checks using CSRF-Tokens will be performed.",
    "level": "INFO",
    "resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
    "processName": "distsrvr"
  }
}

Exemplo de Log de Erros GoldenGate

{
  "time": "2023-05-25T09:22:48.202Z",
  "source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
  "id": "<unique_ID>.<unique_ID>",
  "oracle": {
    "compartmentid": "ocid1.compartment.oc1..<unique_ID>",
    "logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
  },
  "specversion": "1.0",
  "type": "com.oraclecloud.goldengate.deployment.error_logs",
  "data": {
    "message": "INFO    OGG-03541  Oracle GoldenGate Capture for Oracle:  Oracle Environment Variables: \nTNS_ADMIN = /u02/Deployment/etc\nLD_LIBRARY_PATH = 
     /usr/lib64/<user_ID>/test-ee-java8/jre/lib/amd64/server:/usr/lib64/<user_ID>/test-ee-java8/jre/lib/amd64/server:.",
    "level": "INFO",
    "resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>"
  }
}
 
{
  "time": "2023-05-25T09:22:48.815Z",
  "source": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>",
  "id": "<unique_ID>.<unique_ID>",
  "oracle": {
    "compartmentid": "ocid1.compartment.oc1..<unique_ID>",
    "logid": "ocid1.log.oc1.us-sanjose-1.<unique_ID>"
  },
  "specversion": "1.0",
  "type": "com.oraclecloud.goldengate.deployment.error_logs",
  "data": {
    "message": "ERROR   OGG-00053  Oracle GoldenGate Capture for Oracle:  No extraction maps specified.",
    "level": "ERROR",
    "resourceId": "ocid1.goldengatedeployment.oc1.us-sanjose-1.<unique_ID>"
  }
}

Documentação do Oracle Cloud Infrastructure