Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

duplicate from active database

Ora_83Dec 3 2014 — edited Dec 4 2014

Hi


duplicate from active database command fails since the archivelog destination is not same on source and target database, what do i need to do ?


ie :

target : +FRA

Auxulary: +RECOVER



connect target
connect auxiliary
run
{
SET NEWNAME FOR DATABASE TO '+DATA2';
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate auxiliary channel ch1 device type disk;
allocate auxiliary channel ch2 device type disk;
duplicate target database to dpsu from active database
logfile
group 1
(
'+DATA','+RECOVER'
) size 500M reuse,
group 2
(
'+DATA','+RECOVER'
)size 500M reuse,
group 3
(
'+DATA','+RECOVER'
)size 500M reuse,
group 4
(
'+DATA','+RECOVER'
)size 500M reuse,
group 5
(
'+DATA','+RECOVER'
)size 500M reuse,
group 6
(
'+DATA','+RECOVER'
)size 500M reuse,
group 7
(
'+DATA','+RECOVER'
)size 500M reuse,
group 8
(
'+DATA','+RECOVER'
)size 500M reuse;
}


Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-03113: end-of-file on communication channel
RMAN-03015: error occurred in stored script Memory Script
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+FRA/dpsu/archivelog/2014_11_20/thread_1_seq_5148.1561.864155131'
RMAN-11001: Oracle Error:
ORA-00308: cannot open archived log '+FRA/dpsu/archivelog/2014_11_20/thread_1_seq_5148.1561.864155131'
ORA-17503: ksfdopn:2 Failed to open file +FRA/dpsu/archivelog/2014_11_20/thread_1_seq_5148.1561.864155131
ORA-15001: diskgroup "FRA" does not exist or is not mounted
ORA-15001: diskgroup "FRA" does not exist or is not mounted
released channel: dev1
released channel: dev2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/20/2014 22:24:35
RMAN-05501: aborting duplication of target database

RMAN>
RMAN> **end-of-file**

RMAN>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2015
Added on Dec 3 2014
5 comments
1,653 views