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 -> Creating standby database: Why need to copy backup pieces to standby site manually?

Creating standby database: Why need to copy backup pieces to standby site manually?

From: Ronny <nitelyjoy_at_ist-einmalig.de>
Date: 15 May 2007 13:48:39 -0700
Message-ID: <1179262119.238334.322340@n59g2000hsh.googlegroups.com>


Hello,
I created a standby database (version 10.2.0.3 on Linux) by following the instructions of metalink Note:183570.1 (which was written for version 9i). Simplified spoken, you have to do the following (executed on primary site), which I did successfully:

a)
rman target /
RMAN> Backup Database;
RMAN> Backup current controlfile for standby;

b)
Copy the backup pieces to the remote server (same directory).

c)
rman target / auxiliary sys/change_on_install_at_STANDBY RMAN> duplicate target database for standby dorecover; ...

Now my questions:
- Why is it necessary to transfer the files to remote standby server
with OS commands (step b)?
- Why does Oracle not use SQLNet to transfer the files? (Or do I just
not know how to do so?)
- If not possible today: Does Oracle plan to provide this feature in a
future release?

My considerations behind:
At the point of time, when the standby database is setup ready and running well, it receives the archived redolog files from the primary site over a SQLnet connection (--> log_archive_dest_2 = 'SERVICE=STANDBY LGWR...' or similar) and there is no need to copy any file either with OS commands nor over a NFS share. The file transfer is done by only using the SQLnet protocol. So I wonder why Oracle does not use this technology for the RMAN 'duplicate .. for standby' command as well...?

Thank you for your posts.
NitelyJoy Received on Tue May 15 2007 - 15:48:39 CDT

Original text of this message

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