cannot restore database from hot backup

Quote:

Originally Posted by altr

Thanks again ixion.
We do not backup online logs at the moment. It was our understanding that all that is required to get the database back up to the current point in time was to apply the archive log and the error we had was asking for the archive log.

OK, well maybe you need to archive the last log using "alter system switch logfile" and back it up at the end of your backup... It seems your missing something...

Quote:

Originally Posted by altr

This log was on the backup yet it was as though Oracle ignored it. If we backup the online logs and restore them to the backup machine won't that upset Oracle?

Nope.. Should work just fine.

Quote:

Originally Posted by altr

With regard to setting up as standby database, I could not find much information about doing that with version 7.3.2 - Can you suggest where I can get some help/information or can you suggest another way to achieve our goal?

Googled and found this...
http://www.geocities.com/kgkrish/dow...standby_73.pdf

Quote:

Originally Posted by altr

Also once the database is recovered, should you not be able to apply further archieve logs to bring it forward in time without the use of online logs if the database is running in ARCHIVELOG?

No.... Archivelog mode causes archives to be generated not recovered. Standby will allow you to continue recovery of archived logs.

You really should upgrade to oracle 10.2