file needs media recovery?

I am trying to change the name of a datafile. I followed, I think, the instructions in the Oracle Press DBA Handbook.

I first copied the file to another area. Therefore, I had two exact copies of the file. I then ran svrmgrl and entered the following (I did not copy and paste this, I entered it by hand - any mistakes here were not entered when I actually did it):

connect internal;
alter tablespace etdata offline;
alter tablespace etdata rename datafile

'/opt/oracle/oracle8/dbs/ETDATA' to
'/opt/oracle/db4/oradata/ORCL/ETDATA.dbf';
alter tablespace etdata online;

After each of the first 3 commands I received a 'command processed' message which I assume meant things were ok. However, when I entered the last line, altering etdata online, I got the following error lines:

ORA-01113: file 8 needs media recovery
ORA-01110: data file 8: '/opt/oracle/db4/oradata/ORCL/ETDATA.dbf'

Any ideas as to what went wrong? I renamed things back and the tablespace is online, so I'm not DITW, but I still need help.

Thanks,

Jim Lyons

--
Jim Lyons                     |  Network Systems Analyst
Entertech - The IC2 Institute |  512-482-0273, ext. 269
University of Texas at Austin |  jlyons_at_weblyons.com
http://www.weblyons.com


Sent via Deja.com http://www.deja.com/
Before you buy.