心得技巧
html5HTML/XhtmlCSSXML/XSLTDreamweaver教程Frontpage教程心得技巧

RMAN ERROR：RMAN-06094: DATAFILE 417 MUST BE RESTORED

发布时间：2022-06-27 发布网站：脚本宝典
脚本宝典收集整理的这篇文章主要介绍了RMAN ERROR：RMAN-06094: DATAFILE 417 MUST BE RESTORED，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

RMAN ERROR：RMAN-06094: DATAFILE 417 MUST BE REStoreD

    •  发表于：2018年1月24日
    •  分类：Recovery Manager（RMAN）
    •  标签：Backup Datafile Xxx Format 'Xxx', Database, Error, ;mOS, oracle, Rman, RMAN-03002: Failure Of SwITch To Copy Command At, RMAN-06094: Datafile 417 Must Be Restored, RMAN-06571: Datafile 1 Does Not Have Recoverable Copy, Steps To PErform For Rolling Forward A Standby Database Using RMAN Incremental Backup When Datafile Is Added To Primary (文档 ID 1531031.1)
 

用RMAN恢复DG的备库的时候遇到如题所示的错误，具体如下：

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
@H_763_126@44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
RMAN> startup nomount;
 
connected to target database (not started)
Oracle instance started
 
total System Global Area   51309510656 bytes
 
Fixed Size                     2231608 bytes
VARiable Size              30467424968 bytes
Database Buffers           20803747840 bytes
Redo Buffers                  36106240 bytes
 
RMAN>
 
RMAN> restore standby controlfile From '/oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1';
 
Starting restore at 24-JAN-18
allocated channel: ORA_disk_1
channel ORA_DISK_1: SID=227 device type=DISK
 
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
output file name=/oracle/ORA/origLOGA/cntrl/controlstandby1.ctl
Finished restore at 24-JAN-18
 
RMAN>
 
RMAN> startup mount;
 
database is already started
database mounted
released channel: ORA_DISK_1
 
RMAN>
 
RMAN> catalog start with '/oracle_backup/ac_rman_datafile';
 
seArching for all files that match the pattORA /oracle_backup/ac_rman_datafile
 
List of Files Unknown to the Database
=====================================
File Name: /oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_controlfile.bak
File Name: /oracle_backup/ac_rman_datafile/ForStandby_easot9an_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ebsot9ao_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ecsot9aq_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_edsot9as_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_eesot9au_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_rnsottd8_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ttsotuif_1_1
File Name: /oracle_backup/ac_rman_datafile/control_file/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/control_file/ForStandby_controlfile.bak
 
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
 
List of Cataloged Files
=======================
File Name: /oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_controlfile.bak
File Name: /oracle_backup/ac_rman_datafile/ForStandby_easot9an_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ebsot9ao_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ecsot9aq_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_edsot9as_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_eesot9au_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_rnsottd8_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ttsotuif_1_1
File Name: /oracle_backup/ac_rman_datafile/control_file/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/control_file/ForStandby_controlfile.bak
 
RMAN>
 
RMAN> recover database noredo;
 
Starting recover at 24-JAN-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=227 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/24/2018 11:25:30
RMAN-06094: datafile 417 must be restored
 
RMAN>
 
RMAN> switch database to copy;
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 01/24/2018 11:40:54
RMAN-06571: datafile 1 does not have recoverable copy
 
RMAN>

 

看看数据文件的状态：

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
AIX-ME:oraORA 8> SQLplus / as sysdba
 
SQL*Plus: Release 11.2.0.2.0 PRoduction on Wed Jan 24 11:27:06 2018
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application testing options
 
SQL> select instance_name,status from v$instance;
 
INSTANCE_NAME    STATUS
---------------- ------------
ORA              MOUNTED
 
SQL>
SQL> select name,database_role,open_mode from v$database;
 
NAME      DATABASE_ROLE    OPEN_MODE
--------- ---------------- --------------------
ORA       PHYS@R_777_2411@ STANDBY MOUNTED
 
SQL>
SQL> col name for a45
SQL> set linesize 300
SQL> select file#,name,bytes,status,to_date(CREATION_TIME,'yyyy-mm-dd hh24:mi:ss') "Create",to_date(ONLINE_TIME,'yyyy-mm-dd hh24:mi:ss') "Online" from v$datafile where file#=417;
 
     FILE# NAME                                               BYTES STATUS  Create          Online
---------- --------------------------------------------- ---------- ------- --------------- ---------------
       417 /oracle/ORA/db_data14/xer_382/xer.382data              0 ONLINE  18-JAN-04
 
SQL>
SQL> select file#,name,bytes,status,to_date(CREATION_TIME,'yyyy-mm-dd hh24:mi:ss') "Create",to_date(ONLINE_TIME,'yyyy-mm-dd hh24:mi:ss') "Online" from v$datafile where file#>415;
 
     FILE# NAME                                               BYTES STATUS  Create          Online
---------- --------------------------------------------- ---------- ------- --------------- ---------------
       416 /oracle/ORA/db_data20/xer_381/xer.381data     3.2212E+10 ONLINE  17-DEC-01
       417 /oracle/ORA/db_data14/xer_382/xer.382data              0 ONLINE  18-JAN-04
       418 /oracle/ORA/db_data14/xer_383/xer.383data              0 ONLINE  18-JAN-04
       419 /oracle/ORA/db_data14/xer_384/xer.384data              0 ONLINE  18-JAN-04
       420 /oracle/ORA/db_data14/xer_385/xer.385data              0 ONLINE  18-JAN-04
 
SQL>
SQL> col name for a45
SQL> set linesize 300
SQL> select DF.file#,ts.name,df.name,df.bytes,df.status,to_date(df.CREATION_TIME,'yyyy-mm-dd hh24:mi:ss') "Create",to_date(df.ONLINE_TIME,'yyyy-mm-dd hh24:mi:ss') "Online" from v$datafile df,v$tablespace ts where ts.ts#=df.ts# and df.file#>415;
 
     FILE# NAME                                          NAME                                               BYTES STATUS  Create          Online
---------- --------------------------------------------- --------------------------------------------- ---------- ------- --------------- ---------------
       416 PSAPXER                                       /oracle/ORA/db_data20/xer_381/xer.381data     3.2212E+10 ONLINE  17-DEC-01
       417 PSAPXER                                       /oracle/ORA/db_data14/xer_382/xer.382data              0 ONLINE  18-JAN-04
       420 PSAPXER                                       /oracle/ORA/db_data14/xer_385/xer.385data              0 ONLINE  18-JAN-04
       419 PSAPXER                                       /oracle/ORA/db_data14/xer_384/xer.384data              0 ONLINE  18-JAN-04
       418 PSAPXER                                       /oracle/ORA/db_data14/xer_383/xer.383data              0 ONLINE  18-JAN-04
 
SQL>

可以看到，文件编号：417 / 418 /419 /420的数据文件都为空。

RMAN中也可以看到类似的数据：

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@H_360_2208@17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
RMAN> report schema;
 
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name STANDBY1
 
List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    5000     SYSTEM               ***     /oracle/ORA/db_data1/system_1/system.data1
2    10000    PSAPUNDO             ***     /oracle/ORA/db_data1/undo_1/undo.data1
3    16000    SYSAUX               ***     /oracle/ORA/db_data1/sysaux_1/sysaux.data1
4    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_1/xer.data1
5    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_2/xer.data2
6    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_3/xer.data3
7    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_4/xer.data4
8    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_5/xer.data5
9    16000    PSAPXER              ***     /oracle/ORA/db_data2/xer_6/xer.data6
 
（过多的输出，... ）
 
413  30720    PSAPXER              ***     /oracle/ORA/db_data20/xer_378/xer.378data
414  30720    PSAPXER              ***     /oracle/ORA/db_data20/xer_379/xer.379data
415  30720    PSAPXER              ***     /oracle/ORA/db_data20/xer_380/xer.380data
416  30720    PSAPXER              ***     /oracle/ORA/db_data20/xer_381/xer.381data
417  0        PSAPXER              ***     /oracle/ORA/db_data14/xer_382/xer.382data
418  0        PSAPXER              ***     /oracle/ORA/db_data14/xer_383/xer.383data
419  0        PSAPXER              ***     /oracle/ORA/db_data14/xer_384/xer.384data
420  0        PSAPXER              ***     /oracle/ORA/db_data14/xer_385/xer.385data
 
List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    3000     PSAPTEMP             10000       /oracle/ORA/db_data1/temp_1/temp.data1
2    300      PSAPIBMTEMP          300         /oracle/ORA/db_data5/ibmtemp_1/ibmtemp.data1
3    10000    PSAPTEMP             10000       /oracle/ORA/db_data6/temp_2/temp.data2
4    5000     PSAPTEMP             5000        /oracle/ORA/db_data9/temp_3/temp.data3
5    5000     PSAPTEMP             5000        /oracle/ORA/db_data9/temp_4/temp.data4
6    5000     PSAPTEMP             5000        /oracle/ORA/db_data9/temp_5/temp.data5
 
RMAN>

 

一样可以看到，417 / 418 / 419 / 420的大小有问题。

文件系统中的样子？

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
AIX-ME:oraORA 13> ls -ltr /oracle/ORA/db_data14/
total 0
drwxr-xr-x    2 oraORA   dba             256 Jul 11 2015  lost+found
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_134
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_135
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_137
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_139
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_153
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_156
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_136
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_138
drwx------    2 oraORA   dba             256 Jul 13 2015  xer_155
drwx------    2 oraORA   dba             256 Aug 24 2016  xer_303
drwx------    2 oraORA   dba             256 Aug 24 2016  xer_304
drwx------    2 oraORA   dba             256 Aug 24 2016  xer_305
AIX-ME:oraORA 14>
AIX-ME:oraORA 14> ls -ltr /oracle/ORA/db_data14/ | grep _38
AIX-ME:oraORA 15>

 

确实不存在，… 应该是主库端的文件，但是还没有跟着归档日志传到备库端。

解法：MOS文档：Steps to perform for Rolling forward a standby database using RMAN incremental backup when datafile is added to primary (文档 ID 1531031.1)

数据文件：

 
1
2
3
4
5
6
7
8
9
10
11
12
SQL> set linesize 300
SQL> select file#,name,checkpoint_change#,bytes from v$datafile where file# > 415;
 
     FILE# NAME                                          CHECKPOINT_CHANGE#      BYTES
---------- --------------------------------------------- ------------------ ----------
       416 /oracle/ORA/db_data20/xer_381/xer.381data          4577622073896 3.2212E+10
       417 /oracle/ORA/db_data14/xer_382/xer.382data          4577622073896          0
       418 /oracle/ORA/db_data14/xer_383/xer.383data          4577622073896          0
       419 /oracle/ORA/db_data14/xer_384/xer.384data          4577622073896          0
       420 /oracle/ORA/db_data14/xer_385/xer.385data          4577622073896          0
 
SQL>

 

系统的SCN：

 
1
2
3
4
5
6
7
8
SQL> col current_scn for 99999999999999999
SQL> select name,database_role,current_scn,open_mode from v$database;
 
NAME                                          DATABASE_ROLE           CURRENT_SCN OPEN_MODE
--------------------------------------------- ---------------- ------------------ --------------------
ORA                                           PHYSICAL STANDBY      4577622141526 MOUNTED
 
SQL>

 

主库端：RMAN导出：

 
1
2
3
backup datafile [缺少的数据文件编号] format '[存储备份集的路径]' tag 'ForStandbyDB';
# backup incremental from SCN 3162298 database format '/tmp/ForStandby_%U' tag 'FORSTANDBY';
# backup current controlfile for standby format '/tmp/ForStandbyCTRL.bck';

 

然后，将主库端备份的RMAN备份集文件传到备库：

恢复：

 
1
2
3
4
5
6
7
8
9
10
11
12
.1 shutdown immediate;
0. startup nomount;
1. restore standby controlfile from 'xxxx'
2. alter database mount;
3. catalog start with 'xxxx'
4.
run {
  set newname for datafile xxxx to 'xxx';
  restore datafile xxx;
}
5. switch database to copy;
6. recover database noredo;

 

EG:

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
RMAN> restore standby controlfile from '/oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1';
 
Starting restore at 24-JAN-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=227 device type=DISK
 
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
output file name=/oracle/ORA/origlogA/cntrl/controlstandby1.ctl
Finished restore at 24-JAN-18
 
RMAN> startup mount;
 
database is already started
database mounted
released channel: ORA_DISK_1
 
RMAN>
 
RMAN> catalog start with '/oracle_backup/datafile_417to420';
 
searching for all files that match the pattORA /oracle_backup/datafile_417to420
 
List of Files Unknown to the Database
=====================================
File Name: /oracle_backup/datafile_417to420/ForStandby_d5spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d6spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d7spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d8spg6nj_1_1
 
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
 
List of Cataloged Files
=======================
File Name: /oracle_backup/datafile_417to420/ForStandby_d5spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d6spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d7spg6nj_1_1
File Name: /oracle_backup/datafile_417to420/ForStandby_d8spg6nj_1_1
 
RMAN>
 
RMAN>    
 
RMAN> run {
2> set newname for datafile 417 to '/oracle/ORA/db_data14/xer_382/xer.382data';
set newname for datafile 418 to '/oracle/ORA/db_data14/xer_383/xer.383data';
3> 4> set newname for datafile 419 to '/oracle/ORA/db_data14/xer_384/xer.384data';
set newname for datafile 420 to '/oracle/ORA/db_data14/xer_385/xer.385data';
5> 6> }
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
RMAN>

 

【switch database to copy】的时候你可能会遇到这样的错误：

 
1
2
3
4
5
6
7
8
9
RMAN> switch database to copy;
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 01/24/2018 18:06:32
RMAN-06571: datafile 1 does not have recoverable copy
 
RMAN>

 

可以改用下面的命令恢复：

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
RMAN> restore datafile 418;
 
Starting restore at 24-JAN-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=899 device type=DISK
 
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 00418 to /oracle/ORA/db_data14/xer_383/xer.383data
channel ORA_DISK_1: reading from backup piece /oracle_backup/datafile_417to420/ForStandby_d6spg6nj_1_1
channel ORA_DISK_1: errors found reading piece handle=/oracle_backup/datafile_417to420/ForStandby_d6spg6nj_1_1
channel ORA_DISK_1: failover to piece handle=/oracle_backup/ac_rman_datafile/ForStandby_d6spg6nj_1_1 tag=FORSTANDBY0124
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:05
Finished restore at 24-JAN-18
 
RMAN>

 

可以通过文件系统以及数据库的v$datafile看到，确实数据文件恢复出来了：

文件系统

 
1
2
3
root@AIX-ME:/ # du -sm /oracle/ORA/db_data14/xer_382/xer.382data
30720.79        /oracle/ORA/db_data14/xer_382/xer.382data
root@AIX-ME:/ #

 

数据库v$datafile

 
1
2
3
4
5
6
7
8
9
10
11
SQL> select file#,name,bytes,checkpoint_change#,status from v$datafile where file# > 415;
 
     FILE# NAME                                               BYTES CHECKPOINT_CHANGE# STATUS
---------- --------------------------------------------- ---------- ------------------ -------
       416 /oracle/ORA/db_data20/xer_381/xer.381data     3.2212E+10      4577622073896 ONLINE
       417 /oracle/ORA/db_data14/xer_382/xer.382data     3.2212E+10      4577622073896 ONLINE
       418 /oracle/ORA/db_data14/xer_383/xer.383data     3.2212E+10      4577622073896 ONLINE
       419 /oracle/ORA/db_data14/xer_384/xer.384data              0      4577622073896 ONLINE
       420 /oracle/ORA/db_data14/xer_385/xer.385data              0      4577622073896 ONLINE
 
SQL>

按照上面的方法把所有的备库端的数据文件恢复后，就可以关库，然后重新将【catalog】指向之前根据SCN从主库拉取的RMAN备库端的差异备份：

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
@H_579_5406@70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
@H_255_5512@123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
AIX-ME:oraORA 4> rman target /
 
Recovery Manager: Release 11.2.0.2.0 - Production on Wed Jan 24 18:41:50 2018
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database (not started)
 
RMAN> startup nomount;
 
Oracle instance started
 
Total System Global Area   51309510656 bytes
 
Fixed Size                     2231608 bytes
Variable Size              30467424968 bytes
Database Buffers           20803747840 bytes
Redo Buffers                  36106240 bytes
 
RMAN> restore standby controlfile from '/oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1';
 
Starting restore at 24-JAN-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=227 device type=DISK
 
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
output file name=/oracle/ORA/origlogA/cntrl/controlstandby1.ctl
Finished restore at 24-JAN-18
 
RMAN>
 
RMAN> startup mount;
 
database is already started
database mounted
released channel: ORA_DISK_1
 
RMAN>
 
RMAN>
 
RMAN> catalog start with '/oracle_backup/ac_rman_datafile';
 
searching for all files that match the pattORA /oracle_backup/ac_rman_datafile
 
List of Files Unknown to the Database
=====================================
File Name: /oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_controlfile.bak
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d5spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d6spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d7spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d8spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_easot9an_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ebsot9ao_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ecsot9aq_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_edsot9as_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_eesot9au_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_rnsottd8_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ttsotuif_1_1
 
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
 
List of Cataloged Files
=======================
File Name: /oracle_backup/ac_rman_datafile/ForStandby_86sou91p_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_controlfile.bak
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d5spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d6spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d7spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_d8spg6nj_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_easot9an_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ebsot9ao_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ecsot9aq_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_edsot9as_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_eesot9au_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_rnsottd8_1_1
File Name: /oracle_backup/ac_rman_datafile/ForStandby_ttsotuif_1_1
 
RMAN>
 
RMAN> recover database noredo;
 
Starting recover at 24-JAN-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=227 device type=DISK
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oracle/ORA/db_data1/system_1/system.data1
destination for restore of datafile 00010: /oracle/ORA/db_data2/xer_7/xer.data7
destination for restore of datafile 00016: /oracle/ORA/db_data3/xer700x_5/xer700x.data5
destination for restore of datafile 00028: /oracle/ORA/db_data2/xer_14/xer.data14
destination for restore of datafile 00035: /oracle/ORA/db_data4/xer_21/xer.data21
destination for restore of datafile 00042: /oracle/ORA/db_data4/xer_28/xer.data28
destination for restore of datafile 00049: /oracle/ORA/db_data4/xer_36/xer.data36
destination for restore of datafile 00051: /oracle/ORA/db_data4/xer_37/xer.data37
destination for restore of datafile 00056: /oracle/ORA/db_data3/xer_42/xer.data42
destination for restore of datafile 00060: /oracle/ORA/db_data3/xer_46/xer.data46
destination for restore of datafile 00069: /oracle/ORA/db_data5/xer_54/xer.data54
destination for restore of datafile 00076: /oracle/ORA/db_data5/xer_61/xer.data61
destination for restore of datafile 00083: /oracle/ORA/db_data5/xer_68/xer.data68
destination for restore of datafile 00089: /oracle/ORA/db_data6/xer_73/xer.data73
destination for restore of datafile 00096: /oracle/ORA/db_data7/xer701_3/xer701.data3
destination for restore of datafile 00100: /oracle/ORA/db_data1/undo_2/undo.data2
destination for restore of datafile 00107: /oracle/ORA/db_data8/xer_84/xer.data84
destination for restore of datafile 00114: /oracle/ORA/db_data9/xer_91/xer.data91
destination for restore of datafile 00122: /oracle/ORA/db_data11/xer_98/xer.data98
destination for restore of datafile 00129: /oracle/ORA/db_data11/xer_105/xer.data105
destination for restore of datafile 00136: /oracle/ORA/db_data5/xer_112/xer.data112
destination for restore of datafile 00143: /oracle/ORA/db_data12/xer_119/xer.data119
destination for restore of datafile 00144: /oracle/ORA/db_data12/xer_120/xer.data120
destination for restore of datafile 00151: /oracle/ORA/db_data13/xer_127/xer.data127
destination for restore of datafile 00158: /oracle/ORA/db_data14/xer_134/xer.data134
destination for restore of datafile 00165: /oracle/ORA/db_data15/xer_141/xer.data141
destination for restore of datafile 00172: /oracle/ORA/db_data16/xer_148/xer.data148
destination for restore of datafile 00179: /oracle/ORA/db_data14/xer_155/xer.data155
destination for restore of datafile 00186: /oracle/ORA/db_data17/xer_162/xer.data162
destination for restore of datafile 00193: /oracle/ORA/db_data18/xer_169/xer.data169
destination for restore of datafile 00200: /oracle/ORA/db_data19/xer_176/xer.data176
destination for restore of datafile 00207: /oracle/ORA/db_data20/xer_183/xer.data183
destination for restore of datafile 00214: /oracle/ORA/db_data20/xer_190/xer.data190
destination for restore of datafile 00221: /oracle/ORA/db_data21/xer_197/xer.data197
destination for restore of datafile 00228: /oracle/ORA/db_data22/xer_204/xer.data204
destination for restore of datafile 00236: /oracle/ORA/db_data19/xer_211/xer.data211
destination for restore of datafile 00243: /oracle/ORA/db_data23/xer_218/xer.data218
destination for restore of datafile 00250: /oracle/ORA/db_data24/xer_225/xer.data225
destination for restore of datafile 00257: /oracle/ORA/db_data23/xer_232/xer.data232
destination for restore of datafile 00264: /oracle/ORA/db_data23/xer_239/xer.data239
destination for restore of datafile 00271: /oracle/ORA/db_data24/xer_246/xer.data246
destination for restore of datafile 00278: /oracle/ORA/db_data24/xer_253/xer.data253
destination for restore of datafile 00294: /oracle/ORA/db_data9/xer_266/xer.data266
destination for restore of datafile 00301: /oracle/ORA/db_data22/xer_272/xer.data272
destination for restore of datafile 00304: /oracle/ORA/db_data9/xer_275/xer.data275
destination for restore of datafile 00311: /oracle/ORA/db_data6/xer_282/xer.data282
destination for restore of datafile 00318: /oracle/ORA/db_data23/xer_289/xer.data289
destination for restore of datafile 00326: /oracle/ORA/db_data11/xer_296/xer.data296
destination for restore of datafile 00336: /oracle/ORA/db_data14/xer_305/xer.305data
destination for restore of datafile 00345: /oracle/ORA/db_data13/xer_312/xer.312data
destination for restore of datafile 00352: /oracle/ORA/db_data16/xer_319/xer.319data
destination for restore of datafile 00361: /oracle/ORA/db_data7/xer_326/xer.326data
destination for restore of datafile 00368: /oracle/ORA/db_data21/xer_333/xer.333data
destination for restore of datafile 00375: /oracle/ORA/db_data16/xer_340/xer.340.data
destination for restore of datafile 00382: /oracle/ORA/db_data19/xer_347/xer.347data
destination for restore of datafile 00389: /oracle/ORA/db_data8/xer_354/xer.354data
destination for restore of datafile 00396: /oracle/ORA/db_data18/xer_361/xer.361data
destination for restore of datafile 00403: /oracle/ORA/db_data18/xer_368/xer.368data
destination for restore of datafile 00410: /oracle/ORA/db_data13/xer_375/xer.375data
channel ORA_DISK_1: reading from backup piece /bbbb/db_incr_20180117/ForStandby_ebsot9ao_1_1
 
（过多的输出，... ）
 
channel ORA_DISK_1: reading from backup piece /bbbb/db_incr_20180117/ForStandby_ttsotuif_1_1
channel ORA_DISK_1: piece handle=/bbbb/db_incr_20180117/ForStandby_ttsotuif_1_1 tag=FORSTANDBY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:38:56
 
Finished recover at 24-JAN-18
Recovery Manager complete.
 
RMAN>

 

这就好了。

然后，备库就可以拉起同步了。

——————————————————Done。

脚本宝典总结

以上是脚本宝典为你收集整理的RMAN ERROR：RMAN-06094: DATAFILE 417 MUST BE RESTORED全部内容，希望文章能够帮你解决RMAN ERROR：RMAN-06094: DATAFILE 417 MUST BE RESTORED所遇到的问题。

如果觉得脚本宝典网站内容还不错，欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。
标签：javalistpartitionphppython数据库数据库文档文档程序员程序员
猜你在找的心得技巧相关文章
其他相关热搜词更多
phpjavapython程序员loadpost-format-gallerydivString参数开发ListcapMapClass工具安装SQL数据库资源this
全站导航更多
html5HTML/XhtmlCSSXML/XSLTDreamweaver教程Frontpage教程心得技巧JavaScriptASP.NETPHP编程正则表达式AJAX相关ASP编程JSP编程编程10000问CSS/HTMLFlexvbsDOS/BAThtahtcpythonperl游戏相关VBA远程脚本ColdFusionMsSqlMysqlmariadboracleDB2mssql2008mssql2005SQLitePostgreSQLMongoDB星外虚拟主机华众虚拟主机Linuxwin服务器FTP服务器DNS服务器Tomcatnginxzabbix云和虚拟化bios系统安装系统系统进程Windows系列LINUXRedHat/CentosUbuntu/DebianFedoraSolaris红旗Linux建站经验微信营销网站优化网站策划网络赚钱网络创业站长故事alexa域名photoshop教程摄影教程Fireworks教程CorelDraw教程Illustrator教程Painter教程Freehand教程IndesignSketch笔记本主板内存CPU存储显卡显示器光存储鼠标键盘平板电脑安全教程杀毒防毒安全设置病毒查杀脚本攻防入侵防御工具使用业界动态Exploit漏洞分析
最新心得技巧教程
热门心得技巧教程