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

0    235    1

Tags:

👉 本文共约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'

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

set memory_target='2048M'

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!
RMAN duplicate from active 时遭遇 RMAN-04017和ORA-00439后续精彩内容已被小麦苗无情隐藏,请输入验证码解锁本站所有文章
验证码:
请关注本站微信公众号,回复“小麦苗博客”,获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签:

Avatar photo

小麦苗

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

您可能还喜欢...

发表回复

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

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

  • 回到顶部