There are what look like mice dropping in my loft, but actually they come from bats. As far as I know, bats do not eat cables?
The disconnecting of chunks of wiring to me is easy, the hardest job it is getting up again after getting down to wiring levels, but the work to me seems simple, but that is because I have spent most of my life as an electrician.
The hard bit is to tell someone else how to do the work. The difference between using a multi-meter to test ohms with a 9 volt battery, and an insulation tester, which has an inverter built in and used 250/500/1000 volts to test, is in some cases massive, I remember testing a motor in a compressor for a friend, multi-meter showed infinity, it ruptured a fuse, re-tested with 500 volts, and it showed dead short.
So you know you have a fault, if the multimeter shows a fault, then you can use it to find the fault, if it shows open circuit, then the multimeter will not help.
In the main, we are looking at water, be it a leak, or in some animal's body, even a spider can sometimes trip a RCD/RCBO. The other cause is vibration, insulation can wear through, but that is more unusual. We tend to look at likely places first, outside lights for example, but if that fails, then we have to work step by step moving slowly to or away from the consumer unit, the logical method is to split it in half, but that only work if we have a way to test.
So for me, guess around halfway around your lights, and test each half with the insulation tester, then take the bad half, and split that again half way, and test again, but without the insulation tester, that is not so easy, but you can still move ceiling rose to ceiling rose, connecting and disconnecting more or less of the circuit, where the problem lies, is you can cure the problem without realising you have cured it, or introduce more problems, and so one has to assess the skill of the tester, will the process of testing make it worse?