ADG备库同步异常UNNAMED数据文件

ADG备库standby_file_management参数设置为manual时，主库添加数据文件，备库数据文件会显示UNNAMED00008，无法继续应用日志同步，需要在备库手动创建数据文件。

ORA-01111: name for data file 8 is unknown - rename to correct file 
ORA-01110: data file 10: '/oracle/app/oracle/product/11.2.0.4/dbs/UNNAMED00008' 
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file

UNNAMED数据文件处理步骤

1. 确定主库文件名称及备库文件路径

SQL> select file#,name from v$datafile order by file#;
     FILE# NAME
---------- --------------------------------------------------------------------------------
         1 /oradata/xdbdg/system01.dbf
         2 /oradata/xdbdg/sysaux01.dbf
         3 /oradata/xdbdg/undotbs01.dbf
         4 /oradata/xdbdg/users01.dbf
         5 /oradata/xdbdg/user02.dbf
         6 /oradata/xdbdg/user03.DBF
         7 /tmp/user04.DBF
         8 /oracle/app/oracle/product/11.2.0.4/dbs/UNNAMED00008

2. 创建数据文件到正确路径

SQL> alter database create datafile '/oracle/app/oracle/product/11.2.0.4/dbs/UNNAMED00008' 
as '/oradata/xdbdg/user05.dbf';

Database altered.

3. 修改standby_file_management参数为auto

alter system set standby_file_management='auto' scope=both;

4. 启动MRP应用进程，备库alert日志不再报错

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

5. 检查ADG同步状态

set line 200 pages 1000
col name for a25
col value for a20
col unit for a30
col time_computed for a25
col datum_time for a20
col source_db_unique_name for a20
select * from v$dataguard_stats;
select inst_id,process,status,thread#,sequence#,block#,client_process from gv$managed_standby 
order by process,thread#,sequence#;