Home » RDBMS Server » Backup & Recovery » Build New DB from RMAN
Build New DB from RMAN [message #228669] Tue, 03 April 2007 11:01 Go to next message
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
Re: Build New DB from RMAN [message #228670 is a reply to message #228669] Tue, 03 April 2007 11:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The process is called DUPLICATION or CLONING.
With RMAN you can do a full clone or selective (tablespaces) clone.
Search the forum. There are too many threads talking about the same like this.
http://www.orafaq.com/forum/m/197817/42800/#msg_197817
Also, Look into RMAN documentation. Everything is described in detail over there
Re: Build New DB from RMAN [message #228671 is a reply to message #228669] Tue, 03 April 2007 11:18 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm#446590
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007360
Previous Topic: Use form to database backup
Next Topic: RMAN Duplication to Remote Server Error
Goto Forum:
  


Current Time: Tue Dec 06 12:27:31 CST 2016

Total time taken to generate the page: 0.07427 seconds