MUST_RENAME_THIS_DATAFILE

godba 2021-12-23

4822

点上边蓝字关注我们

环境描述

19C RAC ASM OMF的数据库在使用同一个磁盘组名称做duplicate/restore/clone时遇到MUST_RENAME_THIS_DATAFILE的问题

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295
2    0        ZHYU                 ***     +DATA1/MUST_RENAME_THIS_DATAFILE_2.4294967295.4294967295
3    0        SYSAUX               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_3.4294967295.4294967295
4    0        UNDOTBS1             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_4.4294967295.4294967295
5    0        UNDOTBS2             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_5.4294967295.4294967295
7    0        USERS                ***     +DATA1/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       +DATA1/MUST_RENAME_THIS_TEMPFILE_1.4294967295.4294967295

2.通过备份的pfile生成spfile，即使递归建好了目录+data1/zyrac/parameterfile，spfile.ora文件也创建成功，其实它只是个链接文件，依然会自动生成+DATA1/ZYRACDG/PARAMETERFILE/spfile.269.1091894255，所以最好就是用create spfile='+data1' from pfile='/tmp/initzyrac1.ora;'

ASMCMD> ls -l
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   DEC 21 15:00:00  N    spfile.ora => +DATA1/ZYRACDG/PARAMETERFILE/spfile.269.1091894255

3.回复的standby controlfile也是自动生成到db_unique_name的目录里

RMAN> restore standby controlfile from '/u01/app/oracle/rman/ctl.bak';


Starting restore at 22-DEC-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=394 instance=zyrac1 device type=DISK


channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=+DATA1/ZYRACDG/CONTROLFILE/current.268.1091978669
Finished restore at 22-DEC-21

4.发现以下情况下，恢复时没有问题的,即：取消omf，convert参数值设置到磁盘组，恢复时数据文件名字会显示为must_rename_this_datafile,恢复完，switch database to copy就可以了,当然redo和tempfile需要rename

参数设置如下：

NAME                                     TYPE         VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                     string
db_file_name_convert                     string         +data1, +data1
log_file_name_convert                     string         +data1, +data1

恢复控制文件：

RMAN> restore standby controlfile from '/u01/app/oracle/rman/ctl.bak';


Starting restore at 22-DEC-21
using channel ORA_DISK_1


channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA1/ZYRACDG/CONTROLFILE/current.279.1091986341
Finished restore at 22-DEC-21


RMAN> startup mount force;

此时控制文件里文件名是这样的：

RMAN> report schema;


Starting implicit crosscheck backup at 22-DEC-21
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 22-DEC-21


Starting implicit crosscheck copy at 22-DEC-21
using channel ORA_DISK_1
Finished implicit crosscheck copy at 22-DEC-21


searching for all files in the recovery area
cataloging files...
no files cataloged


RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name ZYRACDG


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295
2    0        ZHYU                 ***     +DATA1/MUST_RENAME_THIS_DATAFILE_2.4294967295.4294967295
3    0        SYSAUX               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_3.4294967295.4294967295
4    0        UNDOTBS1             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_4.4294967295.4294967295
5    0        UNDOTBS2             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_5.4294967295.4294967295
7    0        USERS                ***     +DATA1/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       +DATA1/MUST_RENAME_THIS_TEMPFILE_1.4294967295.4294967295

继续恢复：

RMAN> restore database;


Starting restore at 22-DEC-21
using channel ORA_DISK_1


channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA1/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295
channel ORA_DISK_1: restoring datafile 00002 to +DATA1/MUST_RENAME_THIS_DATAFILE_2.4294967295.4294967295
channel ORA_DISK_1: restoring datafile 00003 to +DATA1/MUST_RENAME_THIS_DATAFILE_3.4294967295.4294967295
channel ORA_DISK_1: restoring datafile 00004 to +DATA1/MUST_RENAME_THIS_DATAFILE_4.4294967295.4294967295
channel ORA_DISK_1: restoring datafile 00005 to +DATA1/MUST_RENAME_THIS_DATAFILE_5.4294967295.4294967295
channel ORA_DISK_1: restoring datafile 00007 to +DATA1/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295
channel ORA_DISK_1: reading from backup piece +DATA1/ZYRAC/BACKUPSET/2021_12_22/nnndf0_tag20211222t162513_0.292.1091982313
channel ORA_DISK_1: piece handle=+DATA1/ZYRAC/BACKUPSET/2021_12_22/nnndf0_tag20211222t162513_0.292.1091982313 tag=TAG20211222T162513
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
Finished restore at 22-DEC-21

发现回复完名字还是不对：

RMAN> report schema;


using target database control file instead of recovery catalog
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name ZYRACDG


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295
2    0        ZHYU                 ***     +DATA1/MUST_RENAME_THIS_DATAFILE_2.4294967295.4294967295
3    0        SYSAUX               ***     +DATA1/MUST_RENAME_THIS_DATAFILE_3.4294967295.4294967295
4    0        UNDOTBS1             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_4.4294967295.4294967295
5    0        UNDOTBS2             ***     +DATA1/MUST_RENAME_THIS_DATAFILE_5.4294967295.4294967295
7    0        USERS                ***     +DATA1/MUST_RENAME_THIS_DATAFILE_7.4294967295.4294967295


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       +DATA1/MUST_RENAME_THIS_TEMPFILE_1.4294967295.4294967295

这时，做如下操作就好了：

RMAN> switch database to copy;


datafile 1 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/system.284.1091986403"
datafile 2 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/zhyu.262.1091986403"
datafile 3 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/sysaux.296.1091986403"
datafile 4 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/undotbs1.285.1091986403"
datafile 5 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/undotbs2.301.1091986403"
datafile 7 switched to datafile copy "+DATA1/ZYRACDG/DATAFILE/users.278.1091986403"


RMAN> report schema;


RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name ZYRACDG


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    900      SYSTEM               ***     +DATA1/ZYRACDG/DATAFILE/system.284.1091986403
2    100      ZHYU                 ***     +DATA1/ZYRACDG/DATAFILE/zhyu.262.1091986403
3    540      SYSAUX               ***     +DATA1/ZYRACDG/DATAFILE/sysaux.296.1091986403
4    345      UNDOTBS1             ***     +DATA1/ZYRACDG/DATAFILE/undotbs1.285.1091986403
5    25       UNDOTBS2             ***     +DATA1/ZYRACDG/DATAFILE/undotbs2.301.1091986403
7    5        USERS                ***     +DATA1/ZYRACDG/DATAFILE/users.278.1091986403

数据库

文章转载自godba，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

MUST_RENAME_THIS_DATAFILE

评论