Re: Incomplete datafile after restore from tape backup

> 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?

If the 15 MB were not in use, you can create a new datafile with exactly the same settings like the destroyed one, copy the last n blocks with dd and append them to the old datafile. I did this once (same problem like you) and it worked pretty well.

Regards,

Knut Received on Wed Jun 05 2002 - 02:14:24 CDT