Changing SYS Password in Dataguard Environment

If you change SYS password with ALTER USER SYS IDENTIFIED BY NEWPASSWORD on the primary database of a dataguard environment, primary side stops to transfer archivelogs to standby and you will see an error on primary database alertlog file like: —————————————————————— Check that the primary and standby are using a password file and remote_login_passwordfile is…

Dataguard missing archivelog

Below you can find one of the available solutions that can be applied to solve this issue: PRI select max(sequence#) from v$archived_log where applied=’YES’; STBY select max(sequence#) from v$archived_log where applied=’YES’; SQL> select * from v$archive_gap;    THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ———- ————- ————–          1          285           285 RMAN> list ARCHIVELOG FROM SEQUENCE 286 until SEQUENCE…