Try to run “sbttest SBT_TAPE” over and over until the command pass the validation, it’s 99% due to file/directory permssion issues, make sure oracle have sufficient right to access backup library.
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
Table of Contents
2. Parameter file
4. Redolog files
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.