I use Oracle 11g r2 configure a data guard and fast_start fail over (using data guard broker) environment on linux.As Mseberg said, it might due to wron configuraiton, You can again reconfiugre it or drop & recreate the broker configuration.
The data guard works fine, and the fail over too.
The problem is that after fail over, the observer can't reinstate the old primary database to new standby database after start up it to mount, and what strange is that if shutdown (immediate) it again, and start up it to mount again, the reinstating can be completed automatically and successfully.
I use 'shutdown abort' to simulate the database crash.
Any one have some advice? Thanks in advance!
Looks like the standby database does not have the archive destination set.
SELECT DEST_NAME, DESTINATION FROM V$ARCHIVE_DEST WHERE DEST_NAME='STANDBY_ARCHIVE_DEST' ;
Correct. And sorry if I was unclear.
Do you mean delete the broker configuration and then recreate it?