Re: On which server run RMAN when duplicating database

  • From: Mark Strickland <strickland.mark@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Wed, 15 Apr 2009 07:57:22 -0700

You can run it on either server.  I do a lot of RMAN duplications and I tend
to run it on the standby server.  Been a while since I looked at best
practices docs and I'm not sure if there's a particular reason to run it on
one server or another.  Others may have a stronger opinion about it.
Wherever you run it, you'll need a tnsnames entry for the other server.  If
you run it on the primary server your connections would be something like:

connect auxiliary sys/password@standbydb
connect target /
connect rman/rman@rcat

If you run it on the standby server, they would be something like:

connect auxiliary /
connect target sys/password@primarydb
connect rman/rman@rcat

Mark Strickland

On Wed, Apr 15, 2009 at 6:53 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:

>  I am reading the duplicate chapter of Robert Freeman's RMAN book.
> If I copy the backup files from server A to server B as mentioned in the
> book, do I then run RMAN on server B.  If so, I understand that I will need
> a tns entry on server B back to the database on server A so RMAN can connect
> to the target.  Is this correct?

Other related posts: