暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Data Guard 从12.2 开始源端修改SYS 密码备库无需做操作

原创 silence 2023-05-17
312

数据库升级到19.18.0.0 后使用alter 修改源库的SYS 密码,备库端不会因修改密码中断。


参考 Doc ID 2307365.1

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.

Exception: Far-sync Instances (where the redo will not be applied). We need to manually copy the password file. Once the password file is sync at Far-Sync instance, 

the redo having password file information will get transmitted to standby which are suppose to receive from Far-sync instance.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文章被以下合辑收录

评论