in mount: alter database datafile 'datafile name' offline; alter database open; --first open database; if u have backup and in archive log mode then copy ur backup data file recover datafile 'datafile name'; alter database datafile 'datafile name' online; else drop ur datafile but u will lost data of this datafile
如果那个数据文件没有备份,但是你有ARCHIVE LOG还是可以尝试恢复一下。 svrmgrl>startup mount alter database create database 'new.file' as 'old.file' recover datafile 'new.file'; alter database datafile 'new.file' online
上面有个地方错了 :) alter database create datafile 'new.file' as 'old.file'
alter database datafile 'datafile name' offline;
alter database open;
--first open database;
if u have backup and in archive log mode then
copy ur backup data file
recover datafile 'datafile name';
alter database datafile 'datafile name' online;
else
drop ur datafile
but u will lost data of this datafile
svrmgrl>startup mount
alter database create database 'new.file' as 'old.file'
recover datafile 'new.file';
alter database datafile 'new.file' online
alter database create datafile 'new.file' as 'old.file'