Backup and Recovery

Looking for thoughts on inventive methods to do a point in time recovery of a single tablespace. Have a situation where I have static historical data maintained in read-only format. Want to do nightly hot backups of the read/write portion of the database, but no backups on the read-only portion. Have taken a permanent cold backup of those tablespaces that are read only.

The scenario occurs where the drives holding the read-only data get blown away, so I want to restore the read-only tablespaces to their original backup date. I don't want to have to apply logs to this tablespace period. I just want it brought back online as of the date it was backed up.

Currently, as of my last go round with this, point intime recovery can only occur a database level, it cannot occur at a tablespace or datafile level. Any thoughts?? Received on Mon Dec 11 1995 - 00:00:00 CET