The problem is still not solved how to get rid of a RAW-JPEG pair, when using iCloud Photo Library on several devices.
I have experimented a bit. It looks like there were a problem with waiting till all devices have synced with iCloud and the RAW file has been removed from all other devices before uploading the JPEG again. And that can be really tricky. The RAW file could be hiding on an iPad that has not been synced for days or a Mac in a different location.
When I am deleting a RAW&JPEG pair while at home and the iMac at work is offline, the iMac will keep the RAW file, even if I delete it from the devices at home and from iCloud.
And when I turn the iMac on, the RAW file still on the iMac will be paired with the new JPEG that has been uploaded. It must be a bug in the duplicate detection process. iCloud Photo Library is trying to use originals again, that have been uploaded from other devices to prevent duplicates in iCloud.
Even renaming the files and changing the modification date does not prevent them from being paired again with the old RAW file.
- What is working is to rename the JPEG and to edit it slightly -simply rotate it in Preview.
- I reimport the renamed, rotated JPPEG, then rotate it back, copy all metadata from the previous version, copy and paste the adjustments over, and only then delete the previous RAW&JPEG pair.
And for good measure I copy the JEG to a folder on a different drive before reimporting it to ensure it is a copy with a new creation date and it is not in the same folder as the exported RAW file. Photos will reimport the RAW file along with the JPEG from the same folder, even if the RAW files have not been selected.