ora-01194_ora-01113

问题

ORA-01111: name for data file 66 is unknown - rename to correct file
ORA-01110: data file 66: '/opt/oracle/product/dbs/UNNAMED00066'
ORA-01157: cannot identify/lock data file66 - see DBWR trace file
ORA-01111: name for data file 66 is unknown - rename to correct file
ORA-01110: data file 66: '/opt/oracle/product/dbs/UNNAMED00066'

原因

df -h

备库空间满了导致数据文件创建到本地目录

备库查询

select * from v$recover_file error like '%FILE%';
66 online online file missing

select file#,name from v$recover_file error like '%FILE%';

主库查询

select file#,name from v$datafile where file# in 66;

select file#,name from v$datafile where file# in 67; --查看下一个数据文件是否正常

解决方案

1 扩容数据空间

2 启动数据库至mount状态

shutdown immediate ；  

startup mount ;

3 重建数据文件

alter system set standby_file_management=manual;
alter database create datafile '/opt/oracle/pdoduct/dbs/UNNAMED00066' as '/data/xxxx/datafile/datafile66.dbf';
alter system set standby_file_management=auto;

4 开启mrp进程应用归档

shutdown immediate;

startup mount;

alter database recover managed standby database using current logfile disconnect from session;

5 开启数据库至open状态

查看日志等待应用归档完成后，关闭mrp进程，然后打开数据库，再次开启mrp

set lines 200
col type format a15
col ITEM format a26
col units format a15
col comments format a25
select * from v$recovery_progress where START_TIME = (select max(START_TIME) from v$recovery_progress);

alter database recover managed standby database cancel;

alter database open ;

alter database recover managed standby database using current logfile disconnect from session;

select PID,PROCESS,STATUS,SEQUENCE#,THREAD#,BLOCKS,DELAY_MINS from v$managed_standby;

col value for a20
col name for a24
col DATUM_TIME for a20
col TIME_COMPUTED for a25
SELECT name, value, datum_time, time_computed FROM V$DATAGUARD_STATS;

今天的文章ora-01194_ora-01113分享到此就结束了，感谢您的阅读，如果确实帮到您，您可以动动手指转发给其他人。