A Deployment Project has been archived by mistake and I don't know how to unarchive this project.
I found this table for Deployment plan : RC_RELEASE_CANDIDATE but I don't have the equivalent for Project table.
Release : 6.x
Component : CA Release Automation
The table holding deployment project data is rc_version, but unfortunately it's not a soft delete rather a hard removal. Henceforth the Project deleted cannot be restore by any modification into the table data.
The only possible solution is, to create a New Deployment Plan Project with same name and create necessary Deployment Plans underneath from available Templates.