I have a full database + the archive log backup of an oracle database "A" taken on "Host A". I would like to restore it to "Host B" as database "B" with different directory structure.
I also have the rman backed up controlfile.
Could anyone please help?
I tried copying the rman controlfile backup to "Host B" and then tried to restore it under "Database B". But when I tried to mount the database, then it's giving me the error " database is still named A"..
if you can do a sql*net connection between host A and host B, you can use DUPLICATE DATABSE.
otherwise (using version 9iR2) you have to recover database A on host B and have to use the binary nid to change the DB-ID