Skip to Content
author's profile photo Former Member
0
Former Member

Stopping log transfer from primary to standby

Posted on Aug 18, 2016 at 12:41 PM 22 Views

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 (555 B)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo James Zhang
    James Zhang
    Posted on Aug 22, 2016 at 06:16 AM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.