Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Incomplete datafile after restore from tape backup
Hi Bill,
Do you by any hope have all the redo logs that were generated since a complete backup of the file was successful or all the redo logs since the file was actually created ?
You can re-create the datafile easy enough (alter database create datafile 'blah' as 'blah') but the import option into the specific datafile within the tablespace is doomed.
Richard
"Bill Hutchison" <billh_at_gci.net> wrote in message
news:3cfd4bd8.27711166_at_news.gci.net...
> I have a datafile that was not completely backed up due to a read
> error on our hard drive. The read error was beyond the area in the
> datafile which was used, so I wasn't overly concerned at the time.
> We finally had further problems with the drive and had to replace it.
> A recent tape backup was used to restore the bad drive (#4 of 5), but
> the file with the read error was incomplete on restore, about 15MB of
> defined size of 50MB.
>
> I want to recreate the datafile and restore from an export, but I
> can't get the database to open since the short file causes a read
> error when Oracle (7.1) is trying to startup the database.
>
> How can I get rid of the short version of the file, recreate the file
> in full size either before or after I get the database to open, and
> then do a full import from our most recent export?
>
> Many thanks for any help!
> Bill Hutchison
>
Received on Tue Jun 04 2002 - 20:57:46 CDT