RMAN duplicate from active 时遭遇 RMAN-04017和ORA-00439:ORA-00439: feature not enabled: Real Application Clusters



 报错信息:

connected to auxiliary database (not started)

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

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

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

RMAN-03002: failure of Duplicate Db command at 10/08/2018 11:13:26

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-04014: startup failed: ORA-01078: failure in processing system parameters

RMAN-04017: startup error description: ORA-00439: feature not enabled: Real Application Clusters



解决:duplicate命令加上:set cluster_database='false',如下:


duplicate target database 

for standby nofilenamecheck

from active database 

DORECOVER 

spfile 

set db_unique_name='htzxdbphy'

set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=htzxdbphy'

set log_archive_dest_2='service=tns_htzxdbpri async lgwr register valid_for=(online_logfile,primary_role) db_unique_name=htzxdbpri'

set standby_file_management='AUTO'

set fal_server='tns_htzxdbpri'

set fal_client='tns_htzxdbphy'

set control_files='+DATA','+DATA'

set db_file_name_convert='+DATA','+DATA'

set log_file_name_convert='+DATA','+DATA'

set memory_target='2048M'

set audit_file_dest='/u01/app/oracle/admin/htzxdb/adump'

set db_create_file_dest = '+DATA'

set db_recovery_file_dest = '+FRA'

set cluster_database='false'

;


由于主库是  rac  ,备库是单实例,所以,一定需要设置    cluster_database   ='false'。