Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN duplicate database query

Re: RMAN duplicate database query

From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Tue, 24 Jul 2001 07:34:30 -0700
Message-ID: <F001.0035341A.20010724072201@fatcity.com>

I am testing the duplicate command now. I don't think you need password file on server A, but you do need a password file on server C. To my understand, you do need 3 connections to make it work. Even you want duplicate days old copy. I think rman somehow needs info from control file on server A. For example, once I reset the database on target. I can't duplicate it with any backupset any more. Anyway, I am still learning and testing it. probably not know better than you do.

Joan

> Hallas John wrote:
>
> Hello listers,
>
> We have a instance on server A, a RMAN recovery catalogue on server B
> and a 3rd server C where we want to create a copy of the live database
> with a new sid.
>
> This is on Oracle 8.1.7
> The RMAN duplicate command seems to be the one to use but there is one
> hing I cannot understand.
>
> All the documentation (and I have RTFM until my head hurts) suggests
> that the run script needs to make 3 connections (target - server A,
> rcat - server B and new instance server C).
>
> I do not know why we need to connect to the target sid (server A) at
> all. We don't want a synchronised duplicate at all but from midnight
> last night (or 3 days ago is fine). Therefore the rcat should all the
> information it requires. Furthermore we don't have
> remote_login_passwordfile created on server A and we don't really want
> to .
>
> As part of the testing we tried setting the dbid to the name of the
> instance we want but it still seems to expect the connection to
> server A.
>
> Anyone have any experience in this area that could help me.
>
> John
>
> Oracle DBA
> BTcellnet
> * john.hallas_at_btcellnet.net
> ( 0113 388 6062
> ) 07710 472498
>
> **********************************************************************
> This email and any attachments may be confidential and the subject of
> legal professional privilege. Any disclosure, use, storage or copying
> of this email without the consent of the sender is strictly
> prohibited.
> Please notify the sender immediately if you are not the intended
> recipient and then delete the email from your inbox and do not
> disclose the contents to another person, use, copy or store the
> information in any medium.
> **********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 24 2001 - 09:34:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US