Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restore a single datafile
"Howard J. Rogers" wrote:
>
> The 'XXXXX' there is the time just prior to when you issued the drop
> tablespace command. The backup controlfile clause is required, because
> you're using (and have to use) a backed up binary version of the
> controlfile, meaning that it itself contains the "wrong" timestamp, and you
> have to alert Oracle to that fact.
Just a quick clarification - gritto could also use a recreated controlfile (as opposed to a backed up binary version from a time prior to the tablespace drop) for this recovery scenario. Just in case - in the rare, outside chance mind you ;) - gritto didn't backup the controlfiles with the rest of the datafiles during the cold backup.
Regards,
Sean
Received on Wed Jan 15 2003 - 19:48:36 CST