[ORACLE] Monitor DG lag

Monitor DG LAG

[ORACLE] Dulicate noopen

Scripte de restore de base de données Oracle via Duplicate noopen

 

 cat .dba
sys:<mdp sys>

[ORACLE] Restore

Script de restore d'une instance Oracle

[ORACLE] BACKUP

If the PDB$SEED is not updated then the  INCR BACKUP LVL 0 rman does not backup it.

 

To prevent this and to get each time you perform the INCR BACKUP LVL 0 the content of the datafiles of the PDB$SEED, here is the command to run : 

[ORACLE] Check DB Activity HTML version

check_db_activity_html.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a HTML file.

[ORACLE] Check DB Activity

check_db_activity.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a timestamped log file.

[ORACLE] Diagnostic from the PID (top CPU) -> output HTML file

Output file generated : HTML file.

 

# Auto-detect top CPU process and generate HTML file in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"

[ORACLE] Diagnostic from the PID (top CPU) -> output logfile

Output file generated : log file.

 

# Auto-detect top CPU process and generate logfile  in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"

[PostgreSQL]pg_auto_failover

A tester et à compléter 

 

[POSTGRESQL] Les extensions indispensables

Pg_stat_statement

Pg_store_plan 

Pgsentinel

• pg_buffercache : état du cache
• pgstattuple (fragmentation des tables et index)
• Autoexplain

Source : https://public.dalibo.com/exports/formation/manuels/modules/x1/x1.handout.html