Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recover data
NO. The applying of archives relies on the SCN's stored in the control
files and datafiles. Importing
the data will not allow you apply the archives to the corrupt file since it
is still corrupt.
You need to restore an uncorrupted copy of the datafiile and apply the
archives to it.
Failing that you could find which tablespace the corrupt datafile applies.
Then find any
user objects (dba_objects) that resided on that tablespace ( owner and
object_name).
Also find all the datafiles that belong to this
ablespace.( dba_data_files). Note
the size of the tablespace. ( add size from dba_data_files)
Then shutdown the database and do the following as internal in sqldba (make sure you have a backup of all database files before attempting this)
Now import the data from the export 3 days previous for only the
users/tables combo's
you identified previously. You will ofcourse loose the last 3 days work.
If this is the only tablespace with data in then it may be easier to just
recreate the whole database
and do a full import.
Remember to backup all datafiles before attempting this!
Hope this helps,
Dan
River <wychan_at_vol.net> wrote in message news:37BD5B17.D3F0B3C8_at_vol.net...
> Due to some mistakes, my Oracle7.1.6 have 1 datafile corrupted.
> They are not the core files like system tablespace, control files, ...
>
> I have a export file which is 3 days ago.
> The database is running in archive log mode.
>
> Can I import that 3 days old export to the database, and then
> recover datafile, and apply the archived log to the latest error-free
> situation?
>
> Thanks for any advice,
> River
> wychan_at_vol.net
Received on Sat Aug 21 1999 - 09:47:41 CDT