Wednesday, 1 October 2014

ORA-16571: Data Guard configuration file creation failure

            Tanımı


Cause: The Data Guard broker was unable to create the configuration file on permanent storage.

Action: Verify space, permissions and file name as indicated by the DG_BROKER_CONFIG_FILE[1|2] initialization parameters and retry the operation.


Çözümü
Dataguard broker yaratırken 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\DRAAA01.dat';

  System altered.

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

  System altered.

  SQL> alter system set dg_broker_start=true;

  System altered.
 

No comments:

Post a Comment