The drought-stricken Northern Cape experienced some relief as heavy rainfall caused rivers and dams to overflow