Hi everyone,

I have had a corruption on my oracle server so I went to restore from one of my RMAN backups but when i connected to the target database it said i was connected to my test db (it even showed the test db id). the user i used to log into the target doesnt even exist on the test db so something has gone seriously wrong. Does anyone have any wisdom to impart on this?

Assuming that my recovery catalog is shot to pieces would it be possibe to create a new recovery catalogue and import my backupset into this catalog for restoration?

Any help would be greatly appreciated as i have run out of finger nails to chew and caffeine will only keep me awake so long.

Thanks