【Vegas原创】ORA-01113: file 1 needs media recovery解决
来源:互联网 发布:暗黑3网络延迟多少 编辑:程序博客网 时间:2024/06/07 04:42
问题:
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 779080 bytes
Variable Size 535043256 bytes
Database Buffers 1073741824 bytes
Redo Buffers 1048576 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/dtberp/system01.dbf'
解决方法:
SQL> RECOVER DATAFILE '/u01/app/oracle/oradata/dtberp/system01.dbf'
Media recovery complete.
SQL> recover tablespace system;
Media recovery complete.
SQL> RECOVER DATABASE;
Media recovery complete.
SQL> ALTER DATABASE OPEN;
Database altered.
0 0
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- ORA-01113: file 1 needs media recovery
- ORA-01113: file 2 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-01113: file 7 needs media recovery
- 【Oracle问题集2】ORA-01113: file 7 needs media recovery
- ORA-01113: file 8 needs media recovery【数据文件的OFFLINE操作造成】
- ORA-01194: file 1 needs more recovery to be consistent
- 【Vegas原创】ORA-16038解决
- 【Vegas原创】ORA-16038解决
- 【Vegas原创】ORA-01031: insufficient privileges解决
- 【Vegas原创】ORA-01031: insufficient privileges解决
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- ORA-01196: file 1 is inconsistent due to a failed media recovery session
- 【Vegas原创】使用nid更改DBName和sid
- 【Vegas2009】3月3日-ubuntu上虚拟xp
- 【Vegas2009】3月3日-ubuntu上虚拟xp
- 【Vegas原创】谨慎使用userdel命令
- 【Vegas原创】谨慎使用userdel命令
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 【Vegas原创】ORA-01113: file 1 needs media recovery解决
- 动态规划算法 概念讲解
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】ORA-01103:"database name *** in control file is not @@@" 解决
- 【Vegas原创】修改oracle用户缺省主目录
- 【Vegas原创】修改oracle用户缺省主目录
- params ref out 方法参数详解
- 【Vegas原创】添加SQL Server Agent作业步骤中的运行身份