Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: copy a database to a different host with a different SID usin g RMAN
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
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