Does Database Recovery really work?

Could some Database recovery experts help to answer my question here?  

My physical file backup was done while the database was up and running. I do not have ARCHIVE LOG turned on.
Files were *.dbf, *.ctl and *.rdo

Did a restoration of the database and it gave an error on the system01.dbf file, so i did a

        svrmgrl > recover database
Then, The database started perfect, looks normal, no errors. I assume that there were not much activity (prob no activity) during the backup so the redo logs were used to reapply to the database during recovery. Everything looks normal but when I was doing my transaction query, some order by or group by statements, it gave some Internal error. Is the database in a correct state? Is there any tool I can use to verify it? How trustworthy is it?

I've gone thru the Database Recovery class and theorically, this should work but now I have my doubts about the recovery. Can anyone advise on this? Greatly appreciate your help.

Thanks,
Cynthia Received on Mon Aug 17 1998 - 02:41:27 CDT