Skip to main content
HashnodeCarla Muñoz López

Command Palette

Search for a command to run...

tfactl managelogs: Gestión Eficiente de Logs en Oracle

Updated
•10 min read•View as Markdown
tfactl managelogs: Gestión Eficiente de Logs en Oracle
C
Carla Muñoz López

Mi nombre es Carla y me defino como una apasionada de conocer, compartir ideas, divertirme y aprender todo lo relacionado con Oracle.

Alegre y creativa, con un alto grado de autoexigencia, que busca, incluso sin querer, una forma diferente de ver un mismo problema o solución. Defensora del trabajo en equipo en todas las facetas de la vida y de disfrutar todo lo que haces, siempre con humildad.

Actualmente cuento con más de 15 años de experiencia como administradora de Oracle, habiendo ocupado previamente posiciones como desarrolladora en la rama de Inteligencia de Negocios. Fue en ese momento que me di cuenta de que no quería centrarme en el desarrollo, sino participar en todas las capas que involucraban los datos, desde el despliegue de la base de datos hasta su explotación final.

Siempre estoy dispuesta a ayudar y compartir conocimientos. Creo firmemente que con la tecnología hay que divertirse y no verla como una competencia. La persona con la que tienes que ser el mejor es contigo mismo.

En entornos complejos como los de Oracle, el almacenamiento de logs de diagnóstico es crucial para mantener la estabilidad y realizar una correcta depuración del sistema. Sin embargo, estos logs pueden ocupar rápidamente grandes cantidades de espacio en disco.

Para ayudar a gestionar esto, Oracle ofrece la utilidad tfactl, una herramienta incluida en Oracle Trace File Analyzer (TFA), que automatiza la recolección, análisis y administración de logs en sistemas de Oracle.

Este comando es muy útil en tareas de mantenimiento y forma parte de las mejores prácticas de administración en entornos Oracle para mantener el sistema limpio y optimizado.


[root@rac-xxx-001 ~]# /opt/oracle.ahf/tfa/bin/tfactl managelogs -show usage


Output from host : rac-xxx-001
------------------------------
2024-11-08 13:48:33: WARNING Component : +APX not found on host : rac-xxx-001

.------------------------------------------------------------------------------.
|                           Grid Infrastructure Usage                          |
+-----------------------------------------------------------------+------------+
| Location                                                        | Size       |
+-----------------------------------------------------------------+------------+
| /u01/app/grid/diag/crs/rac-xxx-001/crs/alert                    | 2.75 MB    |
| /u01/app/grid/diag/crs/rac-xxx-001/crs/incident                 | 0 bytes    |
| /u01/app/grid/diag/crs/rac-xxx-001/crs/trace                    | 4.72 GB    |
| /u01/app/grid/diag/crs/rac-xxx-001/crs/cdump                    | 0 bytes    |
| /u01/app/grid/diag/crs/rac-xxx-001/crs/log                      | 0 bytes    |
|| /u01/app/grid/diag/asm/+asm/+ASM1/alert                         | 12.52 MB   |
| /u01/app/grid/diag/asm/+asm/+ASM1/incident                      | 0 bytes    |
| /u01/app/grid/diag/asm/+asm/+ASM1/trace                         | 109.94 MB  |
| /u01/app/grid/diag/asm/+asm/+ASM1/cdump                         | 0 bytes    |
| /u01/app/grid/diag/asm/+asm/+ASM1/hm                            | 0 bytes    |
| /u01/app/grid/diag/asm/+asm/+ASM1/log                           | 48.00 KB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/asmnet1lsnr_asm/alert    | 1.96 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/asmnet1lsnr_asm/incident | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/asmnet1lsnr_asm/trace    | 1.09 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/asmnet1lsnr_asm/cdump    | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/asmnet1lsnr_asm/log      | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan1/alert     | 2.02 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan1/incident  | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan1/trace     | 1008.78 MB |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan1/cdump     | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan1/log       | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan2/alert     | 2.02 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan2/incident  | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan2/trace     | 1017.27 MB |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan2/cdump     | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan2/log       | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan3/alert     | 2.09 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan3/incident  | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan3/trace     | 1.03 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan3/cdump     | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener_scan3/log       | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener/alert           | 2.14 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener/incident        | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener/trace           | 1.31 GB    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener/cdump           | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/listener/log             | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/mgmtlsnr/alert           | 140.96 MB  |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/mgmtlsnr/incident        | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/mgmtlsnr/trace           | 54.35 MB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/mgmtlsnr/cdump           | 0 bytes    |
| /u01/app/grid/diag/tnslsnr/rac-xxx-001/mgmtlsnr/log             | 0 bytes    |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/alert                  | 4.14 MB    |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/incident               | 21.25 MB   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/trace                  | 25.38 MB   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/cdump                  | 0 bytes    |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/hm                     | 0 bytes    |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/log                    | 20.00 KB   |
| /u01/app/19.24/grid/rdbms/audit                                 | 192.00 KB  |
| /u01/app/grid/admin/_mgmtdb/adump                               | 15.79 MB   |
+-----------------------------------------------------------------+------------+
| Total                                                           | 20.74 GB   |
'-----------------------------------------------------------------+------------'

.----------------------------------------------------------------.
|                      Database Homes Usage                      |
+----------------------------------------------------+-----------+
| Location                                           | Size      |
+----------------------------------------------------+-----------+
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/alert    | 78.26 MB  |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/incident | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/trace    | 112.19 MB |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/cdump    | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/hm       | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1/log      | 2.14 MB   |
| /u01/app/oracle/admin/cdbxxx/adump                 | 8.00 KB   |
+----------------------------------------------------+-----------+
| Total                                              | 192.59 MB |
'----------------------------------------------------+-----------'
2024-11-08 13:48:34: INFO HAMI is not present on rac-xxx-001.


Output from host : rac-xxx-002
------------------------------
2024-11-08 13:48:36: WARNING Component : +APX not found on host : rac-xxx-002
2024-11-08 13:48:37: WARNING Component : _mgmtdb not found on host : rac-xxx-002

.-----------------------------------------------------------------------------.
|                          Grid Infrastructure Usage                          |
+-----------------------------------------------------------------+-----------+
| Location                                                        | Size      |
+-----------------------------------------------------------------+-----------+
| /u01/app/grid/diag/crs/rac-xxx-002/crs/alert                    | 2.38 MB   |
| /u01/app/grid/diag/crs/rac-xxx-002/crs/incident                 | 0 bytes   |
| /u01/app/grid/diag/crs/rac-xxx-002/crs/trace                    | 4.31 GB   |
| /u01/app/grid/diag/crs/rac-xxx-002/crs/cdump                    | 0 bytes   |
| /u01/app/grid/diag/crs/rac-xxx-002/crs/log                      | 0 bytes   |
| /u01/app/grid/diag/asm/+asm/+ASM2/alert                         | 10.96 MB  |
| /u01/app/grid/diag/asm/+asm/+ASM2/incident                      | 0 bytes   |
| /u01/app/grid/diag/asm/+asm/+ASM2/trace                         | 101.89 MB |
| /u01/app/grid/diag/asm/+asm/+ASM2/cdump                         | 0 bytes   |
| /u01/app/grid/diag/asm/+asm/+ASM2/hm                            | 0 bytes   |
| /u01/app/grid/diag/asm/+asm/+ASM2/log                           | 48.00 KB  |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/asmnet1lsnr_asm/alert    | 2.13 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/asmnet1lsnr_asm/incident | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/asmnet1lsnr_asm/trace    | 1.10 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/asmnet1lsnr_asm/cdump    | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/asmnet1lsnr_asm/log      | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan1/alert     | 2.11 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan1/incident  | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan1/trace     | 1.05 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan1/cdump     | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan1/log       | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener/alert           | 2.11 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener/incident        | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener/trace           | 1.29 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener/cdump           | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener/log             | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/mgmtlsnr/alert           | 45.30 MB  |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/mgmtlsnr/incident        | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/mgmtlsnr/trace           | 11.97 MB  |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/mgmtlsnr/cdump           | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/mgmtlsnr/log             | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan2/alert     | 2.11 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan2/incident  | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan2/trace     | 1.05 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan2/cdump     | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan2/log       | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan3/alert     | 2.05 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan3/incident  | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan3/trace     | 1.00 GB   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan3/cdump     | 0 bytes   |
| /u01/app/grid/diag/tnslsnr/rac-xxx-002/listener_scan3/log       | 0 bytes   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/alert                  | 14.82 MB  |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/incident               | 0 bytes   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/trace                  | 17.23 MB  |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/cdump                  | 0 bytes   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/hm                     | 0 bytes   |
| /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/log                    | 24.00 KB  |
| /u01/app/19.24/grid/rdbms/audit                                 | 104.00 KB |
+-----------------------------------------------------------------+-----------+
| Total                                                           | 20.51 GB  |
'-----------------------------------------------------------------+-----------'

.----------------------------------------------------------------.
|                      Database Homes Usage                      |
+----------------------------------------------------+-----------+
| Location                                           | Size      |
+----------------------------------------------------+-----------+
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/alert    | 45.89 MB  |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/incident | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/trace    | 99.82 MB  |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/cdump    | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/hm       | 0 bytes   |
| /u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2/log      | 1.89 MB   |
| /u01/app/oracle/admin/cdbxxx/adump                 | 0 bytes   |
+----------------------------------------------------+-----------+
| Total                                              | 147.61 MB |
'----------------------------------------------------+-----------'
2024-11-08 13:48:37: INFO HAMI is not present on rac-xxx-002.

Y si delegamos en esta utilidad la limpieza de trazas? Para ello he desarrollado un script donde podremos planificarlo en ambos nodos del RAC en este caso, realizando la limpieza únicamente desde el máster y enviándonos un correo de resumen.

[root@rac-xxx-002 ~]# cat /u01/scripts/admin/limpieza_logs.sh
#!/bin/bash
export PATH=$PATH:/usr/local/bin:/bin:/usr/bin

# Configuración de entorno Oracle
export ORAENV_ASK=NO
export ORACLE_SID=+ASM1
. oraenv

# Variables de configuración
export LOG_DIR=/u01/scripts/admin/logs
export MASTER_NODE=$(oclumon manage -get master | grep Master | awk '{print $3}' | cut -d "." -f1 | sed -e 's/\(.*\)/\U\1/')
export HOST=$(echo $HOSTNAME | cut -d "." -f1 | sed -e 's/\(.*\)/\U\1/')
EMAIL="xxxxxxx@xxxxxx.xxx"
FECHA_LOG=$(date +'%Y%m%d_%H%M%S')
LOGFILE="$LOG_DIR/limpieza_logs_$FECHA_LOG.log"

# Función para enviar correo
send_email() {
    local subject="$1"
    local message="$2"
    mutt -s "$subject" "$EMAIL" < "$LOGFILE"
}

# Función para limpiar logs antiguos (más de 30 días)
clean_old_logs() {
    find "$LOG_DIR" -type f -name "limpieza_logs_*.log" -mtime +30 -exec rm -f {} \;
}

# Comprobar si estamos en el nodo maestro
if [ "$HOST" == "$MASTER_NODE" ]; then
    echo "[$(date +'%Y-%m-%d %H:%M:%S')] Iniciando Limpieza de logs" >> "$LOGFILE"

    /opt/oracle.ahf/tfa/bin/tfactl managelogs -purge -older 90d >> "$LOGFILE" 2>&1

    # Limpiar logs antiguos
    clean_old_logs
    echo "[$(date +'%Y-%m-%d %H:%M:%S')] Logs antiguos eliminados" >> "$LOGFILE"

    # Enviar correo de éxito
    message="Limpieza de logs realizada correctamente. Ver detalles en $LOGFILE."
    send_email "Limpieza de logs OK" "$message"
else
    echo "[$(date +'%Y-%m-%d %H:%M:%S')] Nodo actual no es el nodo maestro" >> "$LOGFILE"
    message="Este nodo ($HOST) no es el nodo maestro. No se realizó la limpieza de logs."
fi

Únicamente nos quedará planificarlo en el cron, como root y despreocuparse.

Ejemplo salida de log que nos remitirá por correo:

[root@racxxx002 ~]# cat /u01/scripts/admin/logs/limpieza_logs_20241108_135700.log
[2024-11-08 13:57:00] Iniciando Limpieza de logs


Output from host : racxxx002
------------------------------
2024-11-08 13:57:03: INFO Purging files older than 90 days

2024-11-08 13:57:03: INFO Space is calculated in bytes [without round off]

2024-11-08 13:57:03: INFO Cleaning Grid Infrastructure ADR Destinations

2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/crs/racxxx002/crs" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/asm/+asm/+ASM2" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/asmnet1lsnr_asm" Purged: - 5 files deleted , 1000.00 MB space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/listener_scan1" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/listener" Purged: - 8 files deleted , 1.56 GB space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/mgmtlsnr" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/listener_scan2" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx002/listener_scan3" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:04: INFO Diagnostic Destination "/u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB" Purged: - 1 files deleted , 10.00 MB space recovered
2024-11-08 13:57:04: INFO Not purging Audit Dump destination, managelogs.adump is disabled

2024-11-08 13:57:04: MESSAGE Diagnostic Destinations for GI Home Purged: - 14 files deleted , 2.55 GB space recovered

2024-11-08 13:57:04: MESSAGE Calculating Filesystem Before/After Sizes...

    ==== Grid Infrastructure ADR Filesystem(s) Size Summary ====

.------------------------------------------------------------------------------------------.
|                       File System Variation for Path: /u01/app/grid                      |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| State  | Name                      | Size      | Used     | Free      | Capacity | Mount |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| Before | /dev/mapper/vgsistema-u01 | 209612800 | 77920684 | 131692116 |      38% | /u01  |
| After  | /dev/mapper/vgsistema-u01 | 209612800 | 75248704 | 134364096 |      36% | /u01  |
'--------+---------------------------+-----------+----------+-----------+----------+-------'

2024-11-08 13:57:04: MESSAGE Cleaning Database ADR Destinations for Database : cdbxxx
2024-11-08 13:57:05: INFO Diagnostic Destination "/u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx2" Purged: - 0 files deleted , 0 bytes space recovered

2024-11-08 13:57:05: INFO Not purging Audit Dump destination, managelogs.adump is disabled

2024-11-08 13:57:05: MESSAGE Diagnostic Destinations for Database Home(s) Purged: - 0 files deleted , 0 bytes space recovered

2024-11-08 13:57:05: MESSAGE Calculating Filesystem Before/After Sizes...

    ==== Database Home(s) ADR Filesystem(s) Size Summary ====

.------------------------------------------------------------------------------------------.
|                      File System Variation for Path: /u01/app/oracle                     |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| State  | Name                      | Size      | Used     | Free      | Capacity | Mount |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| Before | /dev/mapper/vgsistema-u01 | 209612800 | 75248704 | 134364096 |      36% | /u01  |
| After  | /dev/mapper/vgsistema-u01 | 209612800 | 75248704 | 134364096 |      36% | /u01  |
'--------+---------------------------+-----------+----------+-----------+----------+-------'

2024-11-08 13:57:05: INFO HAMI is not present on racxxx002.


Output from host : racxxx001
------------------------------
2024-11-08 13:57:06: INFO Purging files older than 90 days

2024-11-08 13:57:06: INFO Space is calculated in bytes [without round off]

2024-11-08 13:57:06: INFO Cleaning Grid Infrastructure ADR Destinations

2024-11-08 13:57:06: INFO Diagnostic Destination "/u01/app/grid/diag/crs/racxxx001/crs" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:06: INFO Diagnostic Destination "/u01/app/grid/diag/asm/+asm/+ASM1" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:06: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/asmnet1lsnr_asm" Purged: - 5 files deleted , 1000.00 MB space recovered
2024-11-08 13:57:06: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/listener_scan1" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/listener_scan2" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/listener_scan3" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/listener" Purged: - 8 files deleted , 1.56 GB space recovered
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/grid/diag/tnslsnr/racxxx001/mgmtlsnr" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB" Purged: - 0 files deleted , 0 bytes space recovered
2024-11-08 13:57:07: INFO Not purging Audit Dump destination, managelogs.adump is disabled

2024-11-08 13:57:07: MESSAGE Diagnostic Destinations for GI Home Purged: - 13 files deleted , 2.54 GB space recovered

2024-11-08 13:57:07: MESSAGE Calculating Filesystem Before/After Sizes...

    ==== Grid Infrastructure ADR Filesystem(s) Size Summary ====

.------------------------------------------------------------------------------------------.
|                       File System Variation for Path: /u01/app/grid                      |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| State  | Name                      | Size      | Used     | Free      | Capacity | Mount |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| Before | /dev/mapper/vgsistema-u01 | 209612800 | 89963340 | 119649460 |      43% | /u01  |
| After  | /dev/mapper/vgsistema-u01 | 209612800 | 87300904 | 122311896 |      42% | /u01  |
'--------+---------------------------+-----------+----------+-----------+----------+-------'

2024-11-08 13:57:07: MESSAGE Cleaning Database ADR Destinations for Database : cdbxxx
2024-11-08 13:57:07: INFO Diagnostic Destination "/u01/app/oracle/diag/rdbms/cdbxxx/cdbxxx1" Purged: - 0 files deleted , 0 bytes space recovered

2024-11-08 13:57:07: INFO Not purging Audit Dump destination, managelogs.adump is disabled

2024-11-08 13:57:07: MESSAGE Diagnostic Destinations for Database Home(s) Purged: - 0 files deleted , 0 bytes space recovered

2024-11-08 13:57:07: MESSAGE Calculating Filesystem Before/After Sizes...

    ==== Database Home(s) ADR Filesystem(s) Size Summary ====

.------------------------------------------------------------------------------------------.
|                      File System Variation for Path: /u01/app/oracle                     |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| State  | Name                      | Size      | Used     | Free      | Capacity | Mount |
+--------+---------------------------+-----------+----------+-----------+----------+-------+
| Before | /dev/mapper/vgsistema-u01 | 209612800 | 87300904 | 122311896 |      42% | /u01  |
| After  | /dev/mapper/vgsistema-u01 | 209612800 | 87300952 | 122311848 |      42% | /u01  |
'--------+---------------------------+-----------+----------+-----------+----------+-------'

2024-11-08 13:57:07: INFO HAMI is not present on racxxx001.
[2024-11-08 13:57:07] Logs antiguos eliminados

Interesante a investigar para mejoras…

2024-11-08 13:57:04: INFO Not purging Audit Dump destination, managelogs.adump is disabled

un saludo

#oracletfa#oracle

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Carla Muñoz López

65 posts

Soy DBA senior de bases de datos Oracle y me defino como una persona alegre y creativa. Apasionada por conocer, compartir ideas, divertirme y seguir aprendiendo todo lo relacionado con Oracle.