6、再次查看incarnation
发现多了DB为15的incarnation,14号已经成为PARENT
rman target /
list incarnation;
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 CDEDB 1098994247 PARENT 1 2009-08-15 00:16:43
2 2 CDEDB 1098994247 PARENT 945184 2020-02-25 23:07:53
3 3 CDEDB 1098994247 PARENT 1333990 2020-02-26 22:23:44
4 4 CDEDB 1098994247 PARENT 1439720 2020-02-27 16:25:23
5 5 CDEDB 1098994247 PARENT 1441999 2020-02-27 16:42:36
6 6 CDEDB 1098994247 PARENT 1484693 2020-02-27 22:00:15
7 7 CDEDB 1098994247 PARENT 1498781 2020-02-27 22:39:41
8 8 CDEDB 1098994247 PARENT 2881352 2020-03-17 12:42:41
9 9 CDEDB 1098994247 PARENT 2881930 2020-03-17 12:54:21
10 10 CDEDB 1098994247 PARENT 2882672 2020-03-17 13:05:33
11 11 CDEDB 1098994247 PARENT 2887632 2020-03-17 14:36:40
12 12 CDEDB 1098994247 PARENT 2901140 2020-03-17 19:10:10
13 13 CDEDB 1098994247 PARENT 2901545 2020-03-17 19:14:53
14 14 CDEDB 1098994247 PARENT 2901866 2020-03-17 19:23:48
15 15 CDEDB 1098994247 CURRENT 2906870 2020-03-17 21:06:02
7、继续做实验看看什么情况下incarnation会出现ORPHAN状态
7.1为了让效果明显一些,再重复以上步骤。
添加数据
insert into goods (id,gname) values (2,'bb');
commit;
alter system switch logfile;
记录当前scn号
select current_scn from v$database;
CURRENT_SCN
-----------
2908385
再添加数据
insert into goods (id,gname) values (3,'cc');
commit;
alter system switch logfile;
按前面的操作还原到scn为2907853的时候。
查看数据,发现还原成功。
再次查看incarnation
发现多了DB为17的incarnation,16号已经成为PARENT
7.2 目前要求是按前面的操作想还原最初的scn为2906869的时候。
这时出现报错:
Starting restore at 2020-03-17 21:45:51
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/17/2020 21:45:51
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
原因是要先要回到DB为14的incarnation,再进行恢复
reset database to incarnation 14;
再要求是按前面的操作
查看数据,发现还原成功。
再次查看incarnation
发现多了DB为18的incarnation,15-17号已经成为ORPHAN