A major operation is underway to rescue locals trapped on the roofs as a "one-in-500-year" flood wreaks havoc across the New South Wales Mid North Coast and Hunter areas.