快速解除oracle dataguard的方法-牛翰网

1，备份spfile到pfile

为了保存目前数据库的参数配置信息，便于以后查看数据库配置改动，我们备份现有的spfile文件到pfile。

SQL> create pfile='/HW551001/pfile20250301.ora' from spfile;
File created.

保存的参数文件内容如下：

2，调整主库模式

SQL> alter database set standby database to maximize performance;
Database altered.

3，修改主库dg配置参数

SQL> alter system reset log_archive_config scope=spfile;
System altered.
SQL> show parameter fal
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      STD
fal_server                           string      STDDG
SQL> alter system reset fal_client scope=spfile;
System altered.
SQL> alter system reset fal_server scope=spfile;
System altered.
SQL> alter system reset log_archive_dest_state_2 scope=spfile;
System altered.
SQL> alter system reset log_archive_dest_2 scope=spfile;
System altered.