Hi
I am having a strange issue :
I shutdown the redo apply and log shipping on my 10.2.0.4 dataguard configuration for some maintenance window :
edit database <primary> set state='LOG-TRANSPORT-OFF';
edit database <standby> set state='LOG-APPLY-OFF';
At the end of the maintenance period , I tried to resume all :
So I mounted the standby :
startup nomount
alter database mount standby database.
then resumed log shipping :
edit database <primary> set state=’ONLINE’;
and then tried to resume redo apply via the Broker.
But no matter which command I gave , the 'Intended State' ramains : LOG-APPLY-OFF
I tried ( among others ) to set the state to ONLINE , to PHYSICAL-APPLY-ON , to APPLY-ON etc..
Nothing works.
I then resumed the redo apply via sql :
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
and it worked fine.
the redo is applied.
However - the broker now reports an 'error ' :
Current status for "rmandg":
Error: ORA-16765: Redo Apply is unexpectedly online
What do I do to 'sync' my beoker with the real state ?
thanks
Orna