Oracle Database Discussions

I've checked all the forums I can think of and I'm trying to figure out if I'm in the doghouse or not. Figured it wouldn't hurt to post while I'm researching. Basically I was trying to move a datafile to a partition with more room and was unable to take a tablespace offline via the 10g webconsole and copy the file, then point its link to the new locasion so instead I went back to the old fasioned SQLPLUS way.

Per the instructions I unmounted the database, copied the file to the new partition and they started the database in the mount state. Then executed:

ALTER DATABASE RENAME FILE '/u02/xxx/xxx/xxx.dbf' to '/u03/xxx/xxx/xxx.dbf';

Appeared to be flawless. I then did a ALTER DATABASE OPEN; Upon performing successful queries on the DB I deleted the old file.

Once again no issues. I then attempted to shutdown the database and it bombed saying that the file xxx.dbf needed recovery.

I don't do archive logging so I'm weary to run the RECOVER DATAFILE 'xxx.dbf' command because the file was and should be in perfect order.

At this point is there anything I can do to recover that file? Another important thing I sould mention was that the file was copied as root and oracle did not have write permission when the OPEN command was issued. I noticed that after the fact. Was under the gun to get the move done.

Any ideas?