Clears all databases (recovery,error,ICL) ===>>
setroot
setsite xxxxxx (where xxxxxx is your site name)
hcidbinit -A -C
Don’t forget to clear your the databases before running otherwise you may lose messages.
Usage:
hcidbinit [-A] [-r] [-e] [-i] [-C] [-f]
Where:
-A = initialize ALL databases
-r = initialize the recovery databas
-e = initialize the error database
-i = initialize the ICL registry dat
-C = clean control files
-f = force execution, skip query