On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,517 Users
  • 2,269,752 Discussions
  • 7,916,764 Comments

Discussions

Issue with Configuring ODG with Oracle 12.2 on Windows

dba.saravanan
dba.saravanan Member Posts: 5
edited Aug 25, 2020 3:48PM in Data Guard

Hi Experts,

We have configured the ODG parameters as per the standards and getting the below error in Primary and Standby Alert logs. Please Advice !!!

primary Alert Log

2020-08-25T17:05:19.435000+05:30

ARC4: Destination LOG_ARCHIVE_DEST_2 not using standby redo logfiles; cannot reconnect

ARC4: Error 3135 archiving log 0 to 'boilapsdb_stby'

ARC4: FAL archive failed with error 3135.  See trace for details

FAL archive failed, archiver continuing

2020-08-25T17:05:19.700637+05:30

Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\boilapsdb_prim\boilapsdb\trace\boilapsdb_arc4_4976.trc:

ORA-16055: FAL request rejected

2020-08-25T17:12:20.291891+05:30

ARC8: Destination LOG_ARCHIVE_DEST_2 not using standby redo logfiles; cannot reconnect

ARC8: Error 3135 archiving log 0 to 'boilapsdb_stby'

ARC8: FAL archive failed with error 3135.  See trace for details

FAL archive failed, archiver continuing

2020-08-25T17:12:20.573118+05:30

Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\boilapsdb_prim\boilapsdb\trace\boilapsdb_arc8_9100.trc:

ORA-16055: FAL request rejected

Standby Alert Log

2020-08-25T18:07:26.896606+05:30

RFS[95]: Assigned to RFS process (PID:6408)

RFS[95]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[95]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB1J6VK_.ARC

2020-08-25T18:13:27.112276+05:30

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_0_0_HNB1VH2K_.ARC

2020-08-25T18:14:27.811649+05:30

RFS[96]: Assigned to RFS process (PID:384)

RFS[96]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[96]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB1XCRD_.ARC

2020-08-25T18:20:28.006441+05:30

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_0_0_HNB28MYH_.ARC

2020-08-25T18:21:28.586900+05:30

RFS[97]: Assigned to RFS process (PID:5136)

RFS[97]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[97]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB2BJKV_.ARC

2020-08-25T18:27:28.792893+05:30

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_0_0_HNB2ORQS_.ARC

2020-08-25T18:28:29.397203+05:30

RFS[98]: Assigned to RFS process (PID:7740)

RFS[98]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[98]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB2QOCX_.ARC

2020-08-25T18:33:29.591053+05:30

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_0_0_HNB311KH_.ARC

2020-08-25T18:34:30.246263+05:30

RFS[99]: Assigned to RFS process (PID:2948)

RFS[99]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[99]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB32Y5Q_.ARC

2020-08-25T18:40:30.368900+05:30

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_0_0_HNB3G6BK_.ARC

2020-08-25T18:41:30.995195+05:30

RFS[100]: Assigned to RFS process (PID:996)

RFS[100]: Opened log for T-1.S-1145 dbid 2691828122 branch 1046106654

RFS[100]: Possible network disconnect with primary database

Deleted Oracle managed file E:\APP\FLASH_RECOVERY_AREA\BOILAPSDB_STBY\ARCHIVELOG\2020_08_25\O1_MF_1_1145_HNB3J2YM_.ARC

Answers