In order to restore archived posts from all Collaboration Systems on your site, issue following MySQl statement:

UPDATE assetData
SET status="approved"
WHERE status="archived" ;