51Testing软件测试论坛
标题:
oracle建立表空间相关知识
[打印本页]
作者:
xkmj
时间:
2010-3-22 13:33
标题:
oracle建立表空间相关知识
表空间误删除解决办法,能装载数据库(进入nomount状态)
sqlplus /nolog
connect / as sysdba
startup nomount
alter database mount;
1. alter database create datafile '/oradata2/sudanxn/oradata/sudanxn/sudanxn/perftemp.dbf';
2. set autorecovery on;
3. recover datafile '/oradata2/sudanxn/oradata/sudanxn/sudanxn/perftemp.dbf';
4. alter database datafile '/oradata2/sudanxn/oradata/sudanxn/sudanxn/perftemp.dbf' online;
alter database open;
即可恢复误删除导致的数据库实例无法打开的问题,前提是日志文件没被删除 redo01.log
表空间知识参考
http://blog.csdn.net/hdhai9451/archive/2009/02/07/3867196.aspx
欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)
Powered by Discuz! X3.2