Copy database - change SID

From: Gunter <gunter_at_technologist.com>
Date: 2000/03/12
Message-ID: <38cbfb11.18394329@192.168.0.2>#1/1

Hi everybody!

I want to copy an ORACLE Database without usage of IMPORT/EXPORT-utility and give the new database another System ID. First I set up a destination DB with a new System ID. Then I exported the control-file and edited the paths of the data-files. Next step was copying the data-files from the source database to the new db and restoring the control-file from the edited backup-control-file. And at this point something went wrong: At startup the datafiles needed to be recovered with an archived log-file that did not even exist.

Any help would be appreciated.

Regards,

Gunter.
---gunter_at_technologist.com--- Received on Sun Mar 12 2000 - 00:00:00 CST