Skip to Main Content

Database Software

Issue with Configuring ODG with Oracle 12.2 on Windows

dba.saravananAug 25 2020 — edited Aug 25 2020

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

Comments
Post Details
Added on Aug 25 2020
1 comment
72 views