暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / 灾备数据库DG断归档

灾备数据库DG断归档

IT那活儿 2022-05-23
751

点击上方“IT那活儿”公众号，关注后了解更多内容，不管IT什么活儿，干就完了！！！ 



第1章  运行环境
操作系统：HPUNIX
数据库版本：11.2.0.3
数据库配置：RAC
数据文件存储方式：ASM

第2章  故障描述
某数据库与灾备数据库的数据文件存储方式为ASM，备库的归档文件路径的磁盘空间不足，数据库管理员手动把归档日志文件删除了一部分，释放一些使用空间。
但是经过排查发现重启灾备数据库后没有开启DG恢复模式，只是在接收主库传送过来的归档文件并没有应用到备库，导致删除备库归档日志文件脚本执行失败，造成归档路径磁盘空间不足。
同时，由于删除了一部分没有应用到备库的归档文件，导致灾备数据库DG同步中断。

第3章  处理过程
由于归档文件的丢失，备库恢复同步方式有如下两种：
1）通过主库全库备份来恢复备库；
2）通过基于SCN备份主库来恢复备库。
第一种方式适合数据库的数据量比较少，能过主库全库备份恢复备库。
第二种方式适合数据库的数据量比较大，主库全库备份时间较长，可以通过SCN备份方式增量恢复备库。
此次恢复备库采用第二种方式，基于SCN备份主库，步骤如下：

  • 备库确认丢失归档信息

  • 备库确认当前最小SCN号

  • 主库通过基于SCN方式RMAN备份数据库

  • 备库恢复数据库

  • 备库使用旧的控制文件采集数据文件路径信息

  • 备库恢复新的控制文件

  • 备库使用catalog datafilecopy命令扫描数据文件

  • 备库使用set newname 命令修改数据文件路径

  • 主库备份缺失的数据文件

  • 备库恢复新增加的数据文件

  • 开启DG同步机制

3.1  备库确认丢失归档信息
在备库上执行查询：
SQL> select * from v$archive_gap;


THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
2            27893                  28555


SQL> SELECT PROCESS,CLIENT_PROCESS,SEQUENCE#,STATUS FROM V$MANAGED_STANDBY;
PROCESS CLIENT_P  SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH ARCH 30775 CLOSING
ARCH ARCH 29360 CLOSING
ARCH ARCH 29361 CLOSING
ARCH ARCH 30771 CLOSING
ARCH ARCH 29357 CLOSING
ARCH ARCH 30772 CLOSING
ARCH ARCH 30773 CLOSING
ARCH ARCH 29358 CLOSING
ARCH ARCH 30774 CLOSING
ARCH ARCH 29359 CLOSING
RFS UNKNOWN 0 IDLE
RFS LGWR 29362 IDLE
RFS N/A 0 IDLE
RFS UNKNOWN 0 IDLE
MRP0 N/A 27893 WAIT_FOR_GAP

RFS UNKNOWN 0 IDLE
RFS LGWR 30776 IDLE
RFS N/A 0 IDLE


SQL> select name,value from v$dataguard_stats;
NAME VALUE
-------------------------------- ------------------------------
apply finish time +00 16:52:12.9
apply lag +94 04:21:02

estimated startup time 22
standby has been open N
transport lag +00 00:00:07
3.2 备库确认当前最小SCN号
在备库执行：
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> col current_scn for 999999999999999
SQL>  SELECT CURRENT_SCN FROM V$DATABASE;
CURRENT_SCN
----------------
39597750709
SQL>  select min(f.checkpoint_change#) from v$datafile_header f, v$datafile d
2 where f.file# =d.file# and d.enabled != 'READ ONLY' ;
MIN(F.FHSCN)
----------------
39597657793
我们分别查出了备库的当前SCN和文件头的最小SCN，强烈建议使用文件头最小SCN在主库进行增量备份。
SQL>  ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
在主库上执行：
SQL> select FILE#,to_char(CREATION_TIME,'yyyy-mm-dd hh24:mi:ss') CREATION_TIME,STATUS,LAST_TIME,name from v$datafile where CREATION_CHANGE#> 39597657793; (备库最小SCN号)
FILE# CREATION_TIME STATUS LAST_TIME NAME
---------- -------------------- -------------- -------------------- ----
151 2017-07-13 online +DATA/ebsback/datafile/apps_pts_cux6_02.dbf
152 2017-08-18 online +DATA/ebsback/datafile/cuxd_05
153 2017-08-18 online +DATA/ebsback/datafile/apps_pts_cux2_03
154 2017-08-18 online +DATA/ebsback/datafile/apps_pts_cux3_03
155 2017-08-18 online +DATA/ebsback/datafile/apps_pts_cux0.03
通过上面查询得知在备库最小SCN号之后主库增加了五个数据文件，即151、152、153、154、155号数据文件。
查询备库数据文件信息：
SQL> select file#, name from v$datafile;
备库查询数据文件没有相关此五个数据文件信息。
3.3 主库通过基于SCN方式RMAN备份数据库
#!/bin/ksh
$ORACLE_HOME/bin/rman target  log=/orabak/backup_20170823.log <<EOF
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
BACKUP as compressed backupset INCREMENTAL FROM SCN 39597657793（取备库最小SCN号） DATABASE FORMAT '/orabak/dg_%U' tag 'FORSTANDBY';
release channel t1;
release channel t2;
}
EOF
主数据库备份完毕后，备份一下主库的控制文件：
SQL> ALTER DATABASE CREATE standby controlfile AS '/orabak/standby_20170823.ctl';
把备份集远程复制到备库：
scp  /orabak/* 16.1.14.201: orabak
3.4 备库恢复数据库
备库启动到mount状态：
sqlplus  as sysdba
startup mount;
备份备库当前的控制文件：
rman target /
backup current controlfile format ‘/orabak/stanby_20170823.ctl’;
在备库恢复之前，把主库的备份集信息注册到备库中：
$ rman target /
RMAN> CATALOG START WITH ‘/orabak';
using target database control file instead of recovery catalog
searching for all files that match the pattern /lisgpfs/zaibei2017

List of Files Unknown to the Database
=====================================
File Name: /lisgpfs/zaibei2017/4567
File Name: /lisgpfs/zaibei2017/backup_20170823.log
File Name: /lisgpfs/zaibei2017/backup_incr.sh
File Name: /lisgpfs/zaibei2017/dg_7mrsnu6s_1_1
File Name: /lisgpfs/zaibei2017/dg_7nrsnu6s_1_1
File Name: /lisgpfs/zaibei2017/dg_7orso1ji_1_1
File Name: /lisgpfs/zaibei2017/dg_7prso1jk_1_1
File Name: /lisgpfs/zaibei2017/nohup.out
File Name: /lisgpfs/zaibei2017/standby_20170823.ctl

Do you really want to catalog the above files (enter YES or NO)? yes
在备库执行恢复数据库：
#!/bin/ksh
$ORACLE_HOME/bin/rman target / log=/orabak/recover_20170823.log <<EOF
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
recover database noredo;
release channel t1;
release channel t2;
}
EOF
3.5 备库收集数据文件路径信息
备库恢复完数据库后，备库使用当前的控制文件收集备库的数据文件路径信息。
select file#,name from v$datafile;
-----------------------------------------------------------
1  '+DATA/ebsback/datafile/system.285.837193785';
2  '+DATA/ebsback/datafile/system.331.837194971';
3  '+DATA/ebsback/datafile/system.317.837194443';
4  '+DATA/ebsback/datafile/system.293.837193791';
5  '+DATA/ebsback/datafile/system.332.837194971';
6  '+DATA/ebsback/datafile/system.318.837194445';
7  '+DATA/ebsback/datafile/system.294.837193797';
8  '+DATA/ebsback/datafile/system.333.837194971';
9  '+DATA/ebsback/datafile/system.319.837194445';
10  '+DATA/ebsback/datafile/system.295.837193797';
11  '+DATA/ebsback/datafile/system.300.837193803';
12  '+DATA/ebsback/datafile/apps_undots1.261.837193733';
13  '+DATA/ebsback/datafile/apps_ts_archive.304.837193805';
14  '+DATA/ebsback/datafile/apps_ts_interface.306.837193807';
15  '+DATA/ebsback/datafile/apps_ts_media.327.837194907';
16  '+DATA/ebsback/datafile/apps_ts_nologging.303.837193805';
17  '+DATA/ebsback/datafile/apps_ts_queues.307.837193807';
18  '+DATA/ebsback/datafile/apps_ts_queues.308.837193807';
19  '+DATA/ebsback/datafile/apps_ts_seed.284.837193785';
20  '+DATA/ebsback/datafile/apps_ts_seed.291.837193789';
21  '+DATA/ebsback/datafile/apps_ts_summary.305.837193807';
22  '+DATA/ebsback/datafile/apps_ts_tx_data.264.837193733';
23  '+DATA/ebsback/datafile/apps_ts_tx_data.259.837193733';
24  '+DATA/ebsback/datafile/apps_ts_tx_data.268.837193735';
25  '+DATA/ebsback/datafile/apps_ts_tx_idx.326.837194907';
26  '+DATA/ebsback/datafile/apps_ts_tx_idx.299.837193801';
27  '+DATA/ebsback/datafile/apps_ts_tx_idx.301.837193803';
28  '+DATA/ebsback/datafile/apps_ts_tx_idx.296.837193801';
29  '+DATA/ebsback/datafile/apps_ts_tx_idx.297.837193801';
30  '+DATA/ebsback/datafile/ctxd.322.837194611';
31  '+DATA/ebsback/datafile/odm.328.837194907';
32  '+DATA/ebsback/datafile/olap.310.837193809';
33  '+DATA/ebsback/datafile/owapub.313.837193811';
34  '+DATA/ebsback/datafile/portal.314.837193811';
35  '+DATA/ebsback/datafile/sysaux.325.837194905';
36  '+DATA/ebsback/datafile/apps_ts_tools.311.837193809';
37  '+DATA/ebsback/datafile/interim.312.837193809';
38  '+DATA/ebsback/datafile/apps_ts_tx_data.265.837193735';
39  '+DATA/ebsback/datafile/apps_undots1.286.837193787';
40  '+DATA/ebsback/datafile/cuxd.323.837194903';
41  '+DATA/ebsback/datafile/cuxi.260.837193733';
42  '+DATA/ebsback/datafile/apps_pts_cux0.267.837193735';
43  '+DATA/ebsback/datafile/apps_pts_cux1.263.837193733';
44  '+DATA/ebsback/datafile/apps_pts_cux2.266.837193735';
45  '+DATA/ebsback/datafile/apps_pts_cux3.269.837193735';
46  '+DATA/ebsback/datafile/apps_pts_cux4.329.837194969';
47  '+DATA/ebsback/datafile/apps_pts_cux5.315.837194441';
48  '+DATA/ebsback/datafile/apps_pts_cux6.274.837193759';
49  '+DATA/ebsback/datafile/apps_pts_cux7.281.837193761';
50  '+DATA/ebsback/datafile/apps_undots1.292.837193789';
51  '+DATA/ebsback/datafile/undotbs2.298.837193801';
52  '+DATA/ebsback/datafile/apps_undots2.273.837193757';
53  '+DATA/ebsback/datafile/apps_undots2.288.837193787';
54  '+DATA/ebsback/datafile/apps_undots2.287.837193787';
55  '+DATA/ebsback/datafile/apps_ts_interface.334.837194973';
56  '+DATA/ebsback/datafile/cuxd.278.837193759';
57  '+DATA/ebsback/datafile/apps_ts_summary.320.837194445';
58  '+DATA/ebsback/datafile/apps_ts_media.302.837193803';
59  '+DATA/ebsback/datafile/apps_ts_tx_data.321.837194607';
60  '+DATA/ebsback/datafile/apps_ts_tx_idx.309.837193807';
61  '+DATA/ebsback/datafile/cuxi.282.837193763';
62  '+DATA/ebsback/datafile/cuxd.324.837194905';
63  '+DATA/ebsback/datafile/apps_ts_tx_data.271.837193735';
64  '+DATA/ebsback/datafile/apps_ts_tx_idx.277.837193759';
65  '+DATA/ebsback/datafile/apps_pts_cux5.279.837193761';
66  '+DATA/ebsback/datafile/apps_ts_tx_data.272.837193735';
67  '+DATA/ebsback/datafile/apps_ts_tx_data.270.837193735';
68  '+DATA/ebsback/datafile/apps_ts_tx_data.262.837193733';
69  '+DATA/ebsback/datafile/apps_ts_tx_data.258.837193733';
70  '+DATA/ebsback/datafile/apps_pts_cux6.276.837193759';
71  '+DATA/ebsback/datafile/apps_pts_cux0.280.837193761';
72  '+DATA/ebsback/datafile/apps_pts_cux7.275.837193759';
73  '+DATA/ebsback/datafile/apps_pts_cux4.330.837194969';
74  '+DATA/ebsback/datafile/apps_pts_cux1.316.837194443';
75  '+DATA/ebsback/datafile/apps_pts_cux2.289.837193787';
76  '+DATA/ebsback/datafile/apps_pts_cux3.290.837193787';
77  '+DATA/ebsback/datafile/cuxd.283.837193783';
78  '+DATA/ebsback/datafile/cuxd.349.843849927';
79  '+DATA/ebsback/datafile/cuxd.350.851378673';
80  '+DATA/ebsback/datafile/apps_pts_cux6.351.853189041';
81  '+DATA/ebsback/datafile/apps_ts_archive.352.853189051';
82  '+DATA/ebsback/datafile/apps_pts_cux0.353.853189051';
83  '+DATA/ebsback/datafile/apps_pts_cux1.354.853189061';
84  '+DATA/ebsback/datafile/apps_pts_cux2.355.853189069';
85  '+DATA/ebsback/datafile/apps_pts_cux3.356.853189079';
86  '+DATA/ebsback/datafile/apps_pts_cux4.357.853189087';
87  '+DATA/ebsback/datafile/apps_pts_cux5.358.853189097';
88  '+DATA/ebsback/datafile/apps_pts_cux7.359.853189105';
89  '+DATA/ebsback/datafile/cuxd.360.861144867';
90  '+DATA/ebsback/datafile/apps_pts_cux0.361.866588663';
91  '+DATA/ebsback/datafile/apps_pts_cux1.362.866588693';
92  '+DATA/ebsback/datafile/apps_pts_cux2.363.866588723';
93  '+DATA/ebsback/datafile/apps_pts_cux3.364.866588753';
94  '+DATA/ebsback/datafile/apps_pts_cux4.365.866588781';
95  '+DATA/ebsback/datafile/apps_pts_cux5.366.866588811';
96  '+DATA/ebsback/datafile/apps_pts_cux6.367.866588841';
97  '+DATA/ebsback/datafile/apps_pts_cux7.368.866588871';
98  '+DATA/ebsback/datafile/apps_ts_archive.369.866588901';
99  '+DATA/ebsback/datafile/apps_ts_media.370.866588903';
100  '+DATA/ebsback/datafile/apps_ts_tx_data.371.866588909';
101  '+DATA/ebsback/datafile/apps_ts_tx_idx.372.866588939';
102  '+DATA/ebsback/datafile/cuxd.373.866588945';
103  '+DATA/ebsback/datafile/ctxd.374.866588975';
104  '+DATA/ebsback/datafile/apps_ts_tx_data.375.866588975';
105  '+DATA/ebsback/datafile/apps_ts_tx_data.376.867770789';
106  '+DATA/ebsback/datafile/apps_ts_tx_idx.377.867770819';
107  '+DATA/ebsback/datafile/cuxd.378.867770825';
108  '+DATA/ebsback/datafile/apps_ts_tx_data.379.867770855';
109  '+DATA/ebsback/datafile/apps_ts_tx_idx.380.867770883';
110  '+DATA/ebsback/datafile/cuxd.381.871414645';
111  '+DATA/ebsback/datafile/cuxd.382.891782705';
112  '+DATA/ebsback/datafile/apps_pts_cux0.383.894360913';
113  '+DATA/ebsback/datafile/apps_pts_cux1.384.894360943';
114  '+DATA/ebsback/datafile/apps_pts_cux2.385.894360973';
115  '+DATA/ebsback/datafile/apps_pts_cux3.386.894361005';
116  '+DATA/ebsback/datafile/apps_pts_cux4.387.894361037';
117  '+DATA/ebsback/datafile/apps_pts_cux5.388.894361067';
118  '+DATA/ebsback/datafile/apps_pts_cux6.389.894361097';
119  '+DATA/ebsback/datafile/apps_pts_cux7.390.894361127';
120  '+DATA/ebsback/datafile/cuxd.391.894412663';
121  '+DATA/ebsback/datafile/cuxi.392.894412693';
122  '+DATA/ebsback/datafile/cuxd.393.911686085';
123  '+DATA/ebsback/datafile/cuxd.394.901587791';
124  '+DATA/ebsback/datafile/cuxd.395.911686115';
125  '+DATA/ebsback/datafile/apps_pts_cux6.396.923744503';
126  '+DATA/ebsback/datafile/apps_pts_cux6.397.923750787';
127  '+DATA/ebsback/datafile/apps_pts_cux1.398.923750817';
128  '+DATA/ebsback/datafile/apps_pts_cux2.399.923750847';
129  '+DATA/ebsback/datafile/apps_pts_cux3.400.923750877';
130  '+DATA/ebsback/datafile/apps_pts_cux4.401.923750907';
131  '+DATA/ebsback/datafile/apps_pts_cux5.402.923750935';
132  '+DATA/ebsback/datafile/apps_pts_cux7.403.923750965';
133  '+DATA/ebsback/datafile/apps_ts_archive.404.923750995';
134  '+DATA/ebsback/datafile/apps_pts_cux0.405.923751029';
135  '+DATA/ebsback/datafile/apps_ts_tx_idx.406.923751059';
136  '+DATA/ebsback/datafile/cuxd.407.923751089';
137  '+DATA/ebsback/datafile/cuxd.408.924966749';
138  '+DATA/ebsback/datafile/apps_pts_cux0.409.943700767';
139  '+DATA/ebsback/datafile/apps_pts_cux1.410.943700795';
140  '+DATA/ebsback/datafile/cuxd.411.943700825';
141  '+DATA/ebsback/datafile/cuxd.412.943700855';
142  '+DATA/ebsback/datafile/cuxd.413.943700887';
143  '+DATA/ebsback/datafile/apps_ts_media.414.943700923';
144  '+DATA/ebsback/datafile/apps_pts_cux7.415.943700935';
145  '+DATA/ebsback/datafile/apps_pts_cux4.416.943700965';
146  '+DATA/ebsback/datafile/apps_pts_cux3.417.943700995';
147  '+DATA/ebsback/datafile/apps_pts_cux2.418.943701025';
148  '+DATA/ebsback/datafile/apps_pts_cux5.419.943701055';
149  '+DATA/ebsback/datafile/cuxi.420.943701087';
150  '+DATA/ebsback/datafile/apps_ts_tx_idx.421.946831543';
可以看到备库当前控制文件保存的数据文件指针只有150个，而主库的数据文件已经为155个数据文件。
3.6 备库恢复控制文件
备库收集完数据文件路径信息后，需要恢复一下备库的控制文件，即此控制文件是从主库备份过来的控制文件，为最新的控制文件：
SQL> shut immediate;
SQL>  startup nomount
$ rman target /
RMAN>  restore controlfile from '/lisgpfs/zaibei2017/standby_20170216.ctl';
SQL> alter database mount;
3.7 备库使用catalog datafilecopy命令扫描数据文件
为了使备库新恢复的控制文件能够有原来备库上的数据文件信息（由于启用了OMF，主备库的数据文件名是不一致的），所以，需要使用3.5步中收集的数据文件信息来编辑下面脚本中catalog datafilecopy后面的信息，将备库数据文件路径和名称注册到新的控制文件中。
知识点：
OMF全称是Oracle_Managed Files,即Oracle文件管理。
使用OMF能够简化管理员的管理工作，不用指定文件的名字、大小、路径，其名字，大小，路径由oracle 自己主动分配。OMF的文件命名规则为tag_name.file_number.incarnation，路径的命名规则是+diskgroup_name/database_name/ database file type。
Oracle数据库是否启用OMF特性能够通过查看DB_CREATE_FILE_DEST參数来获得。当DB_CREATE_FILE_DEST參数值为空时表示未启用OMF功能，设置为文件夹名则是开启OMF。
当主库与备库的数据文件存储方式为ASM， 并且ASM管理数据文件名称的机制为OMF时， 会导致主备库的文件名称不一致。
rman target /
catalog datafilecopy'+DATA/ebsback/datafile/system.285.837193785';
catalog datafilecopy'+DATA/ebsback/datafile/system.331.837194971';
catalog datafilecopy'+DATA/ebsback/datafile/system.317.837194443';
catalog datafilecopy'+DATA/ebsback/datafile/system.293.837193791';
catalog datafilecopy'+DATA/ebsback/datafile/system.332.837194971';
catalog datafilecopy'+DATA/ebsback/datafile/system.318.837194445';
catalog datafilecopy'+DATA/ebsback/datafile/system.294.837193797';
catalog datafilecopy'+DATA/ebsback/datafile/system.333.837194971';
catalog datafilecopy'+DATA/ebsback/datafile/system.319.837194445';
catalog datafilecopy'+DATA/ebsback/datafile/system.295.837193797';
catalog datafilecopy'+DATA/ebsback/datafile/system.300.837193803';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots1.261.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_archive.304.837193805';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_interface.306.837193807';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_media.327.837194907';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_nologging.303.837193805';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_queues.307.837193807';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_queues.308.837193807';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_seed.284.837193785';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_seed.291.837193789';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_summary.305.837193807';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.264.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.259.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.268.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.326.837194907';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.299.837193801';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.301.837193803';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.296.837193801';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.297.837193801';
catalog datafilecopy'+DATA/ebsback/datafile/ctxd.322.837194611';
catalog datafilecopy'+DATA/ebsback/datafile/odm.328.837194907';
catalog datafilecopy'+DATA/ebsback/datafile/olap.310.837193809';
catalog datafilecopy'+DATA/ebsback/datafile/owapub.313.837193811';
catalog datafilecopy'+DATA/ebsback/datafile/portal.314.837193811';
catalog datafilecopy'+DATA/ebsback/datafile/sysaux.325.837194905';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tools.311.837193809';
catalog datafilecopy'+DATA/ebsback/datafile/interim.312.837193809';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.265.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots1.286.837193787';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.323.837194903';
catalog datafilecopy'+DATA/ebsback/datafile/cuxi.260.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.267.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.263.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.266.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.269.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.329.837194969';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.315.837194441';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.274.837193759';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.281.837193761';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots1.292.837193789';
catalog datafilecopy'+DATA/ebsback/datafile/undotbs2.298.837193801';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots2.273.837193757';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots2.288.837193787';
catalog datafilecopy'+DATA/ebsback/datafile/apps_undots2.287.837193787';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_interface.334.837194973';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.278.837193759';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_summary.320.837194445';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_media.302.837193803';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.321.837194607';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.309.837193807';
catalog datafilecopy'+DATA/ebsback/datafile/cuxi.282.837193763';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.324.837194905';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.271.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.277.837193759';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.279.837193761';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.272.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.270.837193735';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.262.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.258.837193733';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.276.837193759';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.280.837193761';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.275.837193759';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.330.837194969';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.316.837194443';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.289.837193787';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.290.837193787';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.283.837193783';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.349.843849927';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.350.851378673';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.351.853189041';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_archive.352.853189051';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.353.853189051';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.354.853189061';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.355.853189069';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.356.853189079';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.357.853189087';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.358.853189097';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.359.853189105';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.360.861144867';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.361.866588663';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.362.866588693';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.363.866588723';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.364.866588753';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.365.866588781';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.366.866588811';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.367.866588841';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.368.866588871';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_archive.369.866588901';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_media.370.866588903';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.371.866588909';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.372.866588939';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.373.866588945';
catalog datafilecopy'+DATA/ebsback/datafile/ctxd.374.866588975';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.375.866588975';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.376.867770789';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.377.867770819';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.378.867770825';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_data.379.867770855';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.380.867770883';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.381.871414645';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.382.891782705';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.383.894360913';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.384.894360943';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.385.894360973';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.386.894361005';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.387.894361037';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.388.894361067';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.389.894361097';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.390.894361127';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.391.894412663';
catalog datafilecopy'+DATA/ebsback/datafile/cuxi.392.894412693';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.393.911686085';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.394.901587791';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.395.911686115';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.396.923744503';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux6.397.923750787';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.398.923750817';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.399.923750847';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.400.923750877';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.401.923750907';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.402.923750935';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.403.923750965';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_archive.404.923750995';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.405.923751029';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.406.923751059';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.407.923751089';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.408.924966749';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux0.409.943700767';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux1.410.943700795';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.411.943700825';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.412.943700855';
catalog datafilecopy'+DATA/ebsback/datafile/cuxd.413.943700887';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_media.414.943700923';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux7.415.943700935';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux4.416.943700965';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux3.417.943700995';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux2.418.943701025';
catalog datafilecopy'+DATA/ebsback/datafile/apps_pts_cux5.419.943701055';
catalog datafilecopy'+DATA/ebsback/datafile/cuxi.420.943701087';
catalog datafilecopy'+DATA/ebsback/datafile/apps_ts_tx_idx.421.946831543';
3.8 备库使用set newname 命令修改数据文件路径
如果不使用catalog datafilecopy 命令扫描数据文件，直接set newname命令会报如下错误：（找不到数据文件，原因在3.7中已经说明）
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 08/23/2017 21:27:12
RMAN-20230: datafile copy not found in the repository
RMAN-06015: error while looking up datafile copy name: +DATA/ebsback/datafile/system.257.802670149
使用set newname命令：
rman target /
run {
set newname for datafile 1 to '+DATA/ebsback/datafile/system.285.837193785';
set newname for datafile 2 to '+DATA/ebsback/datafile/system.331.837194971';
set newname for datafile 3 to '+DATA/ebsback/datafile/system.317.837194443';
set newname for datafile 4 to '+DATA/ebsback/datafile/system.293.837193791';
set newname for datafile 5 to '+DATA/ebsback/datafile/system.332.837194971';
set newname for datafile 6 to '+DATA/ebsback/datafile/system.318.837194445';
set newname for datafile 7 to '+DATA/ebsback/datafile/system.294.837193797';
set newname for datafile 8 to '+DATA/ebsback/datafile/system.333.837194971';
set newname for datafile 9 to '+DATA/ebsback/datafile/system.319.837194445';
set newname for datafile 10 to '+DATA/ebsback/datafile/system.295.837193797';
set newname for datafile 11 to '+DATA/ebsback/datafile/system.300.837193803';
set newname for datafile 12 to '+DATA/ebsback/datafile/apps_undots1.261.837193733';
set newname for datafile 13 to '+DATA/ebsback/datafile/apps_ts_archive.304.837193805';
set newname for datafile 14 to '+DATA/ebsback/datafile/apps_ts_interface.306.837193807';
set newname for datafile 15 to '+DATA/ebsback/datafile/apps_ts_media.327.837194907';
set newname for datafile 16 to '+DATA/ebsback/datafile/apps_ts_nologging.303.837193805';
set newname for datafile 17 to '+DATA/ebsback/datafile/apps_ts_queues.307.837193807';
set newname for datafile 18 to '+DATA/ebsback/datafile/apps_ts_queues.308.837193807';
set newname for datafile 19 to '+DATA/ebsback/datafile/apps_ts_seed.284.837193785';
set newname for datafile 20 to '+DATA/ebsback/datafile/apps_ts_seed.291.837193789';
set newname for datafile 21 to '+DATA/ebsback/datafile/apps_ts_summary.305.837193807';
set newname for datafile 22 to '+DATA/ebsback/datafile/apps_ts_tx_data.264.837193733';
set newname for datafile 23 to '+DATA/ebsback/datafile/apps_ts_tx_data.259.837193733';
set newname for datafile 24 to '+DATA/ebsback/datafile/apps_ts_tx_data.268.837193735';
set newname for datafile 25 to '+DATA/ebsback/datafile/apps_ts_tx_idx.326.837194907';
set newname for datafile 26 to '+DATA/ebsback/datafile/apps_ts_tx_idx.299.837193801';
set newname for datafile 27 to '+DATA/ebsback/datafile/apps_ts_tx_idx.301.837193803';
set newname for datafile 28 to '+DATA/ebsback/datafile/apps_ts_tx_idx.296.837193801';
set newname for datafile 29 to '+DATA/ebsback/datafile/apps_ts_tx_idx.297.837193801';
set newname for datafile 30 to '+DATA/ebsback/datafile/ctxd.322.837194611';
set newname for datafile 31 to '+DATA/ebsback/datafile/odm.328.837194907';
set newname for datafile 32 to '+DATA/ebsback/datafile/olap.310.837193809';
set newname for datafile 33 to '+DATA/ebsback/datafile/owapub.313.837193811';
set newname for datafile 34 to '+DATA/ebsback/datafile/portal.314.837193811';
set newname for datafile 35 to '+DATA/ebsback/datafile/sysaux.325.837194905';
set newname for datafile 36 to '+DATA/ebsback/datafile/apps_ts_tools.311.837193809';
set newname for datafile 37 to '+DATA/ebsback/datafile/interim.312.837193809';
set newname for datafile 38 to '+DATA/ebsback/datafile/apps_ts_tx_data.265.837193735';
set newname for datafile 39 to '+DATA/ebsback/datafile/apps_undots1.286.837193787';
set newname for datafile 40 to '+DATA/ebsback/datafile/cuxd.323.837194903';
set newname for datafile 41 to '+DATA/ebsback/datafile/cuxi.260.837193733';
set newname for datafile 42 to '+DATA/ebsback/datafile/apps_pts_cux0.267.837193735';
set newname for datafile 43 to '+DATA/ebsback/datafile/apps_pts_cux1.263.837193733';
set newname for datafile 44 to '+DATA/ebsback/datafile/apps_pts_cux2.266.837193735';
set newname for datafile 45 to '+DATA/ebsback/datafile/apps_pts_cux3.269.837193735';
set newname for datafile 46 to '+DATA/ebsback/datafile/apps_pts_cux4.329.837194969';
set newname for datafile 47 to '+DATA/ebsback/datafile/apps_pts_cux5.315.837194441';
set newname for datafile 48 to '+DATA/ebsback/datafile/apps_pts_cux6.274.837193759';
set newname for datafile 49 to '+DATA/ebsback/datafile/apps_pts_cux7.281.837193761';
set newname for datafile 50 to '+DATA/ebsback/datafile/apps_undots1.292.837193789';
set newname for datafile 51 to '+DATA/ebsback/datafile/undotbs2.298.837193801';
set newname for datafile 52 to '+DATA/ebsback/datafile/apps_undots2.273.837193757';
set newname for datafile 53 to '+DATA/ebsback/datafile/apps_undots2.288.837193787';
set newname for datafile 54 to '+DATA/ebsback/datafile/apps_undots2.287.837193787';
set newname for datafile 55 to '+DATA/ebsback/datafile/apps_ts_interface.334.837194973';
set newname for datafile 56 to '+DATA/ebsback/datafile/cuxd.278.837193759';
set newname for datafile 57 to '+DATA/ebsback/datafile/apps_ts_summary.320.837194445';
set newname for datafile 58 to '+DATA/ebsback/datafile/apps_ts_media.302.837193803';
set newname for datafile 59 to '+DATA/ebsback/datafile/apps_ts_tx_data.321.837194607';
set newname for datafile 60 to '+DATA/ebsback/datafile/apps_ts_tx_idx.309.837193807';
set newname for datafile 61 to '+DATA/ebsback/datafile/cuxi.282.837193763';
set newname for datafile 62 to '+DATA/ebsback/datafile/cuxd.324.837194905';
set newname for datafile 63 to '+DATA/ebsback/datafile/apps_ts_tx_data.271.837193735';
set newname for datafile 64 to '+DATA/ebsback/datafile/apps_ts_tx_idx.277.837193759';
set newname for datafile 65 to '+DATA/ebsback/datafile/apps_pts_cux5.279.837193761';
set newname for datafile 66 to '+DATA/ebsback/datafile/apps_ts_tx_data.272.837193735';
set newname for datafile 67 to '+DATA/ebsback/datafile/apps_ts_tx_data.270.837193735';
set newname for datafile 68 to '+DATA/ebsback/datafile/apps_ts_tx_data.262.837193733';
set newname for datafile 69 to '+DATA/ebsback/datafile/apps_ts_tx_data.258.837193733';
set newname for datafile 70 to '+DATA/ebsback/datafile/apps_pts_cux6.276.837193759';
set newname for datafile 71 to '+DATA/ebsback/datafile/apps_pts_cux0.280.837193761';
set newname for datafile 72 to '+DATA/ebsback/datafile/apps_pts_cux7.275.837193759';
set newname for datafile 73 to '+DATA/ebsback/datafile/apps_pts_cux4.330.837194969';
set newname for datafile 74 to '+DATA/ebsback/datafile/apps_pts_cux1.316.837194443';
set newname for datafile 75 to '+DATA/ebsback/datafile/apps_pts_cux2.289.837193787';
set newname for datafile 76 to '+DATA/ebsback/datafile/apps_pts_cux3.290.837193787';
set newname for datafile 77 to '+DATA/ebsback/datafile/cuxd.283.837193783';
set newname for datafile 78 to '+DATA/ebsback/datafile/cuxd.349.843849927';
set newname for datafile 79 to '+DATA/ebsback/datafile/cuxd.350.851378673';
set newname for datafile 80 to '+DATA/ebsback/datafile/apps_pts_cux6.351.853189041';
set newname for datafile 81 to '+DATA/ebsback/datafile/apps_ts_archive.352.853189051';
set newname for datafile 82 to '+DATA/ebsback/datafile/apps_pts_cux0.353.853189051';
set newname for datafile 83 to '+DATA/ebsback/datafile/apps_pts_cux1.354.853189061';
set newname for datafile 84 to '+DATA/ebsback/datafile/apps_pts_cux2.355.853189069';
set newname for datafile 85 to '+DATA/ebsback/datafile/apps_pts_cux3.356.853189079';
set newname for datafile 86 to '+DATA/ebsback/datafile/apps_pts_cux4.357.853189087';
set newname for datafile 87 to '+DATA/ebsback/datafile/apps_pts_cux5.358.853189097';
set newname for datafile 88 to '+DATA/ebsback/datafile/apps_pts_cux7.359.853189105';
set newname for datafile 89 to '+DATA/ebsback/datafile/cuxd.360.861144867';
set newname for datafile 90 to '+DATA/ebsback/datafile/apps_pts_cux0.361.866588663';
set newname for datafile 91 to '+DATA/ebsback/datafile/apps_pts_cux1.362.866588693';
set newname for datafile 92 to '+DATA/ebsback/datafile/apps_pts_cux2.363.866588723';
set newname for datafile 93 to '+DATA/ebsback/datafile/apps_pts_cux3.364.866588753';
set newname for datafile 94 to '+DATA/ebsback/datafile/apps_pts_cux4.365.866588781';
set newname for datafile 95 to '+DATA/ebsback/datafile/apps_pts_cux5.366.866588811';
set newname for datafile 96 to '+DATA/ebsback/datafile/apps_pts_cux6.367.866588841';
set newname for datafile 97 to '+DATA/ebsback/datafile/apps_pts_cux7.368.866588871';
set newname for datafile 98 to '+DATA/ebsback/datafile/apps_ts_archive.369.866588901';
set newname for datafile 99 to '+DATA/ebsback/datafile/apps_ts_media.370.866588903';
set newname for datafile 100 to '+DATA/ebsback/datafile/apps_ts_tx_data.371.866588909';
set newname for datafile 101 to '+DATA/ebsback/datafile/apps_ts_tx_idx.372.866588939';
set newname for datafile 102 to '+DATA/ebsback/datafile/cuxd.373.866588945';
set newname for datafile 103 to '+DATA/ebsback/datafile/ctxd.374.866588975';
set newname for datafile 104 to '+DATA/ebsback/datafile/apps_ts_tx_data.375.866588975';
set newname for datafile 105 to '+DATA/ebsback/datafile/apps_ts_tx_data.376.867770789';
set newname for datafile 106 to '+DATA/ebsback/datafile/apps_ts_tx_idx.377.867770819';
set newname for datafile 107 to '+DATA/ebsback/datafile/cuxd.378.867770825';
set newname for datafile 108 to '+DATA/ebsback/datafile/apps_ts_tx_data.379.867770855';
set newname for datafile 109 to '+DATA/ebsback/datafile/apps_ts_tx_idx.380.867770883';
set newname for datafile 110 to '+DATA/ebsback/datafile/cuxd.381.871414645';
set newname for datafile 111 to '+DATA/ebsback/datafile/cuxd.382.891782705';
set newname for datafile 112 to '+DATA/ebsback/datafile/apps_pts_cux0.383.894360913';
set newname for datafile 113 to '+DATA/ebsback/datafile/apps_pts_cux1.384.894360943';
set newname for datafile 114 to '+DATA/ebsback/datafile/apps_pts_cux2.385.894360973';
set newname for datafile 115 to '+DATA/ebsback/datafile/apps_pts_cux3.386.894361005';
set newname for datafile 116 to '+DATA/ebsback/datafile/apps_pts_cux4.387.894361037';
set newname for datafile 117 to '+DATA/ebsback/datafile/apps_pts_cux5.388.894361067';
set newname for datafile 118 to '+DATA/ebsback/datafile/apps_pts_cux6.389.894361097';
set newname for datafile 119 to '+DATA/ebsback/datafile/apps_pts_cux7.390.894361127';
set newname for datafile 120 to '+DATA/ebsback/datafile/cuxd.391.894412663';
set newname for datafile 121 to '+DATA/ebsback/datafile/cuxi.392.894412693';
set newname for datafile 122 to '+DATA/ebsback/datafile/cuxd.393.911686085';
set newname for datafile 123 to '+DATA/ebsback/datafile/cuxd.394.901587791';
set newname for datafile 124 to '+DATA/ebsback/datafile/cuxd.395.911686115';
set newname for datafile 125 to '+DATA/ebsback/datafile/apps_pts_cux6.396.923744503';
set newname for datafile 126 to '+DATA/ebsback/datafile/apps_pts_cux6.397.923750787';
set newname for datafile 127 to '+DATA/ebsback/datafile/apps_pts_cux1.398.923750817';
set newname for datafile 128 to '+DATA/ebsback/datafile/apps_pts_cux2.399.923750847';
set newname for datafile 129 to '+DATA/ebsback/datafile/apps_pts_cux3.400.923750877';
set newname for datafile 130 to '+DATA/ebsback/datafile/apps_pts_cux4.401.923750907';
set newname for datafile 131 to '+DATA/ebsback/datafile/apps_pts_cux5.402.923750935';
set newname for datafile 132 to '+DATA/ebsback/datafile/apps_pts_cux7.403.923750965';
set newname for datafile 133 to '+DATA/ebsback/datafile/apps_ts_archive.404.923750995';
set newname for datafile 134 to '+DATA/ebsback/datafile/apps_pts_cux0.405.923751029';
set newname for datafile 135 to '+DATA/ebsback/datafile/apps_ts_tx_idx.406.923751059';
set newname for datafile 136 to '+DATA/ebsback/datafile/cuxd.407.923751089';
set newname for datafile 137 to '+DATA/ebsback/datafile/cuxd.408.924966749';
set newname for datafile 138 to '+DATA/ebsback/datafile/apps_pts_cux0.409.943700767';
set newname for datafile 139 to '+DATA/ebsback/datafile/apps_pts_cux1.410.943700795';
set newname for datafile 140 to '+DATA/ebsback/datafile/cuxd.411.943700825';
set newname for datafile 141 to '+DATA/ebsback/datafile/cuxd.412.943700855';
set newname for datafile 142 to '+DATA/ebsback/datafile/cuxd.413.943700887';
set newname for datafile 143 to '+DATA/ebsback/datafile/apps_ts_media.414.943700923';
set newname for datafile 144 to '+DATA/ebsback/datafile/apps_pts_cux7.415.943700935';
set newname for datafile 145 to '+DATA/ebsback/datafile/apps_pts_cux4.416.943700965';
set newname for datafile 146 to '+DATA/ebsback/datafile/apps_pts_cux3.417.943700995';
set newname for datafile 147 to '+DATA/ebsback/datafile/apps_pts_cux2.418.943701025';
set newname for datafile 148 to '+DATA/ebsback/datafile/apps_pts_cux5.419.943701055';
set newname for datafile 149 to '+DATA/ebsback/datafile/cuxi.420.943701087';
set newname for datafile 150 to '+DATA/ebsback/datafile/apps_ts_tx_idx.421.946831543';
switch datafile all;
}
备库开启同步机制：
SQL>  ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION;
备库alert警告日志报找不到151、152、153、154、155号数据文件。
3.9 主库备份缺失的数据文件
在主库备份151、152、153、154、155号数据文件：
$ rman target /
RMAN> backup datafile 151,152,153,154,155;
把备份集复制到备库：
scp datafile_151.dbf 16.1.14.201: /oradata
3.10 备库恢复新增加的数据文件
备库恢复151,152,153,154,155号数据文件：
$ rman target /
RMAN> CATALOG START WITH '/oradata';
RMAN> restore datafile 151,152,153,154,155;
3.11 开启DG同步机制
备库开启恢复：
SQL> ALTER DATABASE recover managed standby DATABASE using current logfile disconnect FROM SESSION;


建议总结

建议从运维角度定期检查DataGuard的运行情况，避免产生Gap导致的一系列问题。

END




本文作者：陆亚尧

本文来源：IT那活儿（上海新炬王翦团队）

scn归档日志arch数据库文件data
文章转载自IT那活儿，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论