Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recovering past a datafile addition

Re: Recovering past a datafile addition

From: Vincent Ventrone <vav_at_mitre.org>
Date: Mon, 06 Dec 1999 13:14:39 -0500
Message-ID: <384BFD0F.ECE76FD@mitre.org>

Neil Cudd wrote:
>
> If I take an online backup at time-point A then add a datafile to a
> tablespace at time-point B (taking a backup of the controlfile before and
> afterwards) what exactly is the procedure for recovering past the point at
> which the datafile was added (take as granted I have restored all datafiles
> that were backup up at time A) ? How does the physical file get created ?

I assume that the "ALTER TABLESPACE ADD DATAFILE..." statement would be in the archive log, along with all the other changes made to the database...Maybe someone else who has actually done a recovery like this can confirm?
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730
Received on Mon Dec 06 1999 - 12:14:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US