开发者

Oracle Data Guard - What are the changes to make on standby database which is a mirror copy of the primary database

开发者 https://www.devze.com 2022-12-29 23:27 出处:网络
After setting up primary database which is setup with Raid1. I break the mirror and physically transfer it to the standby database hardware and did a Raid1 sync. With that I have exact replicate of th

After setting up primary database which is setup with Raid1. I break the mirror and physically transfer it to the standby database hardware and did a Raid1 sync. With that I have exact replicate of the primary database on the standby database.

However, since the standby database's data is exactly the same as primary database, I have to change it to become the standby database.

example:

Primary database server oracle_sid=chicago

Standby database server oracle_sid=chicago (since its a replicated data)

I need to change the standby databas开发者_如何学Ce oracle_sid to boston.

I believe it is not a simple case of changing the oracle_sid to boston since the database name is chicago.

Appreciate any specific and detailed steps to make the changes.


You should probably ask this on Serverfault. However, I'll mention here using Recovery Manager (instead of your method) to create the standby database will eliminate most of the manual work in renaming the database, recreating the control files, etc.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号