Wednesday 1 October 2014

ORA-16532: Data Guard broker configuration does not exist



Cause: A broker operation was requested that required a broker configuration to already be created.
Action: Create a Data Guard broker configuration prior to performing other broker operations.

 Dataguard broker yaratırken standby database'de oluşan hatadır. Çözümü oldukça basit :

  SQL> show parameter dg_

  NAME                                 TYPE        VALUE
  ------------------------------------ ----------- ------------------------------
  dg_broker_config_file1               string
  dg_broker_config_file2               string
  dg_broker_start                      boolean     TRUE


  SQL> alter system set dg_broker_start=false;

  System altered.

  SQL> alter system set dg_broker_config_file1='C:\app\oracle\product\11.2.0\dbhome_1\database\DRESK01.dat';

  System altered.

  SQL> alter system set dg_broker_config_file2='C:\app\oracle\product\11.2.0\dbhome_1\database\DRESK02.dat';

  System altered.

  SQL> alter system set dg_broker_start=true;

  System altered.

Bundan sonra DGMGRL komut satırından tekrar konfigürasyon enable edilir.

  DGMGRL-> enable configuration;

No comments:

Post a Comment