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