[案例]Oracle 11.2.0.4 DG No standby redo logfiles created for thread 1

Oracle11.2.0.4 DG

主库查询数据库SCN

SYS@orcl>select 1 dest_id, current_scn from v$database
2 union all
3 select dest_id, applied_scn from v$archive_dest where target='STANDBY';

DEST_ID CURRENT_SCN
---------- -----------
1 786957456
2 750451811

DG备库搭建之后，alert日志报错信息：
Wed Jan 20 07:03:32 2021
Archived Log entry 7 added for thread 1 sequence 3743 rlc 1012138755 ID 0x5bca1183 dest 2:
RFS[1]: No standby redo logfiles created for thread 1
RFS[1]: Opened log for thread 1 sequence 3744 dbid 1539919491 branch 1012138755
Wed Jan 20 07:03:32 2021
1.备库standby redolog (srl)状态为UNASSIGNED，停止日志应用MRP进程
SYS@orcl>select group#,DBID,status from v$standby_log;

GROUP# DBID STATUS
---------- ---------------------------------------- ----------
4 UNASSIGNED UNASSIGNED
5 UNASSIGNED UNASSIGNED
6 UNASSIGNED UNASSIGNED
7 UNASSIGNED UNASSIGNED

SQL> alter database recover managed standby database cancel;

2、删除以有的srl日志组
SQL>alter database drop standby logfile group 4;
SQL>alter database drop standby logfile group 5;
SQL>alter database drop standby logfile group 6;
SQL>alter database drop standby logfile group 7;

3.重建standby log
SQL>alter database add standby logfile group 7 ('/u01/oradata/orcl/std07a.log','/u01/oradata/orcl/std07b.log') size 512M;
SQL>alter database add standby logfile group 6 ('/u01/oradata/orcl/std06a.log','/u01/oradata/orcl/std06b.log') size 512M;
SQL>alter database add standby logfile group 5 ('/u01/oradata/orcl/std05a.log','/u01/oradata/orcl/std05b.log') size 512M;
SQL>alter database add standby logfile group 4 ('/u01/oradata/orcl/std04a.log','/u01/oradata/orcl/std04b.log') size 512M;

SYS@orcl>select group#,DBID,status from v$standby_log;

GROUP# DBID STATUS
---------- ---------------------------------------- ----------
4 1539919491 ACTIVE
5 UNASSIGNED UNASSIGNED
6 UNASSIGNED UNASSIGNED
7 UNASSIGNED UNASSIGNED

4.当开启MRP进程，数据库报ORA-01186、ORA-01157、ORA-01111、ORA-01110

SYS@orcl> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

alert日志信息：standby 数据库开启日志实时应用，data file 25认证失败，MRP进程被杀掉。
Tue Feb 23 13:20:52 2021
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (orcl)
Tue Feb 23 13:20:52 2021
MRP0 started with pid=28, OS id=7088
MRP0: Background Managed Standby Recovery process started (orcl)
started logmerger process
Tue Feb 23 13:20:57 2021
Managed Standby Recovery starting Real Time Apply
Tue Feb 23 13:20:57 2021
Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcl/trace/orcl_dbw0_26103.trc:
ORA-01186: file 25 failed verification tests
ORA-01157: cannot identify/lock data file 25 - see DBWR trace file
ORA-01111: name for data file 25 is unknown - rename to correct file
ORA-01110: data file 25: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00025'
File 25 not verified due to error ORA-01157
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcl/trace/orcl_pr00_7090.trc:
ORA-01111: name for data file 25 is unknown - rename to correct file
ORA-01110: data file 25: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00025'
ORA-01157: cannot identify/lock data file 25 - see DBWR trace file
ORA-01111: name for data file 25 is unknown - rename to correct file
ORA-01110: data file 25: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00025'
Managed Standby Recovery not using Real Time Apply
Completed: alter database recover managed standby database using current logfile disconnect from session
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (orcl)

5、查询data file 25 信息
SYS@orcl>select file#,name from v$datafile;
24 /u01/oradata/orcl/data_zee17.dbf
25 /u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00025

25 rows selected.

SYS@orcl>select TABLESPACE_NAME,FILE_NAME from dba_data_files where tablespace_name='TS_DATA_ZEE';

TABLESPACE_NAME FILE_NAME
------------------------------ --------------------------------------------------
TS_DATA_ZEE /u01/oradata/orcl/data_zee17.dbf

17 rows selected.
SYS@orcl>show parameter convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string /u01/oradata/orcl/, /u01/oradata/orcl/
log_file_name_convert string
SYS@orcl>!df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 50G 14G 34G 29% /
tmpfs 16G 0 16G 0% /dev/shm
/dev/mapper/datavg-datalv01
985G 600G 336G 65% /u01/oradata

总结：
1、经过分析DG库没有指定srl日志，备库不能实现事务日志回放
2、主库对TS_DATA_ZEE表空间新增数据文件/u01/oradata/orcl/data_zee18.dbf，因为备库归档日志未开启定时清理任务，数据文件目录空间不足，映射的数据文件为按照db_file_name_convert指定的路径。
而是在ORACLE_HOME/dbs/下新增了数据文件。