Quote Originally Posted by altr
I have tried this restore process again and have been able to restore the database to the backup machine correctly this time (I think this is a hit and miss affair as sometimes it works and sometimes it does not).
You need the online logs most likely, backups of which should be taken at the end of the tablespace backup not the begining.


Quote Originally Posted by altr
Once the database has been restored, how can we apply the archive logs to roll the database forward in time so it is closer to the live server?
.
You need to set it up as a "standby" in order to "roll forward" If that is truly what you want to do.. Lookup/search for standby database. (configuration is much more manual and error prone for oracle 7.x)

Quote Originally Posted by altr
Trying the recover database gives no recovery required.
Thats because none is required, Youve recovered the DB.