Hi DBA's,
I have a situation.
During one of my testing on a standby i issued a command by mistake " Alter database recover managed standby database finish " , but I didn't want to do a failover.
And now I want to enable MRP by issuing the command "Alter database recover managed standby disconnect from session " I keep getting ora alert in the alert log
"
MRP0: Background Media Recovery terminated with error 16157
Errors in file /var/opt/oracle/diag/rdbms/himmyprd1/himmyprd1/trace/himmyprd1_pr00_13513.trc:
ORA-16157: media recovery not allowed following successful FINISH recovery
"
Is their any way I can start the MRP and set the standby as it was earlier or do I have to rebuild the standby .
DB version 11.2.0.2.0
Regards
Himanshu