Oracle 由于OMF导致的MUST_RENAME_THIS_DATAFILE问题

一:环境概述:
RAC-RAC的ADG搭建
主库数据文件采用OMF文件管理
主库进行全备,在备库进行restore完成后出现的问题.
log_file_name_convert以及db_file_name_convert 配置正确

二:restore完成后查看警告日志:

mount状态下:
WARNING: The converted filename '+DATA/pri/datafile/system.275.1043745635'
         is an ASM fully qualified filename.
         Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_10.4294967295.4294967295'.
         Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/pri/datafile/sysaux.276.1043745637'
         is an ASM fully qualified filename.
         Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_11.4294967295.4294967295'.
         Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/pri/datafile/undotbs1.274.1043745635'
         is an ASM fully qualified filename.
         Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_12.4294967295.4294967295'.
         Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/pri/datafile/undo_2.278.1043745737'
         is an ASM fully qualified filename.
         Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_13.4294967295.4294967295'.
         Please rename it accordingly.
*****************************************
*****************************************
WARNING: The converted filename '+DATA/pri/datafile/users.279.1043745741'
         is an ASM fully qualified filename.
         Changing the filename to '+DATA/MUST_RENAME_THIS_DATAFILE_14.4294967295.4294967295'.
         Please rename it accordingly.
*****************************************
等等

三:查询数据文件信息:

SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_3.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_4.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_5.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_6.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_8.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_9.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_10.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_11.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_12.4294967295.4294967295
NAME
--------------------------------------------------------------------------------
+DATA/MUST_RENAME_THIS_DATAFILE_13.4294967295.4294967295
+DATA/MUST_RENAME_THIS_DATAFILE_14.4294967295.4294967295
13 rows selected.

SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATA/MUST_RENAME_THIS_LOGFILE_2.4294967295.4294967295
+DATA/MUST_RENAME_THIS_LOGFILE_1.4294967295.4294967295
+DATA/MUST_RENAME_THIS_LOGFILE_3.4294967295.4294967295
+DATA/MUST_RENAME_THIS_LOGFILE_4.4294967295.4294967295
+DATA/orcl12c/sty_log/stdb_redo01.log
+DATA/orcl12c/sty_log/stdb_redo02.log
+DATA/orcl12c/sty_log/stdb_redo03.log
+DATA/orcl12c/sty_log/stdb_redo04.log

四:分析与解决:
出现该问题的原因为主库的文件格式为OMF自动命名管理格式.
遇到这个问题呢,首先的想法就是进行数据文件重命名.
但是在这个位置,数据文件重命名是无效的.有遇到过的可以试一下.
解决的办法就是使用duplicate方式搭建DG会自动解决该问题
[oracle@rac1 ~]$rman target sys/oracle@pri auxiliary sys/oracle@sty
RMAN> duplicate target database for standby from active database nofilenamecheck

OMF真是个垃圾功能!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 3
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值