John Osbourne (aka Ozzy Osbourne) was arrested by Memphis cops in May 1984 and charged with public intoxication. According to the police report, Ozzy was "staggering drunk" when nabbed on raucous Beale Street.
Robert James Ritchie (aka Kid Rock) was arrested by Michigan cops in March 1991 and September 1997. Both arrests were alcohol related, though dispositions are unclear.