Hi,

Put a standby database on the local machine and apply all the logs generated on the remote database to keep it current. You can also use the standby database in read-only mode.

For this after the oracle software is installed, restore the database as of a point in time, convert it to standby mode.

With 817 you can automate the log application OR you may choose to apply the logs periodically.

Baliga