**一个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

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

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
```

**可以打开，数据存在**

ITPub博客

Oracle 不完全恢复遇到的ORA-600错误

最新文章