**一个resetlogs恢复表的场景：** 场景描述： 数据正常运行，由于表B丢失，此时进行一次不完全恢复，不完全恢复至scn1067392，然后进行open resetlogs打开，此时开启了一个新的化身线，在刚打开后，又误删除了表A，此时想要恢复表A，将表A再次恢复至scn1067392，将表A进行恢复。 **进行一次全备：** ``` [oracle@server1 ~]$ rman target / RMAN> backup as compressed backupset database; ``` **查看数据库当前化身线：** ``` RMAN> list incarnation using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 PROD 457994418 PARENT 1 24-AUG-13 2 2 PROD 457994418 CURRENT 925702 19-JUL-20 ``` **创建两张表（A和B）：** ``` SQL> create table A as select * from dba_objects; Table created. SQL> insert into A select * from A; 86958 rows created. SQL> create table B as select * from dba_objects; Table created. SQL> insert into B select * from B; 86958 rows created. **进行几次日志切换：** SQL> alter system switch logfile; ``` **查看当前SCN：** ``` SQL> select current_scn from v$database; CURRENT_SCN 1067392 ``` **清空表B数据：** ``` SQL> truncate table B; Table truncated. ``` **使用RMAN进行不完全恢复至1067392，将表B恢复：** ``` 启动到mount状态进行恢复 RMAN> restore database; RMAN> recover database until scn 1067392; SQL> alter database open resetlogs; Database altered. SQL> select count(*) from B; COUNT(*) 173914 ``` **查看当前化身：** ``` RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 PROD 457994418 PARENT 1 24-AUG-13 2 2 PROD 457994418 PARENT 925702 19-JUL-20 3 3 PROD 457994418 CURRENT 1067393 21-AUG-20 **记录一下Open resetlogs后的当前SCN：** SQL> select current_scn from v$database; CURRENT_SCN 1067920（和上面化身线的点还是很大距离的） **此时刚进行不完全恢复open resetlogs打开后，我又把表A删了：** SQL> truncate table A; Table truncated. ``` 此时可以不完全恢复至**1067920，恢复表A** **但是我尝试再次恢复至SCN1067392，出现ORA-600错误：** **（多次测试，恢复至与上一样不完全恢复相同的SCN是必报的错误）** 指定化身线2： ``` RMAN> reset database to incarnation 2； RMAN> restore database; RMAN> recover database until scn 1067392; SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [2898], [5], [12], [], [], [], [], [], [], [], [], [] Process ID: 3633 Session ID: 191 Serial number: 13 ``` **后台警告日志：** ``` Checker run found 2 new persistent data failures ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE error 25319 happened during Queue table repartitioning Starting background process QMNC Fri Aug 21 07:23:45 2020 QMNC started with pid=27, OS id=3364 LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Fri Aug 21 07:23:45 2020 error 376 happened for queue:IX.STREAMS_QUEUE_TABLE during timed act Completed: alter database open Fri Aug 21 07:23:45 2020 Dumping diagnostic data in directory=[cdmp_20200821072345], requested by (instance=1, osid=3342), summary=[incident=12166]. Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mmon_3322.trc (incident=12134): ORA-25319: Queue table repartitioning aborted Incident details in: /oracle/app/diag/rdbms/prod/prod/incident/incdir_12134/prod_mmon_3322_i12134.trc error 25319 happened during Queue table repartitioning error 376 happened for queue:IX.STREAMS_QUEUE_TABLE during timed act Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mmon_3322.trc (incident=12135): ORA-25319: Queue table repartitioning aborted Incident details in: /oracle/app/diag/rdbms/prod/prod/incident/incdir_12135/prod_mmon_3322_i12135.trc Dumping diagnostic data in directory=[cdmp_20200821072347], requested by (instance=1, osid=3322 (MMON)), summary=[incident=12134]. error 25319 happened during Queue table repartitioning error 376 happened for queue:IX.STREAMS_QUEUE_TABLE during timed act Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mmon_3322.trc (incident=12136): ORA-25319: Queue table repartitioning aborted Incident details in: /oracle/app/diag/rdbms/prod/prod/incident/incdir_12136/prod_mmon_3322_i12136.trc Dumping diagnostic data in directory=[cdmp_20200821072348], requested by (instance=1, osid=3322 (MMON)), summary=[incident=12135]. error 25319 happened during Queue table repartitioning ``` **使用RMAN启动到mount状态，查看一下当前化身** ``` [oracle@server1 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Aug 21 02:08:55 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup mount; Oracle instance started database mounted Total System Global Area 830930944 bytes Fixed Size 2257800 bytes Variable Size 541068408 bytes Database Buffers 281018368 bytes Redo Buffers 6586368 bytes RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 PROD 457994418 PARENT 1 24-AUG-13 2 2 PROD 457994418 PARENT 925702 19-JUL-20 3 3 PROD 457994418 ORPHAN 1067393 21-AUG-20 4 4 PROD 457994418 CURRENT 1067393 21-AUG-20 **显示当前已经出现一个分支。** ``` **尝试直接Open** ``` [oracle@server1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 21 02:11:03 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database open; Database altered. SQL> select count(*) from A; COUNT(*) 173914 ``` **可以打开，数据存在**