> > 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 ) ?
Received on Sun Sep 23 2001 - 09:38:41 CDT
