Re: Help needed with deleted data file (fwd)

 Your steps will probably work. If I understand it correctly, though,  the 'drop' option should be added to the 'alter database datafile..'  command if archival option is not enabled.

 The following worked for us after a table space physical file  was accidentally deleted.

1. dbshut
2. sqldba lmode=yes
3. _at_force_start.sql

 .. where force_start.sql looked like

connect internal;
startup mount;
alter database datafile

      '//u00/home/oracle/product/7.0.13/dbs/new_tables/x1.dbf' offline drop; alter database open;

 The name of the OS file was exactly quoted from the Oracle failed startup  message - including the double slashes (//).

In <CHonC7.1Fr_at_vistachrome.com>, andy_at_vistachrome.com (Andrew Finkenstadt) writes:
>Mike & Amir,
>
>SQLDBA> shutdown force # force database down NOW in case it is up
>SQLDBA> startup nomount # ignore files besides control file
>SQLDBA> connect internal # connect to kernel
>SQLDBA> alter database datafile '/data/file/name' offline;
>.. # force filename to be offline
>SQLDBA> alter database mount; # mount the other files
>SQLDBA> alter database open; # make sure DB comes up, recovers 'force'
>SQLDBA> shutdown # shutdown normal to snapshot logfiles
>SQLDBA> startup # startup normal
>
>the above is untested, but similar to things I've had to do when I lost
>a rollback segment tablespace once.
>
>--
>Andrew Finkenstadt | Systems Analyst, Homes & Land Publishing Corporation
>+1 904-575-0189 | GEnie Sysop ,,,
>andy_at_genie.geis.com | (. .) Peek-a-boo!
>andy_at_homes.com +----------------------o00-(_)-00o---------------------

Regards

/Johan Hellstrom Received on Wed Dec 08 1993 - 12:20:24 CET