ORA-01113: file 1 needs media recovery

最新推荐文章于 2024-07-03 10:13:27 发布
最新推荐文章于 2024-07-03 10:13:27 发布
阅读量2.6k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/csdnhadoop/article/details/64438518
版权
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oradata/crltest/system01.dbf'




SQL> 




alter database open
Errors in file /oracle/app/oracle/diag/rdbms/crltest/crltest/trace/crltest_ora_62126.trc:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/home/oradata/crltest/system01.dbf'
ORA-1113 signalled during: alter database open...

csdnhadoop
关注
ORA-01113: file 7 needs media recovery
疯狂的石头
11-25 2673
今天一大早开始起来做实验，可惜遇到了一个问题，就是报有部分数据文件需要做介质恢复，首先我看到有一个文件报：ORA-01110错误，说明这个数据文件是我原先做备份恢复时没有正常关闭，也就是昨天我做的热备实验没有执行END BACKUP操作，直接关闭了系统服务器，相关的检查点已经在控制文件中友过旧的，导致我大早上直接STARTUP无法OPEN DB。闲话少说，上解决实践过程： Last login:
ora-01113 oracle8i,分享一次ORA-01113 ORA-01110故障处理过程
weixin_36155560的博客
04-03 578
近期编写了小工具,对于此类问题,可以实现一键恢复,参考:一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools数据库报ORA-01113 ORA-01110无法正常openSQL> alter database open;alter database open*ERROR at line 1:ORA-01113: file 1 needs media re...
ORA-01113: file 1 needs media recovery ORA-01110: data file 1:
姚远OracleACE的博客
08-04 2598
SQL> alter database open; alter database open * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/u01/app/oracle/oradata/guangxi/system01.dbf' 把下面两个隐含参数加入到pfile中 *._allow_terminal_recovery_corruption=true *._allow_resetl
oracle数据库无法open，报“ORA-01113 file 1 needs media recovery”错误，教你用“六脉神剑”来开库
最新发布
老苏畅谈运维
07-03 1245
在系统断电或数据库异常宕机后，数据库启动过程中可能出现ORA-01113 ORA-01110 这些错误，而你又没有备份，未开归档或者归档已经被删除了，那要怎么办呢？
ORA-01113: file 2 needs media recovery
vagabond1的专栏
04-07 5604
数据库服务启动。此时用sqlplus命令进入数据库，出现SQL>提示。此时执行语句却发现ORA-01109: database not open用alter database open出现错误ORA-01113: file 2 needs media recoveryORA-01110: data file 2: 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/UNDOTBS01.DBF'查看数据库和实例状态select status from v$instance;STATU
ORA-01113 file 1 needs media recovery
苦行僧的妖孽日常
01-07 3032
ORA-01113 file 1 needs media recovery 解决过程
oracle ORA-01113的解决方法（file 1 needs media recovery）
asdfgh0077的博客
08-06 1197
oracle ORA-01113的解决方法（file 1 needs media recovery）
oracle文件1需要介质恢复,ora-01113：文件2 需要介质恢复
weixin_35807050的博客
04-13 2348
文件损坏或日子文件缺失：操作流程1、shutdown immediate;2、startup mount;3、recover datafile 'd:\';4、alter database open ;C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production ...
ORA-01113: file 8 needs media recovery【数据文件的OFFLINE操作造成】
滴水石穿
08-19 5341
在让一个数据文件上线的时候，突然报错：“ORA-01113: file 8 needs media recovery” SQL> alter database datafile 'D:\APP\ASUS\ORADATA\WAREHOUSE\TEST03.DBF' online; alter database datafile 'D:\APP\ASUS\ORADATA\WAREHOUSE\TE
ORA-01113: file 5 needs media recovery ORA-01110: data file 5
04-09 420
Last login: Sun Feb 9 14:06:37 2014 from 192.168.7.165 [oracle@oracle103 ~]$ env |grep ORA ORACLE_SID=zghfin O...
ORA-01113: file 13 needs media recovery
喝醉酒的小白
09-16 2113
media recovery oracle,ORA-01113: file 26 needs media recovery解决方法
weixin_32124135的博客
04-03 242
SQL> startupORACLE instance started.Total System Global Area 538514184 bytesFixed Size 451336 bytesVariable Size 503316480 bytesDatabase Buffers 33554432 by...
oracle revovery ora-01110,一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools
weixin_42394780的博客
04-07 279
一般由于归档日志丢失或者非归档库可能在数据库启动的时候出现类似如下错误SQL> startupORACLE instance started.Total System Global Area 2137886720 bytesFixed Size 2282960 bytesVariable Size 587205168 bytesDat...
media recovery oracle,【问题处理】ORA-01113 file xxx need media recovery
weixin_40001805的博客
04-03 786
问题说明在数据库以外宕机或执行备份恢复时，可能会遇到ORA-01113问题。ORA-01113错误通常伴随着ORA-01110错误一起出现，ORA-01110错误指向着报错的文件名ORA-01113: file21needs media recoveryORA-01110: data file21: '/u01/app/oracle/oradata/users02.dbf'原因分析ORA-0111...
oracle 打开数据库提示ORA-01113和ORA-01110的解决办法
weixin_34061042的博客
12-28 1087
问题：SQL> startupORACLE instance started.Total System Global Area 1610612736 bytesFixed Size 779080 bytesVariable Size 535043256 bytesDatabase Buffers 1073741824 bytesRedo Buffers 10485...
【Vegas原创】ORA-01113: file 1 needs media recovery解决
weixin_33798152的博客
03-05 711
问题： SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size                   779080 bytes Variable Size             535043256 bytes Database Buffers       ...
ORA-01113,ORA-01110的简单解决
热门推荐
冷月宫主的专栏
03-17 3万+
分析和解决问题：1.重起数据库：C:\Documents and Settings\Jacken>sqlplus /nologSQL> conn sys/123456 as sysdba;SQL> shutdown immediate;数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startup;Total System Global Area 29...
oracle01113错误
qq_48257021的博客
01-23 617
【代码】oracle01113错误。
ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file "/data/backup/expdp/FAL_full_expdp_20230525.dmp" ORA-27038: created file already exists Additional information: 1
05-26
expdp username/password@database_name REMAP_DUMPFILE=/data/backup/expdp/FAL_full_expdp_20230525.dmp:new_dump_file.dmp ``` 这将创建一个名为 new_dump_file.dmp 的新导出文件，替换原本已经存在的 FAL_full_...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值