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!

ORA-12514 using duplicate

MagnusJohanssonDBAJan 5 2011 — edited Jan 7 2011
I'm testing to create a dataguard db using rman on windows 11gR2 Windows 2008R2

I'm running into the following error when duplicate the db for standby, it is after it restarted the auxiliary db

I have a static entry in the listener for the auxiliary database

released channel: prmy1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/05/2011 13:17:22
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

My script looks like this
run {
allocate channel prmy1 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'DGA','DGB'
set 'DB_UNIQUE_NAME'='DGB'
set control_files='F:\oradata\dgb\control01.ctl'
set db_create_file_dest='F:\oradata\dgb'
set db_create_online_log_dest_1='F:\oradata\dgb'
set db_create_online_log_dest_2='G:\flash_recovery_area\testdg'
set db_recovery_file_dest='G:\flash_recovery_area'
set db_recovery_file_dest_size='10G'
nofilenamecheck;
}

Anyone that have an idea ?

Thanks
Magnus

Edited by: user12953093 on 2011-jan-05 04:27
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2011
Added on Jan 5 2011
10 comments
2,661 views