Usually ECC memory is used in servers and not desktop workstations. However, Ryzen supports it, unlike Intel desktop CPUs. Except Ryzen non-Pro APUs (those with integrated graphics), don't have ECC support. The mainboard also has to support it and luckily most Asrock, Asus and some Gigabytes do. Please note that the ECC functionality has nothing directly to do with being registered and memory for Ryzen still has to be unregistered/unbuffered like in a normal desktop build.
The most common type of ECC memory has single-error correction and double-error detection (SECDED). Correctable 1-bit errors are corrected automatically. If an uncorrectable 2-bit error occurs, Linux will kill the process the memory is assigned to, while Windows goes straight to a BSOD stating an uncorrectable error occurred.
A small benefit of this compared to non-ECC memory is that obviously occasional 1-bit errors have no effect instead of the chance of silently corrupting data. However, errors should be incredible rare for stable cloc