Need a robocopy command that need to copy the stub data from source to destination
It sounds like you are using some software solution that watches your disk and for files that have not been referenced in a given amount of time, it will archive the actual data file to tape or some other mass storage device and in it's place leaves a file with the same name (the stub) that has the archive attribute set.
So an end user would see \server\share\folder\MySpreadSheet.xls. If they tried to open the file with Excel, the archiving software would recognize that (from the archive attribute) and replace the stub file with the actual data file that the end user could then open.
Is that correct? Is that how it works?
If so, then Robocopy would have no way of knowing that the file is a stub or the actual data file. It's just a file with the archive attribute set. Robocopy.exe reading the file would be no different from Excel.exe reading the file.
You might have better luck reaching out to the product support for whatever software you are using. Because even if you were able to move the stub, that software might not recognize it because it's now in a different folder.
You could try a test by stopping the Service that the archiving software runs as and copy one file to a different directory. Then start the service and try to open the file. Do you get the actual data file or something else?