Re: [help]I lost my databasefile

Try:
$ sqldba lmode=y
SQLDBA> connect internal

LDBA> startup nomount
LDBA> alter database mount exclusive;
LDBA> alter database datafile 'xxx' offline drop;
LDBA> alter database open;
LDBA> alter tablespace 'yyyy' offline; -- would give some errors
LDBA> drop tablespace 'yyyy';
LDBA> exit

Hirofumi Shinke (shinke_at_yk.rim.or.jp) wrote:
> Hi, Im a newbee DBA and Oracle user.
> Please Help me from my trouble.
 

> I lost some database files.(*.dbf)
> ( I myself deleted them by operation system command. )
> I don't need these missing data any more,
> but I need data in presnt remained .dbf file.
> But I cant open my database since losing files.
> And I have no backup data.
 

> After I hit startup command, the system say
> "file missing: Place the file: XXXXX or
> use ALTER SYSTEM DATABASE CHECK FILES command"
> But there is no information about this command
> on my manual.
 

> There was no system table in missing files.
> So I hope I have some ways to recover from this problem.
 

> Do you have any idea ?

--
**************************************************************
*                          Saad Ahmad                        *
*                          Senior Software Engineer          *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-7457               *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************