RMAN duplicate from active 时遭遇 RMAN-04017和ORA-00439

0    118    1

👉 本文共约809个字,系统预计阅读时间或需4分钟。

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'

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

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'。

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

5 − 3 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部