-
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
-
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.
Code:
recover tablespace tablespace_name;
alter tablespace tablespace_name online;
Sam
[Edited by sambavan on 05-06-2002 at 10:49 AM]