При попытке воссоздать базу данных из бекапа выбивает ошибку ORA-01152:
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.
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.
123.
RMAN> duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 07-MAY-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
contents of Memory Script:
{
set until scn 1433925;
restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 07-MAY-17
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece E:\APP\ORACLE\DATA\BACKUP\0FS3KRFE
channel ORA_AUX_DISK_1: piece handle=E:\APP\ORACLE\DATA\BACKUP\0FS3KRFE tag=TAG20170507T103410
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=C:\APP\ORACLE\ORADATA\TEST\CONTROL01.CTL
output file name=C:\APP\ORACLE\ORADATA\TEST\CONTROL02.CTL
Finished restore at 07-MAY-17
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set until scn 1433925;
set newname for tempfile 1 to
"E:\APP\ORACLE\ORADATA\TEST\TEMP01.DBF";
switch clone tempfile all;
set newname for datafile 1 to
"E:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF";
set newname for datafile 2 to
"E:\APP\ORACLE\ORADATA\TEST\SYSAUX01.DBF";
set newname for datafile 3 to
"E:\APP\ORACLE\ORADATA\TEST\UNDOTBS01.DBF";
set newname for datafile 4 to
"E:\APP\ORACLE\ORADATA\TEST\USERS01.DBF";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed tempfile 1 to E:\APP\ORACLE\ORADATA\TEST\TEMP01.DBF in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 07-MAY-17
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to E:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF
channel ORA_AUX_DISK_1: restoring datafile 00002 to E:\APP\ORACLE\ORADATA\TEST\SYSAUX01.DBF
channel ORA_AUX_DISK_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
channel ORA_AUX_DISK_1: restoring datafile 00004 to E:\APP\ORACLE\ORADATA\TEST\USERS01.DBF
channel ORA_AUX_DISK_1: reading from backup piece E:\APP\ORACLE\DATA\BACKUP\0ES3KRD2
channel ORA_AUX_DISK_1: piece handle=E:\APP\ORACLE\DATA\BACKUP\0ES3KRD2 tag=TAG20170507T103410
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:16
Finished restore at 07-MAY-17
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=943372611 file name=E:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=943372611 file name=E:\APP\ORACLE\ORADATA\TEST\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=943372611 file name=E:\APP\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=943372611 file name=E:\APP\ORACLE\ORADATA\TEST\USERS01.DBF
contents of Memory Script:
{
set until scn 1433925;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 07-MAY-17
using channel ORA_AUX_DISK_1
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF'
