Home » RDBMS Server » Backup & Recovery » fast copy/duplicate of database (NetApp/time finder-SRDF/BCV)
fast copy/duplicate of database (NetApp/time finder-SRDF/BCV) [message #270448] Wed, 26 September 2007 22:28 Go to next message
turnit
Messages: 2
Registered: September 2007
Location: USA
Junior Member

Whats is the fastest way to create a copy of a database. I have a once a week request to copy production database into downstream(dev/qa/UAT) environments. DB Size :350Gb



SO, basically it takes me about half a day atleast to finish this

Considering moving to NetApp storage, to take advantage of the snapmirror capabilities
I guess we can do SRDF/BCV techinique too but needs ton of additional storage

will appreciate thoughts on the above and also suggestions of any other better way too..
Re: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV) [message #270451 is a reply to message #270448] Wed, 26 September 2007 22:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Transport_tablespaces feature.
Re: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV) [message #270535 is a reply to message #270451] Thu, 27 September 2007 06:47 Go to previous messageGo to next message
turnit
Messages: 2
Registered: September 2007
Location: USA
Junior Member

Well with Transportable tablespaces we still have to export metadata/copy files at the OS leveel /import data.. still a lot of time and a ton of manual steps ...

It does not solve the time issue

Re: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV) [message #270763 is a reply to message #270535] Fri, 28 September 2007 00:01 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Using Rman to create copy of database.

Babu
Re: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV) [message #270765 is a reply to message #270448] Fri, 28 September 2007 00:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Use STREAMS & it is down continually & in real time.
You can't get faster than that.
Previous Topic: Duplicating a database AND maintaining it
Next Topic: Duplicate database
Goto Forum:
  


Current Time: Sat Dec 14 17:23:38 CST 2024