Hi all,
I'm testing setup of primary and standby database and everything seems to work normally.
Now, I want to set up DG Broker so I can test switching it over and back.
So, I went through steps by Gavin (ref. http://gavinsoorma.com/2010/03/11g-data-guard-broker-dgmgrl-configuration-quick-steps/).
All went well until I showed configuration after enabling the broker.
Then I got error: ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
So, then I check the DG log files and on the standby database, I see errors:
2013-03-26 11:03:52.457 Executing SQL [ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH sid='*']
2013-03-26 11:03:52.457 SQL Execution error=604, sql=[ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH sid='*']. See error stack below.
2013-03-26 11:03:52.457 ORA-00604: error occurred at recursive SQL level 1
2013-03-26 11:03:52.457 ORA-02097: parameter cannot be modified because specified value is invalid
2013-03-26 11:03:52.457 ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
2013-03-26 11:03:52.458 RSM0: Failed to set property LogArchiveMinSucceedDest
2013-03-26 11:03:52.458 RSM0: return status of set property 'LogArchiveMinSucceedDest' is ORA-16788
2013-03-26 11:03:52.458 02010000 1827537550 Operation EDIT_RES_PROP canceled during phase 1, error = ORA-16788
2013-03-26 11:03:52.458 02010000 1827537550 DMON: Entered rfm_release_chief_lock() for EDIT_RES_PROP
2013-03-26 11:03:52.460 02010000 1827537550 DMON: EDIT_RES_PROP operation completed
So now, i check the DG InconsistentProperties
First, standby: tststby2
================
DGMGRL> show database 'tststby2' InconsistentProperties;
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
tststby2 LogArchiveMinSucceedDest 1 1
Then, primary: tstprim2
================
DGMGRL> show database 'tstprim2' InconsistentProperties;
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
So, looking now in the database, I check standby and it shows:
log_archive_min_succeed_dest integer 1
And, checking primary, it shows:
log_archive_min_succeed_dest integer 1
Okay, so what's next?
I tried resetting the LogArchiveMinSucceedDest to see if that would help, but it just gave me error.
DGMGRL> edit database 'tststby2' set property 'LogArchiveMinSucceedDest'=1;
Error: ORA-16788: unable to set one or more database configuration property values
I do see that my LOG_ARCHIVE_DEST_STATE_2 is set to ENABLE in primary, and is set to DEFER in standby, but it doesn't seem to let me change it in standby.
What else can I check?
Adding a couple of more things that might shed light on this:
======================================
on tstprim2 (primary)
==============
SQL> sho parameter convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string tststby2, tstprim2
log_file_name_convert string tststby2, tstprim2
on tststby2 (standby)
==============
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string tstprim2, tststby2
log_file_name_convert string tstprim2, tststby2
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
--------- --------------------
...
ARCH CLOSING
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG <== as you can see, the standby database is working properly
35 rows selected.
Edited by: 974632 on Mar 26, 2013 9:06 AM