Re: data files moved ?

You sure that no one had mount the database, rename the datafile to a new position (and of course, moving it through OS command first). Or taking a tablespace offline, then rename the datafile in that tablespace (same here.. moving it through the OS command first). Do go and check the alert.log file. You may get some idea about what's going on. Other than that, I really can't think of any reason why the file can move around and still oracle is able to recognize it.

Winnie

Mike wrote in message <35dc970e.31251258_at_news.iconnet.net>...
>this sounds a little crazy, but i don't know what really happened so
>it may be ok...
>
>oracle data files (specifically the .dbf files for an application's
>tablespaces) are not where they are supposed to be.
>
>the file was: /database/oradata/DEV/rcrrun1.dbf
>
>now it is:
>/apps/app/oracle/product/7.3.2/dbs/databaseoradataDEVrcrrun1.dbf
>
>I don't know if UNIX moved this, or oracle moved this...the database
>is up and running with all data intact, all necessary files are ok and
>active, users can connect, shut-down and start-up works ok and the
>control file trace shows that the instance knows about these files.
>
>any ideas ?????????????????
>
>ps: Oracle 7.3.2, Solaris 2.5, Sun UNIX
Received on Thu Aug 20 1998 - 21:51:11 CDT