RMAN duplicate from active 时遭遇 RMAN-04017和ORA-00439
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'