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'

后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章

验证码：

请关注本站微信公众号，回复“小麦苗博客”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。