Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN to copy database

Re: RMAN to copy database

From: David J. Devejian <Nospamwidsith_at_PublicAccessuNIX.com>
Date: Thu, 20 Mar 2003 09:36:31 -0500
Message-ID: <b5cjlf$qsv$1@reader2.panix.com>

"Ronald" <devnull_at_ronr.nl> wrote in message news:67ce88e7.0303200208.51b2c95e_at_posting.google.com...
>

<snip background>

> Hi Dave,
> on the DR site prepare your directories and pfile for the copy
> database. Include db_file_name_convert and log_file_name_convert to be
> able to adjust for differences in pathnames between source and copy
> database. Start the copy instance nomount.
>
> connect catalog rman_user/some_secret_at_your_rman_catalog
> connect target sys/change_on_install_at_your_target_database (acutally
> the source)
> connect auxiliary sys/change_on_install_at_your_copy_db
> run {
> allocate channel x type whatever you need;
> allocate auxiliary channel y type disk;
> duplicate target database to your_copy_db;
> }
>
> This should take you close to what you want.

I appreciate this Ronald. We are not running a catalog however, but rather using the control file. Will this cause a problem? Also, would this need to run on the machine here or at DR? Right now the connection is a 24K dial-up. (This is being improved to a T1 which is not installed yet.) So I am a little concerned about how data is being transfered, as I said, I have tapes down there, imported into the local backup server, but that means they are not available here. (Never underestimate the bandwith of a trunk full of mag tapes. Albeit, theres a terrible latentcy problem. :^)

Off to lookup 'auxiliary channel' and 'duplicate' commands.

Regards,
Dave Received on Thu Mar 20 2003 - 08:36:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US