Re: 11g Active Database Duplication
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: mjalsingh@xxxxxxxxx
- Date: Fri, 18 Dec 2009 20:27:05 +0100
I've only done this using OMF (though many times without issues, regardless
of DG names). Set the db_create_file_dest (and db_create_online_log_dest_1)
in your new clone DB and see if that works.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Fri, Dec 18, 2009 at 7:35 PM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:
>
> I thought the active database does NOT make a backup and push it across, it
> pushed the datafiles as they are. Hey any of you internals DBAs is that not
> correct?
>
> I've not done it between 2 different ASM groups but from what I see of your
> command that should work.
>
> joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
> Interested in helping out your marriage?
> Ask me about "Weekend to Remember"
> Feb 12-Feb 14, 2010, Valentine's Day Weekend
> in Akron, OH
>
>
> From: Manmohan Jalsingh <mjalsingh@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx
> Date: 12/18/2009 01:18 PM Subject: 11g Active Database Duplication Sent
> by: oracle-l-bounce@xxxxxxxxxxxxx
> ------------------------------
>
>
>
> 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.
>
>
Other related posts:
