一:环境概述:
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真是个垃圾功能!