Yes you do. My husband is a recovering alcoholic been sober for 31 years. It is not an easy journey and he had to work hard to kick it. He went to AA and had counseling and now he is a licensed clinical social worker and drug/alcohol counselor. He wants to give back because he was helped. It is hard enough to beat alcoholism but with cancer simultaneously, it is almost impossible to stay focused. Have you considered going to a support group to help with strategies for you to deal with all of this. The oxycodone is probably something that he needs now so it would be better to work on the beer. I really think that this is not something that you can do alone. Try to seek help, even if he does not want it, you can use the support.
This is like dealing with a child, you have to be strong and consistent, mean what you say. He will soon see how much you do for him and if he doesn't that you need to move on. No one deserves this kind of treatment and you are enabling him by staying and listening to it while you pray for "good moments." Please stay here so that we can support you.