oracle 11g 12c dg環(huán)境 SYS密碼同步的問(wèn)題

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.

這里延伸幾個(gè)知識(shí)點(diǎn)：

1 、 11g中口令文件并不能實(shí)現(xiàn)存放于asm共享訪問(wèn)，修改SYS密碼，需要再每個(gè)RAC節(jié)點(diǎn)手動(dòng)實(shí)施同步 ，同樣備庫(kù)的口令文件也要手動(dòng)進(jìn)行更新覆蓋
2、12.1版本可以實(shí)現(xiàn)口令文件ASM共享存儲(chǔ)，RAC中只需要一個(gè)節(jié)點(diǎn)執(zhí)行alter user sys 就可以實(shí)現(xiàn)主庫(kù)所有節(jié)點(diǎn)同步，這點(diǎn)是11g中無(wú)法實(shí)現(xiàn)。但是備庫(kù)中口令文件依然需要手動(dòng)同步主庫(kù)的口令文件過(guò)來(lái)覆蓋
3 、12.2版本oracle在口令文件ASM共享存儲(chǔ)的前提下，實(shí)現(xiàn)了口令文件自動(dòng)同步主備所有節(jié)點(diǎn)

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