Heres a summary approach that works:
1. Set the test environment to be identical to live in terms of disks (same
directory names/sizes/etc). If the environments are dissimilar, the process
will take longer and require more manual intervention.
2. Backup the live database (full backup), using RMAN preferably, in the
normal manner.
3. Restore the backup (from tape, or disk if possible) to a point in time
shortly after the backup completed on the test system (ensure all required
archived redo is available). You should be able to follow your standard
restore procedures exactly.
This has the added significant benefit of testing your backup/restore
processes, something you should do regularly anyway.
You need the patience of a saint to sit there for two weeks exporting and
importing data!
HTH,
John
-----Original Message-----
From: rajesh
[mailto:oracledba-ezmlmshield-x80972699.[Email address protected]
Sent: 03 July 2006 12:53
To: LazyDBA Discussion
Subject: DB Restore - Large DB - Best Practices / Techniques
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
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page