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
> * [EMAIL PROTECTED]
> ( 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
