Stopping log transfer from primary to standby

[Former Member]

Hi All,

We have decommissioned standby. But log transfer is still not stopped. We are getting errors in alert log in primary system as below attachment.

I have thought of changing parameter LOG_ARCHIVE_DEST_3 parameter in primary in pfile and create spfile. Restart the db.

or any other way to do it?? LOG_ARCHIVE_DEST_3 parameter is in spfile is like value SERVICE=ISCS lgwr async reopen=60 verify.

Please guide me the solution.

Regards,

Vishnu

Alert_log_ICS.txt.zip

[JamesZ]

Hi Vishnu,

please provide output of following:

sqlplus> show parameter arch

sqlplus> show parameter standby
sqlplus> show parameter dg

If you don't need data guard, you can just using LOG_ARCHIVE_DEST_1 to ship archive log to primary database own directory.

Best regards,
James

[Former Member]

Hello James,

Please find the output of the following commands in attachment.

We are not using data guard.

Regards,

Vishnu

ISC_output.txt.zip

[JamesZ]

Hi Vishnu,

In this case, you can reset parameters:

log_archive_dest_3

Afterwards the database will isolate from standby scenario.

Best regards,
James