Heavy rains caused flooding in Australia's Sydney sparking warning of the residents to evacuate to higher grounds, says report.