Dear DBAs,

I have an urgent task.

Production DB 9i
Solaris 9
Veritas 6.5
We backup our Oracle production database using Veritas Netbackup 6.5 with RMAN integration to tape.
Is it possible to perform a restore of a production db to a test server (new host) without having any affect upon the production db or the RMAN catalog.
Can the RMAN backup set for a particular db be restored at file level? If so then I could copy the RMAN files to test server and perform an RMAN recover using nocatalog.

The problem is that the Rman backup on tape of Production cannot be accessed by new host.The UNIX admin needs to do something. But all of them are gone.

Test Server Oracle10g on Solaris 10.

I copied pfile,spfile,control file move to new host on different directory & I already change the path of directories in pfile.
I bit confuse how to restore spfile & contrl file from auto backup.
I trying .......!!!!!!!!!!!


Test Server
RMAN> target / nocatalog
RMAN> startup nomount pfile='/export/home/oracle/initpfile.ora'; ---DB started nomount mode.

Q. How I restore spfile & control file from autobackup? I have to connect Target DB with or wihtout Recovery Cat DB....and restore spfile & controlfile does it any affect on production db?


If it is doable, would you please outline the procedure?

If it is not donable, what is the best way for me to finish this task?

Thank you very much!

Regs
Asif