Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: backup/recovery of very dynamic DB
If you are running 7.3 you can try to use "Standby Database" feature.
See Oracle7 Administrator's Guide, Chapter24. Recovering a Database,
Preparing for Disaster Recovery. You should use
DB_FILE_STANDBY_NAME_CONVERT
initialization parameter.
Best regards
Jerry Murr <jdm2_at_lsdn.ksc.nasa.gov> wrote in article
<334BE7A9.77B5_at_lsdn.ksc.nasa.gov>...
> 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 Thu Apr 10 1997 - 00:00:00 CDT