Daksin

as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be kicked out without warning by the restore process. If you're needing to query the database that much then Log shipping probably isn't your best option.

If you're asking how can you bring the database back online when in the norecovery state then simply issue

RESTORE DATABASE MYDATA WITH RECOVERY

Bear in mind that the log shipping config will be broken