Re: Unable to Open Database: Remove Datafile

Daniel Paz Cornes wrote:

>
> "Sumant Vashisth" <svashisth_at_hotmail.com> escribió en el mensaje
> news:95sftp$842_at_scel.sequent.com...
> > I receive the following error message when I try to open the database. I
 had
> > just created the
> > database and added the following file to the tablespace had not yet
> > backed it up.
> > There should not be any data stored in the file. Is there a workaround
> > to this problem
> > (deleting the datafile etc.). There is another datafile in the ts which
 has
> > data stored in it
> > and so it would not be possible for me to drop the tablespace.
> > Thanks in anticipation
> > ######################################################################
> > SVRMGR> alter database open;
> > alter database open
> > *
> > ORA-01122: database file 31 failed verification check
> > ORA-01110: data file 31: 'G:\ORACLE\STS\SAPDATA6\BTABD_5\BTABD.DATA5'
> > ORA-01251: Unknown File Header Version read for file number 31
> > SVRMGR>
> > ######################################################################
> >
> >
>
> I'm not sure, but you can try to recreate control files declaring all
> datafiles except
> the lost datafile, maybe it works...... Anyway I would try on another
> machine with a
> copy of original database.
>
>
> Dani Paz,,
>
>
>

There is a technique whereby it is possible to re-create tablespaces which have never been included in a backup, provided you have all the redo (archive and online) generated since the time the new tablespace was created.

The key syntax is 'create datafile X as Y'.

It's covered in some detail in my backup and recovery paper (www.geocities.com/hjroz2000/backup_and_recovery.htm) ...round about Chapter 5 or 6 I think, from memory.

Regards
HJR Received on Sat Feb 10 2001 - 17:23:29 CST