backup/recovery of very dynamic DB

I have a database where Oracle userid's and tablespaces (dedicated to holding data for those userid's) are added and deleted on a daily (even hourly) basis. We've written software to automate the creation/deletion of these userid's and tablespaces, so that a base of authorized clients can do this without any DBA intervention.

Now that it's beginning to work, we are worrying about backup and recovery. If we take weekly cold backups and run in Archivelog Mode, will the creation/deletion of tablespaces be recorded, such that we could start recovery by restoring the cold backup and apply the redo logs to get back to the point of system failure? I'm sure this strategy works if you have static tablespaces (and datafiles), but what about this situation?

Is there anything we should be doing in the create/delete software to ensure we can recover if the system dies (like recopying the control files after adding or deleting a tablespace)?

We are running Oracle7 Server Release 7.3 on DEC Alpha servers running Digital UNIX V4.0.

Thanks in advance.

Please send your response to jdm2_at_lsdn.ksc.nasa.gov Received on Wed Apr 09 1997 - 00:00:00 CDT