Re: RMAN Duplicate Guide for Remote Backup/Archivelogs Location ?

From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 2 Mar 2010 16:04:28 +0000
Message-ID: <713d96d11003020804t13e453f6we7167a39a2d6390a_at_mail.gmail.com>

I have found that RMAN tends to look on the SAME server But see below. You can use links to point to files on other machines but I have also found that

the duplicate is slowed down hugely if you do this. The time taken to copy over giving huge benefits over any convinience factor.

This script - will in 11g anyway duplicate by pulling data from another server.
Set ORACLE_SID=targetdb

rman target=sys/easyeasy_at_sourcedb log=dupclone2.log append catalog=rman/easyeasy_at_rman auxiliary=/ _at_script

script below.

RUN
{

allocate channel C1 device type disk;
allocate channel C2 device type disk;
allocate channel C3 device type disk;
allocate auxiliary channel A1 device type disk;

allocate auxiliary channel A2 device type disk; allocate auxiliary channel A3 device type disk;

 #set newname for tempfile 1 to "/u04/oradata/triples2/temp01.dbf"; duplicate target database for standby nofilenamecheck; #duplicate target database to triplesp ; }

You might want some set newnames.

For some reason which I think is due to auto registration with tns a push errors as it cannot connect to the target which is not up.

On 2 March 2010 15:53, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> Anyone have a good guide for using RMAN duplicate when Archivelogs and
> Backups of the primary db are on a different server?
>
>
>
> Typically I copy the backups/archivelogs to the server where I’m going to
> be doing the duplicate but I know I saw somewhere recently where you didn’t
> have to do that step and RMAN would know where to pull the backups and
> archivelogs from.
>
>
>
> I’m using 10.2.x if it matters.
>
>
>
>
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
>
>
>
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 02 2010 - 10:04:28 CST