oracle 11g 12c dg環境 SYS密碼同步化的問題

標籤：clu   round   sam   ges   for   ssi   pie   hang   database   

When password file is used for Redo Transport Authentication, the password of redo transport user should be same across primary and all its physical and snapshot standby databases. By default SYS user is used to authenticate redo transport sessions when password file is used.

Till 12cR1 Dataguard setup, if there is a change in password file of Primary database like Changes in password or Changes in admin privileges, then the password file needs to be copied from Primary database to standby database server and rename it according to standby database Instance name. If the password file of Primary and Standby databases are not same, then errors will be seen.

In 12cR2, the password file of standby database gets synchronized automatically when there is a change in Primary database password file. The password file change of Primary will be included in Redo and when the Redo is applied to standby, the synchronization happens in the background.

這裡延伸幾個知識點：

1 、 11g中口令檔案並不能實現存放於asm共用訪問，修改SYS密碼，需要再每個RAC節點手動實施同步 ，同樣備庫的口令檔案也要手動進行更新覆蓋
2、12.1版本可以實現口令檔案ASM共用儲存，RAC中只需要一個節點執行alter user sys 就可以實現主庫所有節點同步，這點是11g中無法實現。但是備庫中口令檔案依然需要手動同步主庫的口令檔案過來覆蓋
3 、12.2版本oracle在口令檔案ASM共用儲存的前提下，實現了口令檔案自動同步主備所有節點

MOS ---
Automatic Password file synchronization in 12.2 Dataguard Standby database

oracle 11g 12c dg環境 SYS密碼同步化的問題