Just restore that datafile and recover. Also check for any media problems.

Let me know if there is a problem.
Regards,
Alok Kumar
OCP-DBA(7.3/8/8i)
Work Phone (845) 365 7355
Home Phone: (201) 475 1069
Pager:1-800-366 2337 Pin: 19962
AlphaPage:[Email Address Removed] Message-----
From: Joy Hagelthorn [mailto:j.[Email Address Removed] Thursday, May 30, 2002 12:48 PM
To: LazyDBA.com Discussion
Subject: SO URGENT!!


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] subscribe: send a blank email to oracledba-[Email Address Removed] 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
Oracle LazyDBA home page