Hi,
Please use SET in create controlfile statement if you are going to change
the DB Name.
CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG
thnx
Venkat
CHAN Chor Ling Catherine (CSC) wrote:
Hi,
Qn : Is it possible to copy one database to another if the source database
name is different from the target database name ?
I need to clone Oracle Applications 11I from one machine (source
instance:PROD) to another (target instance:TEST). I
Dear New Bee:
We do this all the time, and the problem you're having is
the one that I tripped over my first time, too.
There is an important word missing from your command.
It's not...
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG
...it is ...
CREATE CONTROLFILE REUSE SET