Corkman John Holland has given host nation Greece what he narrowly failed to secure for Ireland at Atlanta 1996 - a first ever Olympic rowing medal.