Dataguard ora-16191 solve the problem of different steps

Source: Internet
Author: User

The company's 11g Dataguard master is not in sync, check the steps as follows:

Primary: Querying the maximum log for the main library
Sql> select Max (sequence#) from V$archived_log;
Sql> select Max (sequence#) from V$archived_log where applied= ' YES ';

Standby: Querying the maximum log for a standby library
Sql> select Max (sequence#) from V$archived_log;
Sql> select Max (sequence#) from V$archived_log where applied= ' YES ';


Query whether the main library logs are consistent with the standby library

Sql> Select sequence# from v$archived_log where recid = (select Max (recid) from v$archived_log) and applied = ' YES ';
Sql> Select sequence# from v$archived_log where recid = (select Max (recid) from V$archived_log);

is the log of the Champer library already consistent?

SELECT sequence#,applied from V$archived_log ORDER by sequence#;

2 sides of the log are found to be inconsistent. The reason for this synchronization is that the log does not pass through, and then go to the main repository over the OS, the log still exists, that is, the transmission of the problem.

Then view the status of the archive log for the main library:

Sql> Select Dest_name,status,error from V$archive_dest where rownum<3;

Dest_name STATUS ERROR
-------------------- --------- -------------------------------
Log_archive_dest_1 VALID
Log_archive_dest_2 ERROR ora-16191:primary Log shipping Client not logged on standby

Discover the status of the transfer to the repository is error, error ora-16191, Official document Description:

Ora-16191:primary Log Shipping Client not logged on standby

Cause:an attempt to ship redo to standby without logging in to standby or with invalid user credentials.Action:check that primary and standby is using password files and that both primary and standby has the same SYS PA ssWOrd. Restart primary and/or standby after ensuring, password file is accessible and Remote_login_passwordfile Initializatio n parameter is the set to SHARED or EXCLUSIVE.Finally, the inspection found that the main repository of the SYS password inconsistency caused by the main library of the ORAPW file copy to the repository, and then modify the name of Cheng Beiku, it is resolved.

Dataguard ora-16191 solve the problem of different steps

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.