How come that datafile needs recovery?

I would.

Shutdown database,
make cold backup
remove datafiles associated with tablespace.
cp original datafile from backup.
reocver until point and time...you added datafile.

Ashish.
--- Joy Hagelthorn <j.[Email Address Removed] A datafile was added to an existing tablespace on
> our live database and
> a short while after that the datafiles in the
> tablespace are now
> indicating that they will need media recovery.
>
> I am running Oracle 8i on Windows 2000. The database
> is in archivelog
> mode and I have a cold backup from last night.
>
> Would the best method be to restore the datafiles
> from last night and
> then to alter database recover until the point of
> failure??
>
>
> Many Thanks
>
> Joy
>
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


=====
Ashish

http://www.remotedba.ca

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Oracle LazyDBA home page