retainOndelete

property deletes the pulumi resource but when I do pulumi up, pulumi stack is not refreshed and complaining for resource exists Is it possible if pulumi refreshed it's state with the cloud resource?

No - because there is now link anymore after deletion that exactly this resource belongs to the code in pulumi. You have to import it manually.

thanks @clever-kite-79772 for prompt response.