Hello,
I am new to Oracle DBA.
My client is having database version 10.1.0.5.0 and OS is Windows Server 2003.
He is having two environment Production and Test Environment.
Test Environment is already having an old data.
But Client wants to refresh test environment data with production environment.
Production Environment is having ORACLE_SID=prod and Test Environment is having ORACLE_SID=test.
I have taken full backup of Production Environment using RMAN utility.
Now I want to restore it in Test Environment(ORACLE_SID=test). I have seen some videos for restoring database
but it shows that the I have to create new ORACLE_SID with name "prod" in Test Environment.
Test Environment and Production environment structure is same.
Is there any way to restore/refresh database in Test Environment with ORACLE_SID=test using RMAN utility?
Its urgent.
Waiting for your reply !!!!!!
Thanks.