One of the better features of the Oracle SOA Suite 11g is the Error Hospital in which errors are handled uniformly accross SCA components. But you have to think twice before you use error retry mechanisms for a Composite within a SOA!
This because a Composite (or Service) can be used within Service Compositions. This is one of the Service Oriented principles (as can be read within the books of Thomas Erl). So a Service is not aware in which context it is (and may be) used. It can be part of a Business Service. So the Service can not decide how to handle errors and can certainly not have a manual recovery, because in some context this will be wrong.
Just be aware that your SCA Composite can always be a Service Composite member !!