Wrong-way alarms are installed on engines that are direct drive, reversing types (maybe also on diesel-electric plants with drive motors). This includes the main engine found on the vast majority of modern container ships, bulkers, tankers, ro/ro's, etc. Generally, these engines drive fixed pitch propellers. The alarm is activated if, for any reason, the engine is started and run in the opposite direction of the order from the bridge, whether this is through the bridge controls or the emergency order telegraph (in which case, an engineer is controlling the engine). The alarm sounds at the engine control stand, engine control room and on the bridge. Now, I'm not an engineer, but from what I understand the only real way the engine can be started the "wrong way" (aside from an engineer who's controlling it to goof up) is if the start air distributor has a malfunction and the start air timing is locked in the opposite direction of where you want it. That and the camshaft is locked in the wrong direction too - probably not an issue on the new common rail designs.
Also, shifting gears but somewhat related, some controllable pitch systems resort to a full astern pitch if they lose hydraulic pressure. I think some WA State Ferries had this problem a couple decades back when they "randomly" backed out of their slips. That might be a legend though...