DG：RFS[8]: No standby redo logfiles created for thread 2

环境：两节点的RAC在线搭建DG，处理报错

现象：RFS[8]: No standby redo logfiles created for thread 2 ，thread2 没有建立redo

Tue Aug 24 09:51:58 2021

Primary database is in MAXIMUM PERFORMANCE mode

RFS[8]: Assigned to RFS process 4994

RFS[8]: No standby redo logfiles created for thread 2

RFS[8]: Opened log for thread 2 sequence 54 dbid 1608598914 branch 1080818180

当前备库redo文件V$STANDBY_LOG视图：

SQL> select group#,thread#,sequence#,bytes/1024/1024 mb,archived,status from V$STANDBY_LOG;

    GROUP#    THREAD#  SEQUENCE#     MB ARC STATUS

---------- ---------- ---------- ---------- --- ----------

    11        1          73     50 YES ACTIVE

    12        1           0     50 YES UNASSIGNED

    13        1           0     50 YES UNASSIGNED

    14        1           0     50 YES UNASSIGNED

    15        1           0     50 YES UNASSIGNED

v$log视图：

SQL> select group#,thread#,bytes/1024/1024,archived,status,members from v$log;

    GROUP#    THREAD# BYTES/1024/1024 ARC STATUS          MEMBERS

---------- ---------- --------------- --- ---------------- ----------

     1        1           50 YES CURRENT            1

     2        1           50 YES CLEARING            1

     3        2           50 YES CLEARING            1

     4        2           50 YES CURRENT            1

当前mrp进程状态：

SQL> select process, status, thread#,sequence#, block#, blocks from v$managed_standby;

PROCESS   STATUS      THREAD#  SEQUENCE#     BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH      CLOSING        1      72          1        708

ARCH      CONNECTED        0       0          0      0

ARCH      CONNECTED        0       0          0      0

ARCH      CLOSING        1      71       2048       1272

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            1      73       3037      1

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            2      54       5408      1

PROCESS   STATUS      THREAD#  SEQUENCE#     BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

MRP0      WAIT_FOR_LOG        2      54          0      0

12 rows selected.

取消实时应用：

SQL> alter database recover managed standby database cancel;

Database altered.

重建redo：

SQL> alter database drop logfile group 11;

alter database drop logfile group 12;

alter database drop logfile group 13;

alter database drop logfile group 14;

alter database drop logfile group 15;alter database drop logfile group 11

*

ERROR at line 1:

ORA-00261: log 11 of thread 1 is being archived or modified

ORA-00312: online log 11 thread 1:

'/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo11.log'

SQL>

Database altered.

SQL>

Database altered.

SQL>

Database altered.

SQL> 

Database altered.

SQL> alter database add standby logfile thread 1 group 11 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo11.log' size 50M;

alter database add standby logfile thread 1 group 16 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo16.log' size 50M;

alter database add standby logfile thread 1 group 17 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo17.log' size 50M;

alter database add standby logfile thread 2 group 18 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo18.log' size 50M;

alter database add standby logfile thread 2 group 19 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo19.log' size 50M;alter database add standby logfile thread 1 group 11 '/u1/db/oracle/product/11.2.0/db_1/dbs/std_redo11.log' size 50M

*

ERROR at line 1:

ORA-01184: logfile group 11 already exists

SQL>

Database altered.

SQL> 

Database altered.

SQL> 

Database altered.

SQL> 

Database altered.

主库切换归档：

SQL> archive log list;

Database log mode           Archive Mode

Automatic archival           Enabled

Archive destination           +CRSDG

Oldest online log sequence     73

Next log sequence to archive   74

Current log sequence           74

SQL>

SQL>

SQL>

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

备库mrp状态，可以正常APPLYING_LOG

SQL> r

  1* select process, status, thread#,sequence#, block#, blocks from v$managed_standby

PROCESS   STATUS      THREAD#  SEQUENCE#     BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH      CLOSING        1      74          1     50

ARCH      CLOSING        1      75          1      5

ARCH      CONNECTED        0       0          0      0

ARCH      CLOSING        1      76          1      1

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            1      77       1293      1

RFS      IDLE            0       0          0      0

RFS      IDLE            0       0          0      0

RFS      IDLE            2      55        526      1

PROCESS   STATUS      THREAD#  SEQUENCE#     BLOCK#     BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

MRP0      APPLYING_LOG        2      55        526     102400

12 rows selected.

备库standby alert日志，可以正常应用

RFS[8]: Selected log 18 for thread 2 sequence 55 dbid 1608598914 branch 1080818180

Tue Aug 24 10:04:10 2021

Media Recovery Log /arch/2_54_1080818180.dbf

Media Recovery Log /arch/1_73_1080818180.dbf

Media Recovery Log /arch/1_74_1080818180.dbf

Media Recovery Log /arch/1_75_1080818180.dbf

Media Recovery Log /arch/1_76_1080818180.dbf

Media Recovery Waiting for thread 1 sequence 77 (in transit)

Recovery of Online Redo Log: Thread 1 Group 11 Seq 77 Reading mem 0

  Mem# 0: /u1/db/oracle/product/11.2.0/db_1/dbs/std_redo11.log

Media Recovery Waiting for thread 2 sequence 55 (in transit)

Recovery of Online Redo Log: Thread 2 Group 18 Seq 55 Reading mem 0

  Mem# 0: /u1/db/oracle/product/11.2.0/db_1/dbs/std_redo18.log

Tue Aug 24 10:10:05 2021

Successfully added datafile 7 to media recovery

Datafile #7: '/u1/db/oracle/product/11.2.0/db_1/dbs/ORCL_STB/datafile/o1_mf_smart_jl8o7x0o_.dbf'

DG：RFS[8]: No standby redo logfiles created for thread 2的相关教程结束。