I have restored the last transactional Log backup with the option of STANDBY on SSMS. The database is now back to ReadOnly / STANDBY. Now I users will be able to read from this database and the Log shipping is IN-SYNC.

thanks for all the help guys.

Appreciate it. I will put detailed steps here shortly in case anyone needs it later.