Re: After Control File backup

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Aug 2005 07:59:00 -0700
Message-ID: <1122994740.573849.12840@g43g2000cwa.googlegroups.com>

>> But yes. you can recover your database using a backup control file if all current
control files are lost <<

Whether you lost the new tablespace or only the control file entry for the tablespace or both, during forward recovery Oracle will reapply the create tablespace from the archived redo logs and update the control file as necessary as part of the recovery. If the tablespace was lost and there was no backup Oracle can in fact still recover it since all activity for the tablespace (and its datafiles are included) in the recovery applied archived redo logs from the create event to the present (time of failure).

See the Backup and Recovery Concepts manual.

HTH -- Mark D Powell -- Received on Tue Aug 02 2005 - 09:59:00 CDT