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: recover data

Re: recover data

From: Dan Benwell <dan_at_benwell.co.uk>
Date: Sat, 21 Aug 1999 15:47:41 +0100
Message-ID: <7pme5e$6r2$1@lure.pipex.net>


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)

  1. startup mount
  2. alter database datafile 'location' offline;
  3. alter database open;
  4. alter tablespace <name> offline immediate;
  5. drop tablespace <name> including contents;
  6. host
  7. remove all datafiles associated with the database. 8.. recreate tablespace with same name and size.

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

Original text of this message

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