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 database using RMAN

DumiduMar 9 2016 — edited Mar 10 2016

Hi Team,

i'm trying to create duplicate database using RMAN duplicate command(database version 11.0.2). steps are mention in below

     1.     create parameter fine for destination database with db_name parameter.

     2.     all the listeners and tns are working fine.

     3.     source database in archive log mode and it's in mounted mode.

     4.     copy password file source to destination and rename according to destination database name.

     5.     startup nomount the destination database.

     6.     connect to RMAN using below command

                    rman target sys/sys-pwd@sourcedb auxiliary sys/sys-pwd@destinationdb

     7.     then type below command


                DUPLICATE TARGET DATABASE TO destinationdb

                 SPFILE

                 parameter_value_convert ='sourcedb','destinationdb'

                 set log_file_name_convert ='oradata/sourcedb','oradata/destinationdb'

                 set db_file_name_convert ='oradata/sourcedb','oradata/destinationdb'

                 set contol_files='oradata/destinationdb/cntrl01.dbf'

                 NOFILENAMECHECK;

once i enter below error message display

Starting Duplicate Db at 09-MAR-16

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 03/09/2016 12:15:48

RMAN-05501: aborting duplication of target database

RMAN-06581: option contol_files not supported

please provide a solution for that

Thanks,

Dumidu.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2016
Added on Mar 9 2016
6 comments
762 views