Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archivelog error downstream database golden gate

RobeenAug 27 2019

Oracle Database 12.2.0

RHEL 7.4

Hello Team,

I am getting error from alert log file

2019-08-27T22:50:09.128690+04:00

RFS[11]: Assigned to RFS process (PID:28262)

RFS[11]: Selected log 7 for T-1.S-46746 dbid 878411589 branch 951526160

2019-08-27T22:53:02.255974+04:00

GoldenGate Apply Server AS06 for OGG$REPLOGGT with pid=67 OS id=25705 stopped

2019-08-27T22:53:07.853065+04:00

Errors in file /u01/app/oracle/diag/rdbms/dware1/DWARE1/trace/DWARE1_rfs_24211.trc:

ORA-00310: archived log contains sequence 46746; sequence 46745 required

ORA-00334: archived log: '+DATA/DWARE1/ONLINELOG/group_7.623.1010623865'

2019-08-27T22:54:37.997951+04:00

RFS LogMiner: Registered logfile [+FRA/dware1/archivelog/1_46746_951526160.dbf] to LogMiner session id [24]

2019-08-27T22:54:42.397276+04:00

Thread 1 advanced to log sequence 23723 (LGWR switch)

  Current log# 1 seq# 23723 mem# 0: +REDO/DWARE1/ONLINELOG/group_1.256.998471697

  Current log# 1 seq# 23723 mem# 1: +FRA/DWARE1/ONLINELOG/group_1.265.998471781

2019-08-27T22:54:55.487859+04:00

RFS[12]: Assigned to RFS process (PID:21567)

RFS[12]: Possible network disconnect with primary database

2019-08-27T22:55:00.553450+04:00

RFS LogMiner: RFS id [22496] assigned as thread [1] PING handler

2019-08-27T22:55:01.757976+04:00

RFS[13]: Assigned to RFS process (PID:23771)

RFS[13]: Selected log 9 for T-1.S-46743 dbid 878411589 branch 951526160

2019-08-27T22:55:02.972289+04:00

Errors in file /u01/app/oracle/diag/rdbms/dware1/DWARE1/trace/DWARE1_rfs_22496.trc:

ORA-00322: log 9 of thread 1 is not current copy

ORA-00312: online log 9 thread 1: '+DATA/DWARE1/ONLINELOG/group_9.626.1010624259'

ORA-00322: log 9 of thread 1 is not current copy

ORA-00312: online log 9 thread 1: '+FRA/DWARE1/ONLINELOG/group_9.6222.1010624233'

2019-08-27T22:55:03.350501+04:00

RFS[14]: Assigned to RFS process (PID:22496)

RFS[14]: Possible network disconnect with primary database

2019-08-27T22:55:04.898924+04:00

LOGMINER: Begin mining logfile for session 24 thread 1 sequence 46743, +FRA/DWARE1/ONLINELOG/group_9.6222.1010624233

2019-08-27T22:55:09.886680+04:00

Errors in file /u01/app/oracle/diag/rdbms/dware1/DWARE1/trace/DWARE1_rfs_24468.trc:

ORA-00310: archived log contains sequence 46746; sequence 46745 required

ORA-00334: archived log: '+DATA/DWARE1/ONLINELOG/group_7.623.1010623865'

2019-08-27T22:55:24.732737+04:00

RFS[15]: Assigned to RFS process (PID:24468)

RFS[15]: Selected log 5 for T-1.S-46752 dbid 878411589 branch 951526160

for my downstream replication.

Could you please advise.

There is enough space in FRA.

Thanks,

Joe

Comments
Post Details
Added on Aug 27 2019
0 comments
367 views