Rotella is good (I use it), as is Mobil Delvac and Chevron Delo. Most manufacturers have a heavy duty diesel engine oil that meets both SAE and European requirements. Current
SAE classification for diesels is CJ-4, which is backwards compatible.
One thing I have noticed is that straight mineral oil is being replaced by semi-synthetic or synthetic blends. I have changed over to synthetics and have been pleased to find quicker starting and improved oil pressure as a result. You may find fewer choices if limited to non-synthetic oil, at least in some locations.
I am sure that among Elf, Total, Castrol, etc., you will find an equivalent.