Re: file needs media recovery?

Once again, I'm indebted to members of this group. Thanks. It worked.

In article <8nta4o$ku4$1_at_porthos.nl.uu.net>,   "Frank van Bortel" <f.van.bortel_at_vnl.nl> wrote:
> 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...

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