Re: resynch duplicate oracle DB

On Jul 16, 4:05 pm, cptkirkh <kh..._at_scic.com> wrote:
> 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.

I want to add my duplicate DB is on a remote host with the same file structure. Both machines are runnign Oracle 10gR2 on Windows 2003 server. Received on Wed Jul 16 2008 - 16:08:54 CDT