resynch duplicate oracle DB

From: cptkirkh <khill_at_scic.com>
Date: Wed, 16 Jul 2008 14:05:47 -0700 (PDT)
Message-ID: <8833098c-2bbc-4e1a-aea6-6cc282d4eb2c@k30g2000hse.googlegroups.com>

I have a duplicate database already setup that uses trhe same DBID. If i want to synch that database I found in the books that I can run the following commands:

# start RMAN and then connect to the databases
CONNECT TARGET;
CONNECT CATALOG rman/cat_at_catdb;
CONNECT AUXILIARY SYS/oracle_at_dupdb;

# configure auxiliary names for the datafiles only once

CONFIGURE AUXNAME FOR DATAFILE 1 TO '?/oradata/dup/system01.dbf';
CONFIGURE AUXNAME FOR DATAFILE 2 TO '?/oradata/dup/undotbs01.dbf';
CONFIGURE AUXNAME FOR DATAFILE 3 TO '?/oradata/dup/cwmlite01.dbf';
CONFIGURE AUXNAME FOR DATAFILE 4 TO '?/oradata/dup/drsys01';
CONFIGURE AUXNAME FOR DATAFILE 5 TO '?/oradata/dup/example01.dbf';
CONFIGURE AUXNAME FOR DATAFILE 6 TO '?/oradata/dup/indx01.dbf';

# do not configure an auxiliary name for datafile 7, because it is in
the tools
# tablespace, and you are excluding tools from the duplicate database
CONFIGURE AUXNAME FOR DATAFILE 8 TO '?/oradata/dup/users01.dbf';

# Create the duplicate database. Issue the same command daily
# to re-create the database, thereby keeping the duplicate
# in sync with the target.

DUPLICATE TARGET DATABASE TO dupdb
SKIP TABLESPACE tools
  LOGFILE

    GROUP 1 ('?/oradata/dup/redo01a.log',
             '?/oradata/dup/redo01b.log') SIZE 200K REUSE,
    GROUP 2 ('?/oradata/dup/redo02a.log',
             '?/oradata/dup/redo02b.log') SIZE 200K REUSE;

My question is what does the command "CONFIGURE AUXNAME FOR DATAFILE 1 TO '?/oradata/dup/system01.dbf'; " actually do? Does it register with the recovery catalog what it is doing? Is it makign changes to my source DB? thanks in advance. Received on Wed Jul 16 2008 - 16:05:47 CDT