如何重置/移除 DG链路

原创 xusmallhorse 2023-08-24

295

A) On the Primary database:

a) Go into sqlplus and remove it's configuration from the LAD parameter:

   sql> show parameter log_archive_dest_n
   sql> alter system set log_archive_dest_n='' scope=both;             << use sid='*'; at the end if you are RAC
sql> show parameter log_archive_config
   sql> alter system set log_archive_config='dg_config=(PRIMARY,STANDBY1,STANDBY2)' scope=both;         << use sid='*'; at the end if you are RAC

b) If the fal_server is pointing to the Standby you are removing,then you need to remove it from the fal_server parameter:

sql> alter system set fal_server='STANDBY1,STANDBY2' scope=both; << use sid='*'; at the end if you are RAC

B) On the Standby database:

Note: If you are going to remove the standby from it's machine, then you don't need to do the following.

a) Reset any log_archive_dest_n parameters that may be pointing back to the primary or the other standby

sql> show parameter log_archive_dest_
sql> alter system set log_archive_dest_n='' scope=both; << use sid='*'; at the end if you are RAC

b) remove the log_archive_config parameter

sql> alter system reset log_archive_config scope=both; << use sid='*'; at the end if you are RAC
or you can set like: SQL> alter system set log_archive_config=NODG_CONFIG scope=both sid='*';

来自：

How to Remove One Standby Database from a Data Guard Configuration (Doc ID 2196935.1)

最后修改时间：2023-08-24 09:51:26

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者