Copy database to new server and new name
Hi All,I am having some difficulties copying a database to a new server, with new directory structure and new db name.
I followed some info that I found that basically uses rman to::
set NEWNAME FOR DATAFILE xxx
set until sequence xxx
restore database;
switch datafile all;
recover database;
alter database open resetlogs;
I had problems with this because the resetlogs indicated the I needed to recover datafile 1.
Making a long story short, I am able to start up mount the database, but I can not open it because of the above error.
I discovered that I can run a backup right now, while it is mount mode. I'm thinking that the control file right now has bad info,
I followed some info that I found that basically uses rman to::
set NEWNAME FOR DATAFILE xxx
set until sequence xxx
restore database;
switch datafile all;
recover database;
alter database open resetlogs;
I had problems with this because the resetlogs indicated the I needed to recover datafile 1.
Making a long story short, I am able to start up mount the database, but I can not open it because of the above error.
I discovered that I can run a backup right now, while it is mount mode. I'm thinking that the control file right now has bad info,
0