Re: file needs media recovery?

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 22 Aug 2000 09:29:29 +0200
Message-ID: <8nta4o$ku4$1@porthos.nl.uu.net>

You got it almost right:

connect internal;
alter tablespace etdata offline;
** your physical copy goes here!
alter tablespace etdata rename datafile

           '/opt/oracle/oracle8/dbs/ETDATA' to
           '/opt/oracle/db4/oradata/ORCL/ETDATA.dbf';

alter tablespace etdata online;

You file needed recovery because it was updated between the time it was copied and you did the rename: for one, you took it offline...

--
Kind Regards,
Frank
"Jim Lyons" <jlyons4435_at_my-deja.com> wrote in message
news:8nrr5p$uh2$1_at_nnrp1.deja.com...


> 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.

Received on Tue Aug 22 2000 - 02:29:29 CDT