Using language specific variables inside section URL settings
Maybe include the .site in your query craft.entries.section('archive').site('YOUR_SITE_HANDLE').one()

What is the section type of your "Archive" entry ? If its a single, maybe it will be more effective to write the handle down manually instead of doing a Query every time.

Note: You can also use .siteId() instead of .site()