Figuring out a hole is easy. What I want to know is why in the hell do you have water pipes in an attic that can freeze? Get the pipes out of the attic.

Sorry I live in Canada and water pipes in the attic space or in outside wall space is not accepted

Don't bother fixing the ceiling until you get rid of water pipes unless you like a redo every year.