Skip to content

Instantly share code, notes, and snippets.

@dincosman
Last active October 7, 2023 06:28
Show Gist options
  • Select an option

  • Save dincosman/607629856bf6cfacc8bd83ab6a8b0099 to your computer and use it in GitHub Desktop.

Select an option

Save dincosman/607629856bf6cfacc8bd83ab6a8b0099 to your computer and use it in GitHub Desktop.
Alert log of sampledb
[oracle@bltdb01 trace]$ vi $ORACLE_BASE/diag/rdbms/clouddg/clouddg1/trace/alert_clouddg1.log
...
2022-02-22T13:22:57.223935+03:00
ARC4 (PID:19605): Archived Log entry 59912 added for T-1.S-40494 ID 0x79b8ac20 LAD:1
2022-02-22T13:29:06.766088+03:00
Warning: VKTM detected a forward time drift.
2022-02-22T13:29:07.895922+03:00
Time drifts can result in unexpected behavior such as time-outs.
Please see the VKTM trace file for more details:
/u01/app/oracle/diag/rdbms/clouddg/clouddg1/trace/clouddg1_vktm_18186.trc
2022-02-22T13:29:14.051676+03:00
rfs (PID:21834): Possible network disconnect with primary database
2022-02-22T13:29:16.020365+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 14 secs.
2022-02-22T13:29:16.020486+03:00
LGWR (ospid: 18286) is hung in an acceptable location (inwait 0x1.ffff).
2022-02-22T13:29:17.310015+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 98 secs.
2022-02-22T13:29:26.992888+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 108 secs.
GES: System Load is HIGH.
GES: Current load is 205.25 and high load threshold is 60.00
2022-02-22T13:30:37.076993+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 178 secs.
2022-02-22T13:30:47.036633+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 188 secs.
2022-02-22T13:30:57.116521+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 198 secs.
2022-02-22T13:31:07.045602+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 208 secs.
2022-02-22T13:31:17.124637+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 218 secs.
2022-02-22T13:31:27.068715+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 228 secs.
2022-02-22T13:31:37.012616+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 238 secs.
2022-02-22T13:31:47.092550+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 248 secs.
2022-02-22T13:31:57.028611+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 258 secs.
2022-02-22T13:32:07.110413+03:00
LGWR (ospid: 18286) waits for event 'reliable message' for 268 secs.
2022-02-22T13:32:07.818327+03:00
Increasing priority of 2 RS
Reconfiguration started (old inc 43, new inc 45)
List of instances (total 1) :
1
Dead instances (total 1) :
2
My inst 1
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
2022-02-22T13:32:08.011516+03:00
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment