Use RMAN for hot backups. I have a 1.7tb db, I can do a level 0 RMAN
in about 4 hours, it takes 7 to restore. (This is an oracle 11i erp
installation, with about 20 active modules, I'm using Tivoli as my
access to tape, and using about 6 tape drives - no disk pool). I
restore this completely at least once a month to a test or
development server using the duplicate database feature of
RMAN. There is Zero production downtime for this.
Learn RMAN, it is your friend.
At 21:38 7/2/2006, 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