There are lot of factors involved in archival photography. First of all what sort of archiving
1. Flat works - books and paintings.
2. 3-D works like statues.
3. Architectural works - both indoor and outdoor.
Each of these has different requirements. There are a few common requirements though
. For flat work you need a flat field of view and simple or no distortion. Complex distortion will not do.
. Low or zero chromatic aberration. Even though a lot of it can be corrected, but that degrades the over all image quality.
. Uniform illumination. For these you will need diffused light.
Now for the lenses.
. Many older manual focus lenses of F4 or smaller aperture are available for copy work. These lenses have a flat field of view and are well corrected for working at copying distances.
. Zooms are rarely without complex distortion. Though the distortion may not be noticeable in normal photographs, these show up in copy and architectural works. So confine yourself to primes.
. One method adopted by many is to use an adapter with the older enlarger lenses. These are extremely well corrected and have a flat field.
Here are some links
Studio Photography: Copying Artwork
Which Lense for Photographing Artwork??? [Archive] - Large Format Photography Forum
Canon 1Ds Mklll. Best copy lens for repro work?
The general consensus is that a macro lense is best for copy work, and the longer FL are easier to use than the shorter ones. Which means the best option is the 180 to 200mm macro. That will allow sufficient distance for uniform illumination.
For Architectural work a TS (Tilt shift) lense is best as it will correct for perspective distortion in the image itself. Though you can do it in software, you loose a lot of IQ in the process.