| Build New DB from RMAN [message #228669] |
Tue, 03 April 2007 11:01  |
feroze
Messages: 144
Registered: September 2005
Location: chicago
|
Senior Member |
|
|
Hi,
We have daily running RMAN Backups in Production database,
the requirement is to get whole Production database ( with Whole Data and objects , every thing )
and build up this new UAT Environment,
In the UAT Database it's clean no objects only users ,
Tablespaces are same size and names as of Production.
How can i build this UAT Database from RMAN backup from production
The Rman files are in different server so i am doing FTP to those files and bringing in
UAT Box and will unzip it , then what are the next steps.Do i have to remove database also and start building from RMAN
or this empty database just Recovery should bo done or what ?
Previously we did by Export then Import
the drawbacks of this approach was, Export was taken from Live Production Database so we have to do lot
of cleaning work in database since there were child records without Parent ( I know with RMAN also
we have to expect this constraint issue )( But no other option since it's a 24/7 system ), and moreover import was taking
too long ( since it was some 500 GB database with data and Indexes ), so this we thought of using
RMAN for the same,
If anyone has done a similar approach please share the steps
Oracle Version is 9.2
O/s Solaris 5.9
Same in both the Databases
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
