Re: pb with one datafile

"Thierry" <thierry.constant2_at_wanadoo.fr> wrote in message news:Rtmr7.8828$SH4.9736209_at_nnrp1.proxad.net...
> > > 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
> > >
> >
> > Most likely you won't be able to recover. The SCN in the controlfile
> almost
> > certainly doesn't match the SCN in the header of the backup copy of the
> > datafile. As you state you don't have archived redo log files, you're
> toast.
> >
> > The only way now to recover your database is to get an old full database
> > export, create your database, and import the full database export.
> >
> > The directions in the Oracle documentation with respect to backup and
> > recovery procedures are clear enough. I'm not capable to see why so many
> > sites deliberately ignore them. I'm currently at a 7x24 hour commerce
site
> > where the only backup is a database export (in a wrong characterset).
> > In my first term there I did leave a complete hot backup script series,
> but
> > they were too lazy to test it in 7 months time.
> > So far disaster didn't strike, but I fear it will in three weeks I'm
> > replacing the colleague who made a mess of it, and is on holiday now.
> >
>
> Thanks for your answer ..
> but is it possible to use the old file (backuped)
> to start the database ( of course loosing the most recent transactions ) ?
>
>
>
>
>

You can always try that, but as I said most likely the SCNs will mismatch, so you are forced to perform recovery. If those transactions are not in the online redolog files, you are toast.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 23 2001 - 15:51:34 CDT