Re: Where does dbca get its info

"Ujang M Zainudin" <Ujang_mz_at_yahoo.com> wrote in message news:21fa36fa.0503191836.58a7318_at_posting.google.com...
> 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

the oratab Received on Sun Mar 20 2005 - 07:37:07 CST