datafile corrupted on non archivelog

[newcomer]

Hi Sam,

As a new starter I have a doubt. Pls clarify the same.

------------------------------------------------------------------------------------
Mount the database
alter database datafile '/../filename' offline;
alter database open;

restore the backup copies of the damaged datafile
------------------------------------------------------------------------------------

If the datafile is corrupted and tablepsace is offline how do I restore the backup copies of the damaged datafile?

I will appreciate if you expalin the same in details.

regards

[sambavan]

When I mentioned the restore of the backup file, I ment the os copies of them. Rename the original file, copy the backup file into the original place and then apply the recovery procedures.

   recover tablespace tablespace_name;

   alter tablespace tablespace_name online;

Sam

[Edited by sambavan on 05-06-2002 at 10:49 AM]