Hi I have managed to recover the datafiles.

Thank-You very much for you help!

Joy


-----Original Message-----
From: Nabil Jamaleddin [mailto:Nabil.[Email Address Removed]
Sent: 30 May 2002 17:58
To: 'Joy Hagelthorn'
Subject: RE: SO URGENT!!

if your database is down, that is fine, else to recover datafile
'filename';

-----Original Message-----
From: Joy Hagelthorn [mailto:j.[Email Address Removed] Thursday, May 30, 2002 12:00 PM
To: 'Nabil Jamaleddin'
Subject: RE: SO URGENT!!


Hi

A datafile called sym_data.dbf needs to be recovered, so should I just
issue the commend alter database recover?

Joy Hagelthorn

PH: 0208 547 2000 (ext. 2016)


-----Original Message-----
From: Nabil Jamaleddin [mailto:Nabil.[Email Address Removed]
Sent: 30 May 2002 17:50
To: 'Joy Hagelthorn'
Subject: RE: SO URGENT!!

What datafiles need recover?

Try to recover them without restoring from your backup

-----Original Message-----
From: Joy Hagelthorn [mailto:j.[Email Address Removed] Thursday, May 30, 2002 11:48 AM
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