If it's a quiet show, most of the AT853 or CA type mics will do it with the something like 3 volts of plug-in-power of the R09HR. When it gets louder, most of them will start to brickwall, and need a 9V battery box or preamp.
So if you want to record James Taylor, you can probably run most mics > R09 mic-in. If you want to record Megadeth, then you need the battery box/preamp.
Or possibly that's not the answer you were looking for. Yes, there probably are some particular mics (or modified ones) that you can run mic-in for Megadeth, but since you didn't ask that question, I'm not sure.
The other side of the equation is that once it gets loud, sensitive mics run "mic in" might overload the recorder. This is why people traditionally switch to line-in, at which point you add a battery box to power the mics.