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