Where does dbca get its info

Dear all,

I am writing a unix script to do a cold backup (and restore) of oracle instances. The backup script is supposed to be able to shutdown the instance and copy all related files to a tape.

At this point, the backup script is doing what it is supposed to do and i am happy with that. The next step is to delete the database using DBCA and try to restore them again from the tape. So I wrote a restore script. I just copy back whatever files in the tape to their original locations. The script is smart enough to reenter the listener.ora and tnsnames.ora entries. And when I did the restore, the instance is up and running. It seems fine to me.

However, when I tried to delete the instance again for another round of testing, the instance name somehow is not registered in DBCA. So now I cannot delete it using that tool. Of course, I could remove all the files manually to clean it up. But my question is, where does the DBCA tools get its info. Which files is it reading that I did not update in my restore script?

I have used 'grep' to search the common oracle and database directories for any hint of where the dbca keep its things but so far I could not find it. Please help.

Regards
Ujang Received on Sat Mar 19 2005 - 20:36:09 CST