Hi,
Our E-Biz Database is a little over 700Gb. We use a combination of Physical Standby database and BCVs to make a snapshot, which is then mounted on on the Dev/Test Server and copied to the correct location.
By using the Physical Standby, we have zero downtime for Production. I did a clone last week, and the Db Copy took about 12-14 hours. This will vary, depending on where your mount the disks. For example, if we did an NFS mount, then I would expect the network to be the bottleneck.
I would stay well away from export/import for creating your test environments. Firstly, because it takes too long, and secondly because it is not a physical copy of your Production Database .
Cheers,
Paul
*********** ORIGINAL MESSAGE ***********
On 3/07/2006 at 5:23 PM rajesh wrote:
Hi Gurus,
We have a database of around 400 GB (OLTP db and high usage with weekend
downtimes, 9i db and RAC environment) and it is tough for us to restore
the same into the backup environment. It takes ages to restore the data
through export / import (atleast around 2 weeks) and we do not want to
go thru this route.
Expert advice needed to know the best ways / practices in which we can
have copies of the production database easily in the TEST environments.
Let me know in case you need any other info.
Thanks and Regards,
Shenzy
DISCLAIMER:
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system.E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted,corrupted,lost,destroyed,arrive late or
incomplete or contain viruses.The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required
please request a hard-copy version.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page