resynch duplicate oracle DB
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