When doing transaction log shipping and choosing the Database Option as Standby/Readonly, the users will get disconnected when the last step of restore is being done.
I have tested this and had to restart the Portal Services and then everything works fine.
So i added another step in the Restore Job to restart the Portal Services and they do work fine.
I did set a time delay to run the restoration process every 4 hours and is working fine.
Now i have come to a situation.
Would i be able to use this read only database for doing some comparison against an oracle view and generate the result from that and insert it to an Oracle Database table.