Hi
Currently I don't want the datafile to be restored. Let me know whether I can remove the file from the server and work with my database.

Rgds
Vidya

-----Original Message-----
From: Roman Haas [mailto:r.[Email address protected]
Sent: Friday, March 04, 2005 11:47 AM
To: Srividya K.B. (WT01 - Retail, CPG & Distribution)
Subject: AW: Datafile corruption


Hi Srividia.

Take a full backup first (even if db is corrupt) .
Then you restore only corrupt datafile from valid backup und do recovery:
ALTER DATABASE MOUNT;
RECOVER DATAFILE '...'
ALTER DATABASE OPEN;

hh

Mit freundlichen Grüßen

i.A.

Roman Haas

UP8.media
Information : Communication : Education
Alfred-Herrhausen-Straße 44| D-58454 Witten

Fon + Fax: 0700.UP8MEDIA (0700.878.63342)


-----Ursprüngliche Nachricht-----
Von: srividya
[mailto:oracledba-ezmlmshield-x2559279.[Email address protected]
Gesendet: Freitag, 4. März 2005 07:01
An: LazyDBA Discussion
Betreff: Datafile corruption


Hi Folks
One of my datafile is corrupted and it has gone offline. Let me whether
I can delete the datafile from its physical location and create a new
datafile and associate with the tablesapce.

Rgds
Vidya











Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page