Re: pb with one datafile

there is a sliver of hope, however unlikely. If all of the redo required for recovery of the datafile is in the online redo logs that have not been cycled through - you *may* be able to perform recovery on the datafile.

Please perform a cold backup of what you have prior to doing anything else.

at this point you have a couple of options: - offline drop the datafile in a mounted state (data is lost) and open the database, drop the tablespace (will definitely work, but all data in datafile is gone)
- attempt recovery with the contents of the online redo logs. - call oracle support, and attempt to open the database as corrupt in a read-only state for the purpose of producing an export - call oracle support and request the data unloader tool

As the tone in the posting is not panicky, why not just offline drop the datafile, open the database, drop the tablespace and move on. If the data cannnot be reloaded, its going to get very expensive to get the data out.

Start with getting a support contract with Oracle Worldwide Support.

Paul

thierry wrote:
>
> Hi,
>
> I use Oracle 8.1.7.
> One datafile for a tablespace (other than system ) was deleted.
> When I startup, the base cannot be opened because of the missing file.
> I connect internal
>
> V$DATAFILE says the missing file ONLINE , why ????
>
> I am NOT in ARCHIVELOG, I have a backup of the file.
>
> What is the procedure to recover my base with the backup of the file ?
>
> Thanks
Received on Sun Sep 23 2001 - 10:06:30 CDT