解决思路,把损坏的文件设置为离线。
执行:
alter database datafile 5 offline;
提示无法执行。
文档摘录:
ONLINE Specify ONLINE to bring the data file online.
执行如下语句:
startup mount;
alter database datafile 5 offline drop;
alter database open;
数据成功启动
执行:
alter database datafile 5 offline;
提示无法执行。
文档摘录:
ONLINE Specify ONLINE to bring the data file online.
OFFLINE Specify OFFLINE to take the data file offline. If the database is open, then you must perform. media recovery on the data file before bringing it back online, because a checkpoint is not performed on the data file before it is taken offline.
执行如下语句:
startup mount;
alter database datafile 5 offline drop;
alter database open;
数据成功启动
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29121762/viewspace-775044/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29121762/viewspace-775044/