Database Software

Hello Experts,
I had a DB with Rman,Legato Networker and without catalog.
Months ago the db was moved from one old windows server to other newer with the same
version of db 10.1.0.2 and same windows 2003 platform.
So far everythings is fine.

Now i have to test the backup of the production DB (new PROD) on the old machine(old Prod) this old machine still having the oracle installation
and the oracle instance PROD(old) without datafiles also the legato networker remains.


How should i handled this ?
I was thinking do the following at the (oldProd) DB:

edit the tnsnames in order to be able to connect to (new PROD) DB

As I have the same name of the DB i will set as PRODNEW the connection
Shall (new PROD) Db connect to (old prod) db via tnsnames also ?

At the older server open rman and connect to the (new PROD) PRODNEW

RMAN>shutdown;
RMAN>startup mount;
RMAN>rman target sys/password@PRODNEW
RMAN>
RMAN>Run
{
allocate channel ch01 type ‘SBT_TAPE’ parms ‘ENV=(NSR_SERVER=legatoServer, NSR_DATA_VOLUME_POOL=oracle)';
allocate channel ch02 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=legatoserver, NSR_DATA_VOLUME_POOL=oracle)';
restore database;
recover database;
}


If i execute the steps above the recover will be performed on the (old Prod) db or the (New PROD) DB ?
Im really worried about whether the recover will be performed at the (New PROD) DB :s because this is my Real,Online and Production System.

Are the commands correct or might i execute or consider something else ?

The restore will bring the controlfiles or shall i copy the control file before the restore?


I was reading about the Duplicate command but as far i understand is for rman with catalog.


Regards & Many Thanks in advance for your help,
E.

Edited by: OraDarma on 17/11/2008 05:00 PM