MRP0: Background Media Recovery terminated with error 19909

How to solve ORA-19909 error when re-sync dataguard, when the standby database shutdown ungracefully, sometime you may found an error when you put the standby database back online, in this scenario, I try to active the standby database and flash back to standby mode in order to let standby database re-apply archive logs again.

Error message as below

MRP0: Background Media Recovery terminated with error 19909

ORA-19909: datafile 1 belongs to an orphan incarnation

Continue reading “MRP0: Background Media Recovery terminated with error 19909”

Oracle RAC – VIP Issues

I try to summarize here some of the errors and its solutions i got while running a Oracle 10g R2 Real Application Cluster (RAC)

starting VIP application resource on (2) nodes1:CRS-1006: No more members to consider
CRS-0215: Could not start resours ‘ora.hostname.vip’
: Check the log file /u01/app/oracle/product/10.2.0/crs/log/hostnamel/racg/ora.hostname.vip.log

I got this issue resolved by specifying the default gateway to some dummy ip address (same subnet) in both of my virtual machines. Earlier i didnt specify any default gateway both in my virtual machines and got this error, also while your network interface was unplugged, it will getting this error too.