Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> RMAN restore to a new server question.
I have been tasked with cloning our prod db to a new server from an
rman backup(with a catalog) on tape to a new server in another data
center. I have installed oracle on the new server and have copied the
init file and started up the db. I created a new catalog user in the
new datacenter. I have no experience with rman but have been reading
up and think I am on the right path. Can anyone confirm?
STARTUP NOMOUNT rman TARGET / NOCATALOG
RMAN> set DBID 2796110657
{
allocate channel t1 type "sbt_tape"
parms="BLKSIZE=524288,SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so.
1";
restore controlfile to '/CCTPROD/oradata/control01.ctl';;
ALTER DATABASE MOUNT;
SET newname FOR DATAFILE 9 TO '/NEWPROD/oradata/statsdata1.dbf';
SET newname FOR DATAFILE ... SET newname FOR DATAFILE ... SET newname FOR DATAFILE ...(renaming all of the datafiles to the newlocation)
![]() |
![]() |