RE: copy a database to a different host with a different SID usin g RMAN

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 9 Sep 2004 21:55:14 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D610B9842C@EXCHMN3>

Roger - There are three ways to accomplish this. 1. Use the RMAN DUPLICATE command. This may be the easiest. You may need to use RMAN in catalog mode, but that is not so difficult to configure. This can be done with the production database online. If you don't have Robert Freeman's fantastic RMAN book, get it.
2. Take an RMAN online backup on the production system to disk. Recover that backup on your test server. No need for a catalog on either server. The advantage of this method is that you have just performed a disaster recovery. Always a good idea.
3. Take an RMAN online image backup on the production system. This does not require RMAN on the test server, but can be recovered just like any other file backup. Or so the documentation states. Never tried this one myself, just see it in the documentation and Robert Freeman's book.

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Thursday, September 09, 2004 4:12 PM To: Oracle-L_at_Freelists. Org (E-mail)
Subject: copy a database to a different host with a different SID using RMAN

Hello,

We_need_to_refresh_our_test_system_with_production_system's_data. I_want_to_do_this_using_Oracle_RMAN_backup_and_restore. Anyone_has_this_kind_of_experience?

840_GB_database_with_910_GB_allocated_space

SAP_4.6C
Oracle_9.2_(RMAN_to_disk_without_a_catalog) Solaris_9

We_do_not_plan_to_shutdown_production_while_doing_this.

Thanks,

Roger=20Xu

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20
=

to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20

=

entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Received on Thu Sep 09 2004 - 21:52:29 CDT