文件中出现了大量的recover的状态,需要进行介质恢复。 SQL> select file#, status, fuzzy, checkpoint_time, checkpoint_change#, resetlogs_change#, resetlogs_time from v$datafile_header where file#=5; FILE# STATUS FUZZY CHECKPOINT_TIME CHECKPOINT_CHANGE# RESETLOGS_CHANGE# RESETLOGS_TIME --- --- ---...
文件中出现了大量的recover的状态,需要进行介质恢复。 1 SQL> select file#, status, fuzzy, checkpoint_time, checkpoint_change#, 2 resetlogs_change#, resetlogs_time from v$datafile_header where file#=5; 3 4 FILE# STATUS FUZZY CHECKPOINT_TIME CHECKPOINT_CHANGE# RESETLOGS_CHANGE# RESETLOGS_TIME 5 -...
ORA-00376: file 1 cannot be read at this time 重启数据库不能成功。alert文件里没有什么信息。 试着重建了控制文件,成功。 感觉有些奇怪,特此记一下。
Hi Community, Hope you people are fine. I am seeing ORA-00376: file 4 cannot be read at this time, ORA-01110: data file 4: 'D:\APP\ADMINISTRATOR\ORADATA\PBTEST\USERS01.DBF' I have a big problem, the datafile is in one of test Database and I all archivelogs have been deleted...
ORA0-00376: "file '/data1/oradata/e_data1.dbf' cannot be read at this time" 重启数据库没有问题,数据文件都能打开。 [oracle@game ~]$ oerr ora 376 00376, 00000, "file %s cannot be read at this time" // *Cause: attempting to read from a file that is not readable. Most likely ...
Errors in file f:\oracle\product\10.1.0\admin\liweiwei\bdump\liweiwei_j000_3612.trc: ORA-12012: error on auto execute of job 1 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: 'F:\ORACLE\PRODUCT\10.1.0\ORADATA\LIWEIWEI\SYSAUX01.DBF' ...
Oracle DBA神器：PRM-DUL灾难恢复工具可以直接从这种受损的Oracle数据库中将数据拯救出来。当你的数据库因为ORA-00600/ORA-07445或其他ORA-报错，或丢失关键的system表空间数据文件，或ASM diskgroup损坏时均可以考虑采用PRM-DUL来做恢复。PRM-DUL采用独创的DataBridge恢复技术，直接从数据文件中抽取数据后可以...
数据库实例启动之后发现,9号数据文件发生故障,file 9 cannot be read at this time, 根据数据库日志的提示,发现9号数据发生故障,尝试介质恢复...
Failed to commit: ORA-00376: file 201 cannot be read at this time ORA-01110: data file 201: '/home/oracle/oracle/oradata/ora10/temp01.dbf'问题补充:匿名 2013-05-23 12:26:38 提交失败: 奥拉 00376: 不能在这个时候奥拉 01110 读取文件 201: 数据文件 201: ' / home/oracle/oracle/ora...
数据库为归档模式，我增加了数据文件后，错误地使用alter database datafile datafilename offline drop;语句来停掉该数据文件，结果出现以下错误：ORA-00376: file 19 cannot be read at this time ORA-01110: data file 19: '.../part1.ora'