When you say ‘flick the fuse up’ I think you are referring to the Crabtree Unit between the meter and the consumer unit.
If so - that is also an RCD - not sure why it is there though, as the circuits in the photo are protected by the RCD in the consumer unit.
Maybe there are other circuits in the consumer unit that are labelled ‘non RCD protected’ and someone has put this Crabtree ‘upfront’ RCCB (RCD) in?
It’s not a great idea to have an upfront RCD - as you have found out - as one faulty appliace leaking to earth will take out the whole house.
I agree with others that you should call an electrician to test the circuit, check the connections at the cooker connection unit, check the wiring is of a
suitable size, check the RCD etc.
The same electrician may well be able to remove that upfront RCD as well, depending on what they find.
Maybe a stand off picture of the whole consumer unit?