随笔 - 6  文章 - 0  trackbacks - 0
<2013年9月>
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345

常用链接

留言簿

随笔档案

文章档案

搜索

  •  

最新评论

阅读排行榜

评论排行榜

问题:

SQL> startup
ORACLE instance started.

Total System Global Area  538514184 bytes
Fixed Size                   451336 bytes
Variable Size             503316480 bytes
Database Buffers           33554432 bytes
Redo Buffers                1191936 bytes
Database mounted.
ORA-01113: file 26 needs media recovery
ORA-01110: data file 26: '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'
解决方法:

SQL> recover datafile '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'
ORA-00279: change 244674111 generated at 09/24/2013 15:20:41 needed for thread
1
ORA-00289: suggestion : /opt/ora9/product/oracle/dbs/arch1_1123.dbf
ORA-00280: change 244674111 for thread 1 is in sequence #1123


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
SQL> alter database open;

Database altered.

posted on 2013-09-26 09:49 Glorin 阅读(1693) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航: