Re: 11g Active Database Duplication
Date: Fri, 18 Dec 2009 14:13:10 -0800 (PST)
Message-ID: <160454.80915.qm_at_web113204.mail.gq1.yahoo.com>
Yeah, well, I've been wrong before too.... And I find it blasted embarrassing! :) I always feel this little cringe of fear when I reply to a post that I'll say something that is incorrect or wrong.
RF
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!
From: "Blanchard, William" <wblanchard_at_societyinsurance.com> To: robertgfreeman_at_yahoo.com; mjalsingh_at_gmail.com; oracle-l_at_freelists.org Sent: Fri, December 18, 2009 2:26:16 PM
Subject: RE: 11g Active Database Duplication
Lol. You must just give Oracle Support fits.
<Oracle Support>It works like this...</Oracle
Support>
<you>Um, no it doesn't, it works like this and here's
how I know it...</you>
WGB
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman
Sent: Friday, December 18, 2009 3:23 PM
To: mjalsingh_at_gmail.com; oracle-l_at_freelists.org Subject: Re: 11g Active
Database Duplication
>>
Oracle support told me that RMAN first creates a copy backup of the primary
database on **source server** and then transfer it to target
>> to
build the clone copy.
I can tell you that Oracle support is WRONG on that
one! No copy/backup of the database is made. The network transfer takes off
almost immediately and you can watch the traffic as it goes. I'd ask them to
support their assertion with some real documentation.
RF
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle
Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN
Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database
11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database
11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle
Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new
blog series on installing Oracle Database 11gR2 on Windows using VMWare!
From: Manmohan Jalsingh
<mjalsingh_at_gmail.com>
To: oracle-l_at_freelists.org
Sent: Fri, December 18, 2009 11:17:14 AM Subject: 11g Active Database
Duplication
Hi ,
Has anyone used this feature (in version
11.1.0.7) successfully to clone a database between two servers which uses
different ASM
diskgroups. I am trying to create a clone using following rman
script which is failing during restore. Oracle support told
me that RMAN
first creates a copy backup of the primary database on **source server** and
then transfer it to target to build the clone copy.
Is that correct?
Why it needs to create a copy on source ?
run {
DUPLICATE TARGET
DATABASE
TO 'DUPDB'
FROM ACTIVE
DATABASE
db_file_name_convert='+DATA1/ORCL','+DATA2/DUPDB'
}
Errors
during the restore -
Starting backup at 17-DEC-09
allocated channel:
ORA_DISK_1
channel ORA_DISK_1: SID=376 instance=orcl3 device
type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file
number=00007 name=+DATA1/orcl/datafile/index.500.704464441
RMAN-03009:
failure of backup command on ORA_DISK_1 channel at 12/17/2009
12:15:47
ORA-19504: failed to create file "+data2"
channel ORA_DISK_1
disabled, job failed on it will be run on another
channel
Thanks
Manmohan.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 18 2009 - 16:13:10 CST