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 From ASM to ASM

RE: RMAN DUPLICATE DATABASE From ASM to ASM

From: <Ravi_Kulkarni_at_Dell.com>
Date: Fri, 12 May 2006 11:51:47 -0500
Message-ID: <DB108C8A1E08EC448BB22A51DC9FAB62D857A4@ausx3mpc111.aus.amer.dell.com>


If you are not connecting to auxiliary locally, you need a UR=A in the tnsnames.ora

    (CONNECT_DATA = (SID = TESTDB)( UR = A )) -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of oracle Sent: Friday, May 12, 2006 11:46 AM
To: oracle_at_digistar.com
Cc: Oracle Discussion List
Subject: Re: RMAN DUPLICATE DATABASE From ASM to ASM

> RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener:
> all appropriate instances are blocking new connections

I resolved this by juggling the connections around such that I connect to the auxiliary locally by running rman on the auxiliary instance.

That works fine.... but now i've hit another issue...

I'm running a regular backup on the target to write to files on the local hard disk which I copy to the auxiliary host, into the same directory structure, etc.

But when it comes time to issue the duplicate database command it doesn't use the files. crosscheck says they are expired.? strange...

I wish there was a way to allocate a channel that ties into the ASM +FLASH area of the target so the auxiliary can read from that directly instead of having to create files on the local disk, etc.

thanks

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 12 2006 - 11:51:47 CDT

Original text of this message

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